PowerCMS Xで複数のモデルのデータを日付順に並べる
SQL
(SELECT 'blog' as model, `blog_id` as id, `blog_published_on` as published_on FROM `mt_blog`) UNION (SELECT 'event' as model, `event_id` as id, `event_published_on` as published_on FROM `mt_event`) UNION (SELECT 'report' as model, `report_id` as id, `report_published_on` as published_on FROM `mt_report`) UNION (SELECT 'recruitment' as model, `recruitment_id` as id, `recruitment_published_on` as published_on FROM `mt_recruitment`) ORDER BY published_on DESC LIMIT 20;