Usuari:Joanjoc/SQL
De Viquipèdia
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

