select id , logo , date , px = 1 from t1 where logo = '1' union all select id , logo , date , px = 2 from t2 where logo = '1' union all select id , logo , date , px = 3 from t3 where logo = '1' order by id , logo , date , px
select id,logo,date from t1 where logo='1' union all select id,logo,date from t2 where logo='1' union all select id,logo,date from t3 where logo='1'
select * from ( select id ,date from t1 where logo = '1' union all select id ,date from t2 where logo = '1' union all select id ,date from t3 where logo = '1' ) t order by id
select id,logo,date from t1 where logo='1' union all select id,logo,date from t2 where logo='1' union all select id,logo,date from t3 where logo='1'
union all
select id , logo , date , px = 2 from t2 where logo = '1'
union all
select id , logo , date , px = 3 from t3 where logo = '1'
order by id , logo , date , px
union all
select id,logo,date from t2 where logo='1'
union all
select id,logo,date from t3 where logo='1'
(
select id ,date from t1 where logo = '1'
union all
select id ,date from t2 where logo = '1'
union all
select id ,date from t3 where logo = '1'
) t order by id
union all
select id,logo,date from t2 where logo='1'
union all
select id,logo,date from t3 where logo='1'