pl ws -> Indexes with non transcluded Pages

SQL

SELECT count(SUBSTRING_INDEX(page_title, '/', 1)) as non_trns, SUBSTRING_INDEX(page_title, '/', 1) as title, MAX(cl_timestamp) as time FROM categorylinks LEFT JOIN page ON page_id=cl_from
	WHERE cl_to in ('Uwierzytelniona', 'Skorygowana', 'Przepisana') AND page_title NOT IN
		(SELECT tl_title FROM templatelinks
			WHERE tl_namespace=100 AND tl_from_namespace=0)
	GROUP BY SUBSTRING_INDEX(page_title, '/', 1)
 	ORDER BY non_trns DESC;

AخA
 
SELECT count(SUBSTRING_INDEX(page_title, '/', 1)) as non_trns, SUBSTRING_INDEX(page_title, '/', 1) as title, MAX(cl_timestamp) as time FROM categorylinks LEFT JOIN page ON page_id=cl_from    WHERE cl_to in ('Uwierzytelniona', 'Skorygowana', 'Przepisana') AND page_title NOT IN        (SELECT tl_title FROM templatelinks            WHERE tl_namespace=100 AND tl_from_namespace=0)    GROUP BY SUBSTRING_INDEX(page_title, '/', 1)    ORDER BY non_trns DESC;

SQL

Checking query status...