wplv ruwiki pages

SQL

USE lvwiki_p;
select rd_namespace, rd_title, rd_from
from redirect
join page p1 on rd_from=p1.page_id
left join page p2 on rd_namespace=p2.page_namespace and rd_title=p2.page_title
where rd_namespace >= 0 and rd_interwiki IS NULL and p2.page_namespace IS NULL
/*
SELECT CONCAT('* [[:Attēls:',e.img_name,']]') as "LV WIKI", CONCAT('— [[:c:File:',e.img_name,']]') as "Commons" FROM image e
INNER JOIN commonswiki_p.image c ON c.img_name = e.img_name AND c.img_sha1 != e.img_sha1
JOIN page pp on pp.page_title=e.img_name
JOIN imagelinks fv on pp.page_id=fv.il_to
WHERE cl.cl_from IS NULL
*/
SQL

Checking query status...
