970601 mp1 # of DAB pages with redirected link (pages)

SQL

SELECT ll_title, page_namespace, cl_to
FROM enwiki_p.langlinks
JOIN enwiki_p.page ON ll_from = page_id RIGHT JOIN enwiki_p.categorylinks ON page_id = cl_from #LEFT JOIN fawiki_p.categorylinks ON cl_from = page_id
WHERE (
  page_namespace = 14
  OR page_namespace = 0
)
AND page_is_redirect = 0
AND ll_lang = 'fa'
#AND ll_lang = "en"
AND (
cl_to LIKE "Current_wildfires"
OR cl_to LIKE "East_Germany_at_multi-sport_events"
OR cl_to LIKE "West_Germany_at_multi-sport_events"
OR cl_to LIKE "Antigua_and_Barbuda_at_multi-sport_events"
OR cl_to LIKE "Anguilla_at_multi-sport_events"
OR cl_to LIKE "Armenia_at_multi-sport_events"
OR cl_to LIKE "Eritrea_at_multi-sport_events"
OR cl_to LIKE "Finnish_people_executed_by_the_Soviet_Union"
OR cl_to LIKE "Drama_Desk_Award_for_musicals_templates"
OR cl_to LIKE "Hungary_infobox_templates"
);
SQL

Checking query status...
