Untitled query #56863

SQL

SELECT CONCAT('*[[', 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%'
/* AND NOT ips_site_page LIKE 'Portal:%'
AND NOT ips_site_page LIKE 'Template:%'
AND NOT ips_site_page LIKE 'Wikipedia:%'
ORDER BY page_id ASC; */
ORDER BY ips_site_id, ips_site_page ASC;
SQL

Checking query status...
