(SELECT 'c500p500y4' AS TABLE_NAME, *
FROM   c500p500y4.orderitem
WHERE amount<10)
UNION ALL
(SELECT 'c500p500y2' AS TABLE_NAME, *
FROM   c500p500y2.orderitem
WHERE amount<10)
UNION ALL
(SELECT 'c5000p1000y2' AS TABLE_NAME, *
FROM   c5000p1000y2.orderitem
WHERE amount<10)
UNION ALL
(SELECT 'c5000p1000y4' AS TABLE_NAME, *
FROM   c5000p1000y4.orderitem
WHERE amount<10)
UNION ALL
(SELECT 'c100p500y2' AS TABLE_NAME, *
FROM   c100p500y2.orderitem
WHERE amount<10)
UNION ALL
(SELECT 'c1000p500y5' AS TABLE_NAME, *
FROM   c1000p500y3.orderitem
WHERE amount<10)
UNION ALL
(SELECT 'c1000p500y3' AS TABLE_NAME, *
FROM   c1000p500y5.orderitem
WHERE amount<10)

;