Untitled query #75711

SQL

SELECT page_title, birth.cl_to AS birth, death.cl_to AS death, el_to AS source
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 ON el_from = page_id AND LEFT(el_index,20) IN ("https://com.espncric","http://com.espncrici","https://com.cricketa")
	AND LEFT(el_index,34) NOT IN ("https://com.espncricinfo.www./wisd",
                                "http://com.espncricinfo.www./wisde",
                                "https://com.espncricinfo.www./stor",
                                "http://com.espncricinfo.www./story")
       AND el_index NOT LIKE "http://com.espncricinfo.www./%/content/story/%"
       AND el_index NOT LIKE "https://com.espncricinfo.www./%/content/story/%"
SQL

Checking query status...
