USE fawiki_p;

SELECT REPLACE(page_title,'_',' '), cl_to

FROM page JOIN templatelinks ON tl_from = page_id JOIN categorylinks ON cl_from = page_id

WHERE page_namespace = 0

AND tl_title LIKE 'جعبه_اطلاعات_جای•های_تاریخی_ایران'

​

AND cl_to LIKE '%آثار%'

AND cl_to NOT LIKE '%دوره%'

​

/*

AND page_id NOT IN (

  SELECT cl_from

  FROM categorylinks

  WHERE cl_to LIKE '%دوره%'

)

*/

​

ORDER BY page_title;