Untitled query #2807

SQL

use hewiki_p;
select * from revision 
where (rev_comment like "% #%"
or rev_comment like "#%")
and not replace(rev_comment, "_", " ") like "%# %"
and not rev_comment like "%#"
and not rev_comment like "%#הפניה%"
and not rev_comment like "%#REDIRECT%"
and not rev_comment like "%#redirect%"
and not rev_comment like "%#0%"
and not rev_comment like "%#1%"
and not rev_comment like "%#2%"
and not rev_comment like "%#3%"
and not rev_comment like "%#4%"
and not rev_comment like "%#5%"
and not rev_comment like "%#6%"
and not rev_comment like "%#7%"
and not rev_comment like "%#8%"
and not rev_comment like "%#9%"
and not rev_comment like "%/*%#%*/%"
limit 10
SQL

Checking query status...
