SQL
AخA
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/%"
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.