SELECT num, COUNT(num) AS `count` FROM ( SELECT num FROM aaa UNION ALL SELECT num FROM bbb UNION ALL SELECT num FROM ccc ) AS Temp GROUP BY numORDER BY num
