SQL
AخA
SELECT CONCAT("# [[", page_title, "]], (", DATE_FORMAT(rev_timestamp, '%e %b %Y, %H:%i'), ")")
FROM page, revision
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_page = page_id
AND rev_parent_id = 0
AND page_len BETWEEN 1000 AND 1200
AND page_title IN (
SELECT pl_title
FROM pagelinks
WHERE pl_from_namespace = 0
AND pl_namespace = 0
AND pl_title = page_title
AND pl_from NOT IN
(SELECT page_id
FROM page
WHERE page_is_redirect = 1)
AND pl_from NOT IN
(SELECT cl_from
FROM categorylinks, pagelinks
WHERE cl_to = pl_title
AND pl_namespace = 14
AND pl_from = 4195411)
GROUP BY pl_title HAVING COUNT(*)=1
)
AND page_id NOT IN
(SELECT DISTINCT cl_from
FROM categorylinks, pagelinks
WHERE cl_to = pl_title
AND pl_namespace = 14
AND pl_from = 4195411)
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks
WHERE cl_to LIKE 'Brocardi%'
OR cl_to LIKE 'Proverbi%'
OR cl_to LIKE 'Motti%'
OR cl_to LIKE 'Frasi%'
OR cl_to LIKE 'Modi_di_dire%'
OR cl_to LIKE 'Terminologia%latina'
OR cl_to LIKE 'Prenomi%'
OR cl_to LIKE 'Cognomi%'
OR cl_to LIKE '%Groenlandia'
OR cl_to LIKE '%araldiche'
)
AND page_id NOT IN
(SELECT DISTINCT tl_from
FROM templatelinks
WHERE tl_target_id IN
(SELECT DISTINCT lt_id
FROM linktarget
WHERE lt_namespace = 10
AND lt_title IN ('Album','Artista_musicale','Azienda','Bio','Brano_musicale','Cocktail','Composizione_musicale','Composto_chimico','Computer','Coro','Disclaimer','Dramma','Edificio_civile','Edificio_religioso','Esogeologia','FictionTV','Film','Fiume','Fumetto_e_animazione','Gastronomia','Gioco','Gruppi_EC','Libro','Minerale','Opera','Opera_d''arte','Organizzazione','Montagna','Programma','Rifugio','Tassobox','Valico','Videogioco','Vino','Vitigno')))
AND page_id NOT IN
(SELECT ll_from
FROM langlinks)
ORDER BY rev_timestamp;
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.