mysql縦持ち

SELECT 
    ad_id,
    ad_name1,
    ad_01_1,
    1 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_01_2,
    2 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_02,
    3 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_03,
    4 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_04,
    5 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_05,
    6 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_06,
    7 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_07,
    8 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_08,
    9 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_09,
    10 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_10,
    11 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_11,
    12 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_12,
    13 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_13_01,
    14 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_13_02,
    15 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_14,
    16 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_15,
    17 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_16,
    18 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_17,
    19 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_18,
    20 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_19,
    21 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_20,
    22 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_21,
    23 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_22,
    24 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_23,
    25 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_24,
    26 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_25,
    27 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_26,
    28 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_27,
    29 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_28,
    30 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_29,
    31 AS column_iteration
FROM ad_tb
UNION ALL
SELECT 
    ad_id,
    ad_name1,
    ad_30,
    32 AS column_iteration
FROM ad_tb;