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

SQL

use lvwiki_p;
select p.page_title, pl_title, p2.page_title
from pagelinks
#join page p on pl_from=p.page_id
#join page p2 on LOWER(CONVERT(p2.page_title USING latin1))=LOWER(CONVERT(pl_title USING latin1))
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 1000;

/*
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...
