Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT CONCAT('* [[', page_title, ']]')
- FROM page JOIN imagelinks ON page_id = il_from
- WHERE page_namespace = 0
- AND il_to
- IN (SELECT page_title
- FROM page JOIN categorylinks ON page_id = cl_from
- WHERE cl_to LIKE "Screenshot_copy%"
- AND page_namespace =6)
- AND NOT EXISTS( SELECT *
- FROM templatelinks
- WHERE tl_from = page_id AND tl_namespace = 10
- AND tl_title IN ('Film', 'StagioniTV', 'Fumetto_e_animazione', 'Episodio_SerieTV', 'Episodi_Simpson', 'Infobox_Software', 'ProgrammaTV', 'FictionTV', 'Personaggio', 'Infobox_personaggio_fittizio', 'Personaggio_di_soap', 'Digimon_Infobox', 'Personaggio_di_Harry_Potter', 'Stargate_razza', 'Stargate_personaggio', 'Personaggio_di_Arda', 'Droide_StarWars', 'Personaggio_StarWars', 'Personaggio_Tarantino', 'Album', 'Gamebox', 'Sistema_operativo', 'Software') )
- AND (page_namespace, page_title)
- NOT IN (SELECT pl_namespace, pl_title
- FROM pagelinks JOIN page ON pl_from = page_id
- WHERE page_namespace=4
- AND page_title = 'Elenchi_generati_offline/Screenshot/Whitelist')
- ORDER BY page_title;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement