Untitled query #75711

SQL

SELECT page_title, birth.cl_to AS birth, death.cl_to AS death, espn.el_to AS espnsource, cricketarchive.el_to AS cricketarchive
FROM page
JOIN categorylinks AS wp ON wp.cl_from = page_id AND wp.cl_to = "Western_Province_cricketers"
LEFT JOIN categorylinks AS birth ON birth.cl_from = page_id AND birth.cl_to LIKE "%births"
LEFT JOIN categorylinks AS death ON death.cl_from = page_id AND death.cl_to LIKE "%deaths"
LEFT JOIN externallinks AS espn ON espn.el_from = page_id AND LEFT(espn.el_index,20) IN ("https://com.espncric","http://com.espncrici") AND espn.el_index LIKE "%/player/%.html"
LEFT JOIN externallinks AS cricketarchive ON cricketarchive.el_from = page_id AND LEFT(cricketarchive.el_index,20) = "https://com.cricketa" AND cricketarchive.el_index REGEXP "^.+/Players/.+/\d+.html$"
GROUP BY page_title
SQL

Checking query status...
