Test #1 - Quarry

SQL

USE itwiki_p.page;
SELECT CONCAT( "# [[Utente:", page_title, "]]" )
	FROM page
	WHERE page_namespace =2
		AND page_is_redirect =0
		AND page_id IN (
 			SELECT cl_from FROM categorylinks
 				WHERE cl_to NOT LIKE "Utent%"
				AND cl_to NOT LIKE "Pagine_non_indicizzate"
                AND cl_to NOT LIKE "Pagine_utente_protette%"
                AND cl_to NOT LIKE "Soft_redirect"
                AND cl_to NOT LIKE "Soci_Wikimedia_Italia"
                AND cl_to NOT LIKE "Staff_della_Wikimedia_Foundation"
                AND cl_to NOT LIKE "IP_noti"
                AND cl_to NOT LIKE "IP_statici"
                AND cl_to NOT LIKE "Vandali_di_Wikipedia"
                AND cl_to NOT LIKE "%bot%"
                AND cl_to NOT LIKE "%scherzi%"
                AND cl_to NOT LIKE "%wikidata%"
                AND cl_to NOT LIKE "Wiki%"
                AND cl_to NOT LIKE "Voci_tradotte%"
                AND cl_to NOT LIKE "Template_complessi"
                AND cl_to NOT LIKE "Voci_con_templat%"
                AND cl_to NOT LIKE "Segnalazioni_automatiche%"
                AND cl_to NOT LIKE "Progett%"
                AND cl_to NOT LIKE "Portali_in_preparazione"
                AND cl_to NOT LIKE "Promemoria"
                AND cl_to NOT LIKE "Liste_in_aggiornamento"
                AND cl_to NOT LIKE "Errori_di_compilazion%")
	ORDER BY page_title;
SQL

Checking query status...
