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
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)