USE fawiki_p;

SELECT REPLACE(concat('بحث:',t.page_title),'_',' ')#, t.page_len

FROM page AS t

WHERE t.page_namespace  = 1

AND t.page_is_redirect = 0

AND t.page_len > 0

​

#AND t.page_title LIKE "خورشیدگرفتگی_%"

​

AND EXISTS (

  SELECT null

  FROM page AS p

  WHERE p.page_namespace = 0

  AND p.page_title = t.page_title

  AND p.page_is_redirect = 1

)

​

AND t.page_id IN (

  SELECT page_id

  FROM page JOIN templatelinks ON page_id = tl_from

  WHERE tl_from_namespace = 1

  AND tl_title = 'ویکی•پروژه_نسخه_آفلاین'

  AND tl_namespace = 10

#  AND page_len < 500

  )

ORDER BY t.page_len DESC;