1 2 3 4
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 2;