select * from
(select * from tabel
where .....
)a
join
(
select * from tabel
where ....
)b a.id = b.id
join
(
select * from tabel
where ...
)c on a.id = c.value
08-04
2620
12-13
2万+
07-09
1022
04-28
3100
07-09