SELECT rev_timestamp,rc_timestamp,page_id,page_title,GROUP_CONCAT(DISTINCT cl_to,', ')

FROM categorylinks,page

LEFT OUTER JOIN recentchanges ON rc_cur_id=page_id AND rc_new=1

LEFT OUTER JOIN revision ON rev_page=page_id AND rev_parent_id=0 WHERE cl_to IN

('Women_architects','Women_architects_by_nationality','Albanian_women_architects','American_women_architects','Angolan_women_architects','Argentine_women_architects','Australian_women_architects','Austrian_women_architects','Bangladeshi_women_architects','Belarusian_women_architects','Belgian_women_architects','Belizean_women_architects','Bosnia_and_Herzegovina_women_architects','British_women_architects','Bulgarian_women_architects','Canadian_women_architects','Chilean_women_architects','Chinese_women_architects','Croatian_women_architects','Cuban_women_architects','Czech_women_architects','Danish_women_architects','Dominican_Republic_women_architects','Dutch_women_architects','Egyptian_women_architects','Estonian_women_architects','Finnish_women_architects','French_women_architects','German_women_architects','Greek_women_architects','Icelandic_women_architects','Indian_women_architects','Iranian_women_architects','Iraqi_women_architects','Irish_women_architects','Israeli_women_architects','Italian_women_architects','Jamaican_women_architects','Japanese_women_architects','Kenyan_women_architects','Libyan_women_architects','Luxembourgian_women_architects','Mexican_women_architects','Moldovan_women_architects','Montenegrin_women_architects','Nepalese_women_architects','New_Zealand_women_architects','Nigerian_women_architects','Norwegian_women_architects','Pakistani_women_architects','Palestinian_women_architects','Polish_women_architects','Portuguese_women_architects','Puerto_Rican_women_architects','Romanian_women_architects','Russian_women_architects','Saudi_Arabian_women_architects','Serbian_women_architects','Singaporean_women_architects','Slovenian_women_architects','South_African_women_architects','Spanish_women_architects','Sri_Lankan_women_architects','Swedish_women_architects','Swiss_women_architects','Taiwanese_women_architects','Thai_women_architects','Turkish_women_architects','Venezuelan_women_architects','Women_landscape_architects')

AND cl_from=page_id AND page_namespace=0 GROUP BY page_id ORDER BY rev_timestamp DESC