Items without Czech label by usage (sk)

Fork of Items without Czech label by usage (en) by Matěj Suchánek

This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

SELECT eu_entity_id, COUNT(eu_page_id) AS number
FROM wbc_entity_usage AS main
WHERE eu_aspect = 'L.sk'
AND eu_entity_id LIKE 'Q%'
AND EXISTS (
  SELECT 1 FROM wbc_entity_usage AS subq
  WHERE subq.eu_entity_id = main.eu_entity_id
  AND subq.eu_page_id = main.eu_page_id
  AND subq.eu_aspect = 'L.cs'
)
AND NOT EXISTS (
  SELECT 1 FROM wbc_entity_usage AS subq
  WHERE subq.eu_entity_id = main.eu_entity_id
  AND subq.eu_page_id = main.eu_page_id
  AND subq.eu_aspect = 'L.en'
)
GROUP BY eu_entity_id
ORDER BY number DESC, eu_entity_id;

SQL

Checking query status...