SQL
AخA
SELECT CONCAT('# [[', page_title, ']]')
FROM page, revision
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_parent_id = 0
AND rev_timestamp BETWEEN 20020101000000 AND 20070101000000
AND page_id IN (SELECT tl_from
FROM templatelinks
WHERE tl_namespace = 10
AND tl_title IN ('Bio'))
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks
WHERE cl_to LIKE '%_italian%')
AND page_id NOT IN
(SELECT ll_from
FROM langlinks)
ORDER BY page_len DESC;
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.