vkpai images2 - Quarry

SQL

use commonswiki_p;
SELECT concat("-7879frkui7-'",el_index,"':'", page_title,"',")#el_index, count(el_from)#
FROM externallinks
join page on page_id=el_from and page_namespace=14
where el_to like "http://saraksts.mantojums.lv/lv/piemineklu-saraksts%"
and not exists (select *
					from globalimagelinks
					where gil_wiki="lvwiki" and gil_page_namespace_id=0
                			and gil_page_title like "Valsts_aizsargājamie_kultūras_pieminekļi_%"
                			and gil_to=page_title and page_namespace=6
               )
group by el_index
having count(el_from)=1;
SQL

Checking query status...
