Untitled query #526

SQL

use etwiki_p;
SELECT 
  DISTINCT(p.page_title) as "Nosaukums lvwiki",
  ci.img_name as "Nosaukums Commons",
  il.il_from
FROM image i, commonswiki_p.image ci, categorylinks cl, page p
#left laikam ir lēnāks...
join imagelinks il on il.il_to=p.page_title
#join page p2 on il.il_from=p2.page_title
WHERE i.img_sha1 = ci.img_sha1 and p.page_title != ci.img_name
AND p.page_title = i.img_name
#and p2.page_namespace=10
AND cl.cl_from = p.page_id
AND i.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1'
and il.il_from in (select page_id from page where page_namespace=10)
order by il.il_from
limit 100;
SQL

Checking query status...
