lvwiki esošie attēli, kas Commons ir ar citu nosaukumu

SQL

SELECT
#CONCAT('#[[:Attēls:',DISTINCT(lvwiki_p.page.page_title),']]') as "Nosaukums lvwiki",
  DISTINCT(lvwiki_p.page.page_title) as "Nosaukums lvwiki",
  commonswiki_p.image.img_name as "Nosaukums Commons",
  lvwiki_p.imagelinks.il_from
FROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.page
left join lvwiki_p.imagelinks on lvwiki_p.imagelinks.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 like "%COA%"
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.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1'
order by lvwiki_p.imagelinks.il_from
limit 500;
/* veca versija
SELECT
#CONCAT('#[[:Attēls:',DISTINCT(lvwiki_p.page.page_title),']]') as "Nosaukums lvwiki",
  DISTINCT(lvwiki_p.page.page_title) as "Nosaukums lvwiki",
  commonswiki_p.image.img_name as "Nosaukums Commons"
FROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.page
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.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1';
*/
SQL

Checking query status...
