利用者:Suisui/SQLクエリ
表示
半角中グロを含むページ
[編集]- SELECT cur_title FROM cur WHERE cur_is_redirect=0 and cur_namespace=0 and cur_text like "%・%" limit 0,200
半角「」を含むページ
[編集]- SELECT cur_title FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 AND ( cur_text like "%「%" OR cur_text like "%」%") limit 0,200
強調を含まないページ 曖昧、一覧、削除依頼無視
[編集]SELECT concat('* [[',cur_title,']]') FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_title NOT LIKE "%一覧%" AND cur_text NOT LIKE "%'''%" AND cur_text NOT LIKE "%<b>%" AND cur_text NOT LIKE "%sakujo%" AND cur_text NOT LIKE "%Copyrights%" AND cur_text NOT LIKE "%曖昧%" AND cur_text NOT LIKE "%aimai%" AND cur_text NOT LIKE "%delete%" ORDER BY cur_title
BRタグを含むページ
[編集]SELECT concat('* [[',cur_title,']]') FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 AND ( cur_text LIKE "%<BR%" OR cur_text LIKE "%<br%" ) AND cur_text NOT LIKE "%<table%<BR%</table%" AND cur_text NOT LIKE "%<TABLE%<BR%</TABLE%" AND cur_text NOT LIKE "%<table%<br%</table%" AND cur_text NOT LIKE "%<TABLE%<br%</TABLE%" AND cur_text NOT LIKE "%{|%<BR%|}%" AND cur_text NOT LIKE "%{|%<br%|}%" AND cur_text NOT LIKE "%{{%<BR%}}%" AND cur_text NOT LIKE "%{{%<br%}}%" ORDER BY cur_title
短いページ
[編集]SELECT CONCAT('* [[',cur_title,']] (',LENGTH(cur_text),' byte)') FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text NOT LIKE "%aimai%" AND cur_text NOT LIKE "%sakujo%" AND cur_text NOT LIKE "%copyrights%" AND cur_text NOT LIKE "%delete%" AND LENGTH(cur_text) < 256 ORDER BY LENGTH(cur_text)