SELECT * FROM (
SELECT *,1 FROM fi_osc1.schedule_task_1 WHERE status = 10 and create_time >='2018-09-10 10:00:00'
UNION ALL
SELECT *,2 FROM fi_osc2.schedule_task_1 WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,3 FROM fi_osc3.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,4 FROM fi_osc4.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,5 FROM fi_osc5.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,6 FROM fi_osc6.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,7 FROM fi_osc7.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,8 FROM fi_osc8.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,9 FROM fi_osc9.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *, 10 FROM fi_osc10.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,11 FROM fi_osc11.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,12 FROM fi_osc12.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,13 FROM fi_osc13.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,14 FROM fi_osc14.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,15 FROM fi_osc15.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,16 FROM fi_osc16.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,17 FROM fi_osc17.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,18 FROM fi_osc18.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,19 FROM fi_osc19.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
UNION ALL
SELECT *,20 FROM fi_osc20.`schedule_task_1` WHERE status = 10 and create_time >='2018-09-10 0:00:00'
) t