Voci con suggerimento immagine che hanno un'immagine

SQL

use itwiki_p; 
SELECT DISTINCT page_title
FROM page, imagelinks
WHERE page_id = il_from
AND page_namespace = 0
AND il_from_namespace = 0
AND il_to NOT LIKE '%.svg' 
AND il_to NOT IN ('Nuvola_mimetypes_charnotfound.PNG', 'Crystal_kcontrol.png', 'Galileo_Galilei_(circled).png',
                  'Crystal_Project_konquest.png', 'Digitální_ověřování_ve_virtuálním_prostředí.png', 'LupaCapitolina.png',
                 'Parthenon.jpg', 'ARP_Omni_Mk1.jpg', 'Flag_of_Friuli-Venezia_Giulia.jpg', 'Tennis_icon_nobkg.png',
                 'Munari_fork.png', 'ReligionSymbol.png', 'H._P._Lovecraft,_June_1934.jpg', 'IDF-logo.gif',
                 'Plo_emblem.png', 'Muslim_Brotherhood_Emblem.jpg')
AND page_title IN (
SELECT page_title
FROM page JOIN categorylinks
ON page_id = cl_from
WHERE page_namespace = 1
AND cl_to = 'Suggerimento_immagini'
)
ORDER BY page_title;
SQL

Checking query status...
