SQL
AخA
USE wikidatawiki_p;
SELECT page_title, pi_type, COUNT( tl_title ) AS c, GROUP_CONCAT( tl_title )
FROM wb_property_info
JOIN page ON page_namespace = 121 AND page_title = CONCAT("P", pi_property_id)
JOIN templatelinks ON tl_from = page_id
WHERE tl_title LIKE "Constraint:%" AND tl_namespace = 10
GROUP BY page_title
ORDER BY c DESC, pi_property_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.