Untitled query #17445

SQL

use lvwiki_p;
SELECT
  DISTINCT(lvwiki_p.page.page_title),
  commonswiki_p.image.img_name, imglinks1.page_namespace, imglinks1.page_title, il_to
FROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.page
join (SELECT ppp1.page_namespace, ppp1.page_title, il_to
	FROM lvwiki_p.imagelinks
	join page ppp1 on il_from=ppp1.page_title) as imglinks1 on imglinks1.il_to=lvwiki_p.page.page_title
WHERE lvwiki_p.image.img_sha1 = commonswiki_p.image.img_sha1 and lvwiki_p.page.page_title != commonswiki_p.image.img_name
AND lvwiki_p.page.page_title = lvwiki_p.image.img_name
AND lvwiki_p.categorylinks.cl_from = lvwiki_p.page.page_id
AND lvwiki_p.categorylinks.cl_to IN ("Aizsargāti_attēli", "Aizsargāti_logo", "Aizsargātas_pastmarkas",
"Aizsargāti_filmu_plakāti", "Aizsargāti_grāmatu_vāki",
"Aizsargāti_skaņas_faili", "Albuma_vāka_attēli", "Pastmarkas")
AND lvwiki_p.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1';
SQL

Checking query status...
