SELECT
    CONCAT('', join_table.seq_coalesce) AS col_concat,
    join_table.seq_coalesce AS col_one,
    join_table.seq_coalesce AS col_two,
    CONCAT('', join_table.seq_ifnull) AS col_ifnull_concat,
    join_table.seq_ifnull AS col_ifnull_one,
    join_table.seq_ifnull AS col_ifnull_two,
    join_table.seq_vanilla AS col_vanilla_one,
    join_table.seq_vanilla AS col_vanilla_two
FROM
    seq_1_to_1_step_1 AS main_table
LEFT JOIN(
    SELECT
        tmp.seq AS seq_vanilla,
        COALESCE(tmp.seq) AS seq_coalesce,
        IFNULL(tmp.seq, 42) AS seq_ifnull
    FROM
        seq_1_to_1_step_1 tmp
) AS join_table
ON
    join_table.seq_vanilla = main_table.seq
WHERE
  main_table.seq = 1
GROUP BY
  main_table.seq;
