Articles with 'The...'

SQL

USE cswiki_p;
SELECT page_title, cl_to AS kategorie, pp_value AS defaultsort
	FROM categorylinks
	JOIN page
		ON page_id = cl_from
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'defaultsort') AS sorted
		ON pp_page = page_id
WHERE page_namespace = 0
AND page_title LIKE 'The&_%' ESCAPE '&'
AND (pp_value IS NULL OR pp_value LIKE 'The %')
AND cl_to NOT LIKE 'Údržba:%'
AND cl_to NOT LIKE 'Monitoring:%'
AND cl_to NOT LIKE 'Wikipedie:%'
AND cl_to NOT LIKE 'Přesměrování%'
AND cl_to NOT IN ('Pahýly', 'Částečné_pahýly')
ORDER BY page_title, cl_to;
SQL

Checking query status...
