Advertisement
Fale

Query SS not Template

Mar 10th, 2013
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.13 KB | None | 0 0
  1. SELECT DISTINCT CONCAT('* [[', page_title, ']]')
  2.   FROM page JOIN imagelinks ON page_id = il_from
  3.   WHERE page_namespace = 0
  4.     AND il_to
  5.       IN (SELECT page_title
  6.         FROM page JOIN categorylinks ON page_id = cl_from
  7.         WHERE cl_to LIKE "Screenshot_copy%"
  8.           AND page_namespace =6)
  9.     AND NOT EXISTS( SELECT *
  10.       FROM templatelinks
  11.       WHERE tl_from = page_id AND tl_namespace = 10
  12.         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') )
  13.     AND (page_namespace, page_title)
  14.       NOT IN (SELECT pl_namespace, pl_title
  15.         FROM pagelinks JOIN page ON pl_from = page_id
  16.         WHERE page_namespace=4
  17.           AND page_title = 'Elenchi_generati_offline/Screenshot/Whitelist')
  18.   ORDER BY page_title;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement