Usuari:Joanjoc/SQL

Plantilles sense categories

SELECT cur_namespace, cur_title 
  FROM cur WHERE upper(cur_text) not like "%[[CATEGORIA:%" 
   and cur_namespace =10 
   and cur_is_redirect !=1
 ORDER BY cur_title, cur_namespace 
 LIMIT 500

Un dels selects de plantilles sense categories

SELECT cur_namespace, cur_title 
  FROM cur
 WHERE (cur_title like "Gener\_%"
     or cur_title like "Febrer\_%"
     or cur_title like "Març\_%"
     or cur_title like "Abril\_%"
     or cur_title like "Maig\_%"
     or cur_title like "Juny\_%"
     or cur_title like "Juliol\_%"
     or cur_title like "Agost\_%"
     or cur_title like "Setembre\_%"
     or cur_title like "Octubre\_%"
     or cur_title like "Novembre\_%"
     or cur_title like "Desembre\_%")
    and cur_title not like "%?"
    and upper(cur_text) not like "%[[CATEGORIA:%"
    and cur_namespace =10
    and cur_is_redirect !=1
ORDER BY cur_title, cur_namespace
LIMIT 1000