Voci it.wiki senza interwiki con titolo uguale in en.wiki (no disambigue)

This query is marked as a draft This query has been published by Mess.
SQL

SELECT DISTINCT page_title
FROM itwiki_p.page
LEFT JOIN itwiki_p.imagelinks ON il_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
AND NOT (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', 'Amphora_olive-gathering_BM_B226_02.png',
                 'George_Frideric_Handel_by_Balthasar_Denner.jpg', 'Movie_stub_film.png', 'Tempietto_tipo_2.png',
                 'Crystal_Clear_app_kguitar.png', 'Sahaba.png', 'Open_book_01.png', '2006HondaCBR600RR-profile.png',
                 'IlmorX3-003.png', 'Soccer_the_United_Kingdom.png', 'Pot-artenac_alt.png', 'Owl_of_Minerva.png',
                 'Tutanchamun_Maske_Transparent.png', 'Nike_of_Samothrake_Louvre_Ma2369_n4.png', 'Psi2.png',
                 'Nesterov_Florensky_Bulgakov.jpg', 'David_face.png', 'Filippo_Maria_Visconti.jpg', 'Metal_icon.png',
                 'Rank-stub.PNG', 'DC_balloon.png', 'Snowflake11_2.png', 'Yes_(band)_logo.png', 'Crystal_Clear_filesystem_file_broken.png',
                 'Nuvola_apps_package_graphics.png', 'Azzurro_Giallo_Bianco_(diagonale).png', 'Nuvola_apps_kmessedwords.png',
                 'Chequered_flag.png', 'Jordan_F1_icon.png', 'Marvel_balloon.png', 'Feather_150_transparent.png', 'San_Francesco_245px.jpg',
                 'Oscar_mini_icon.png', 'CoA_Città_di_Venezia.png', 'Fairytale_konqueror.png', 'Spanish_conquest_of_Americas_map.png',
                 'Sassanid_empire_map.png', 'Monetaaretusa.png', 'Casque_offert_par_Hieron_le_tyran_de_Syracuse_08828.jpg',
                 'Rastafari_flag_squared.png', 'Hammurabi_code_cropped.png', 'Raffaello_Sanzio.jpg', 'Kuser.png',
                 'Heinkel_He_111_during_the_Battle_of_Britain_2.jpg', 'Gaetano_Donizetti_(portrait_by_Giuseppe_Rillosi).jpg',
                 'Rossini-portrait-0.jpg', 'Soccer_managers_stub.png', 'Stub_rugby.png', 'Judaism_Symbol.png', 'Icona-Bibbia2.png',
                 'Agatha_Christie.png', 'Unico_Anello.png', 'Araldiz_frette.jpg', 'Statue-Augustus_white_background.jpg',
                 'Siege-alesia-vercingetorix-jules-cesar.jpg', 'Celtic_torc.JPG', 'DenmarkStub2.png', 'Dachs.jpg', 'ALTIN.png',
                 'Cagliari_kathedrale_fassade01.jpg', 'Order_BritEmp_(civil)_rib.PNG', 'Exquisite-noatun.png', 'DNA.png',
                 'Julian_Venetia_and_Dalmatia.png', 'Thomas-Mann-um-1939.jpg', 'Flag_of_Scotland_Pantone300.png',
                 'AUGUSTUS_RIC_I_178a-116195.jpg', 'Bust_of_the_Augustus_Bevilacqua_-_trasparent_background.png')))
AND page_id IN
(SELECT ll_from
FROM itwiki_p.langlinks
WHERE ll_title IN (SELECT DISTINCT page_title
FROM enwiki_p.page
LEFT JOIN enwiki_p.imagelinks ON il_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
AND il_to NOT LIKE '%.svg'))
AND page_id NOT IN
   (SELECT cl_from
    FROM itwiki_p.categorylinks, itwiki_p.pagelinks
    WHERE cl_to = pl_title
    AND pl_namespace = 14
    AND pl_from = 4195411)
    LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
