Redlinks, that have similar article, based on capilazition (lvwiki)

SQL

use lvwiki_p;
select *
from pagelinks
#join page on pl_from=page_id
where LOWER(CONVERT(pl_title USING latin1)) in (select LOWER(CONVERT(page_title USING latin1)) from page where page_namespace=0)
and pl_from_namespace = 0 AND pl_namespace = 0
AND NOT EXISTS (
  SELECT * FROM page WHERE page_namespace = 0 AND page_title = pl_title
)
GROUP BY pl_title
limit 10;

/*
use lvwiki_p;
SELECT * FROM page
where page_title like '%" + (SELECT pl_title
FROM pagelinks
WHERE pl_from_namespace = 0 AND pl_namespace = 0
AND NOT EXISTS (
  SELECT * FROM page WHERE page_namespace = 0 AND page_title = pl_title
)
GROUP BY pl_title) + "%'
limit 10;



use lvwiki_p;
SELECT pl_title
FROM pagelinks
WHERE pl_from_namespace = 0 AND pl_namespace = 0
AND NOT EXISTS (
  SELECT * FROM page WHERE page_namespace = 0 AND page_title = pl_title
)
and pl_title like '%" + (select page_title from page where page_namespace=0) + "%'
GROUP BY pl_title
limit 10;*/
SQL

Checking query status...
