Untitled query #12448

SQL

use wikidatawiki_p;
SELECT page_title, ips_site_id, ips_site_page FROM page
JOIN page_props ON page_id=pp_page AND pp_propname='wb-claims' AND pp_value=0
JOIN wb_entity_per_page ON page_id=epp_page_id AND epp_entity_type='item'
JOIN wb_items_per_site ON epp_entity_id=ips_item_id
WHERE page_namespace=0 AND page_is_redirect=0
AND (ips_site_id LIKE '__wiki' OR ips_site_id LIKE '___wiki')
AND ips_site_page LIKE '%:%'
AND NOT ips_site_page LIKE 'Anexo:%'
AND NOT ips_site_page LIKE 'ISO%'
ORDER BY ips_site_id, ips_site_page ASC;
SQL

Checking query status...
