Untitled query #70623

SQL

SELECT categorypage.page_title, pl_title, pp_value
FROM page categorypage
JOIN categorylinks ON cl_from = categorypage.page_id
JOIN pagelinks ON pl_from = categorypage.page_id
JOIN page targetpage ON targetpage.page_title = pl_title
JOIN page_props ON pp_page = targetpage.page_id
WHERE cl_to = "Taxa_per_autore_di_classificazione"
AND categorypage.page_title LIKE 'Taxa\_classificati\_da\_%'
AND categorypage.page_namespace = 14
AND pl_from_namespace = 14
AND pl_namespace = 0
AND targetpage.page_namespace = 0
AND pp_propname = "wikibase_item"
SQL

Checking query status...
