コンテンツにスキップ

英文维基 | 中文维基 | 日文维基 | 草榴社区

利用者: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)