Broken redirects (shwiki)

SQL

USE srwiki_p;

SELECT COUNT(*) AS count
FROM page
JOIN pagelinks ON page_id = pl_from
JOIN wb_items_per_site ON page_title = ips_site_page
JOIN wikidatawiki_p.page AS wdpage ON ips_item_id = wdpage.page_id
JOIN wikidatawiki_p.claims AS gender_claim ON wdpage.page_id = gender_claim.claim_entity_id
JOIN wikidatawiki_p.page AS gender ON gender_claim.main_snak_entity_id = gender.page_id
WHERE page_namespace = 0
AND pl_namespace = 0
AND ips_site_id = 'srwiki'
AND pl_title = page_title
AND wdpage.page_namespace = 0
AND gender_claim.claim_id = 'P21'
AND gender.page_title = 'Q6581072';
SQL

Checking query status...
