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")
LEFT JOIN externallinks AS cricketarchive ON cricketarchive.el_from = page_id AND LEFT(cricketarchive.el_index,20) = "https://com.cricketa"
#WHERE espn.el_index LIKE "%/Players/%" OR el_index LIKE "%/player/%"
SQL

Checking query status...
