SQL
AخA
SELECT el_index, page_title
FROM externallinks
join page on page_id=el_from and page_namespace=6
where el_to like "https://is.mantojums.lv/%"
#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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.