This query is marked as a draft This query has been published by BilledMammal.

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.

Checking query status...