Nothing - Quarry

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
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 = lvwiki_p.image.img_name
AND lvwiki_p.categorylinks.cl_from = lvwiki_p.page.page_id
AND lvwiki_p.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1'
limit 10;

SQL

use lvwiki_p;
Select p.page_namespace, p.page_title
from page p
where p.page_is_redirect=0 and p.page_title regexp '[āēīū]\\)'
order by p.page_namespace, p.page_title;

use lvwiki_p;
Select p.page_namespace, p.page_title
from pagelinks pl
join page p on p.page_is_redirect=0 and pl.pl_title=p.page_title
where pl.pl_title regexp '[āēīū]\\)'
order by p.page_namespace, p.page_title;

SQL

Checking query status...