Untitled query #8953

This query is marked as a draft This query has been published by రహ్మానుద్దీన్.

SQL

use knwikisource_p;
SELECT
	page_title AS title,
	page_len AS len,
    MAX(rev_timestamp) AS date
FROM
	page JOIN revision ON page_id = rev_page
WHERE
	page_namespace = 0 AND
	page_is_redirect = 0 AND
	page_id NOT IN (SELECT DISTINCT
                    	tl_from
                    FROM
                    	templatelinks,
                    	page
                    WHERE
                    	page_id=tl_from AND
                    	tl_namespace = 104 AND
                    	page_namespace = 0) AND
	page_id NOT IN (SELECT
                    	page_id
                    FROM
                    	page,
                    	templatelinks
                    WHERE
                    	page_id=tl_from AND
                    	page_namespace=0 AND
                    	tl_namespace=10 AND
                    	tl_title='Disambig')
GROUP BY title
ORDER BY date DESC
LIMIT 40;

SQL

Checking query status...