mysql union联合查询 order by

SELECT f4.obj_id,f4.type FROM (SELECT f.* FROM favorites f WHERE f.user=? AND f.type=? UNION SELECT f1.* FROM favorites f1 WHERE f1.user=? AND f1.type=? UNION SELECT f2.* FROM favorites f2 WHERE f2.user=? AND f2.type=? UNION SELECT f3.* FROM favorites f3 WHERE >f3.user=? AND f3.type=? ) AS f4 LEFT JOIN favor_tags t ON f4.user=t.user AND f4.type=t.obj_type AND f4.obj_id=t.obj_id ORDER BY f4.create_time desc";

转载于:https://my.oschina.net/hackway/blog/631101