Items with the most sitelinks with no ukwiki link, no templates and categories

Fork of Items with the most sitelinks with no ukwiki link by Base

This query is marked as a draft This query has been published by Base.

SQL

select ips_item_id, ips_site_page,
count(*) as links,
(select count(*) from wb_items_per_site ips_bis where ips_bis.ips_site_id = "ukwiki" and ips_bis.ips_item_id = ips.ips_item_id) as ukwiki,
(select count(*) from pagelinks pl where pl.pl_title in ("Q11266439", "Q4167836") and p.page_id = pl.pl_from) as templateorcategory
from wb_items_per_site ips
join page p on p.page_title = concat("Q", ips_item_id)
group by ips_item_id
having ukwiki < 1 and templateorcategory < 1
order by links desc 
limit 10000

SQL

Checking query status...