USE cswiki_p;

SELECT eu_entity_id, COUNT(*)

    FROM (SELECT * FROM wbc_entity_usage WHERE eu_aspect = "L.cs") AS eusage

    JOIN wikidatawiki_p.page AS items

        ON items.page_namespace = 0 AND items.page_title = eu_entity_id

    JOIN wikidatawiki_p.wb_entity_per_page

        ON epp_entity_type = "item" AND epp_page_id = items.page_id

    LEFT JOIN (SELECT * FROM wikidatawiki_p.wb_terms WHERE term_type = "label" AND term_language = "cs" AND term_entity_type = "item") AS labels

        ON term_entity_id = epp_entity_id

WHERE term_text IS NULL

GROUP BY eu_entity_id HAVING COUNT(*) > 2

ORDER BY COUNT(*) DESC;