USE wikidatawiki_p;

SELECT CONCAT("Q",descriptions.term_entity_id) AS item, english.term_text AS english_label,

    labels.term_text AS label, descriptions.term_language AS lang, descriptions.term_text AS description

    FROM (SELECT * FROM wb_terms WHERE term_type = "description" AND term_entity_type = "item") AS descriptions

    LEFT JOIN (SELECT * FROM wb_terms WHERE term_type = "label") AS labels

        ON labels.term_entity_id = descriptions.term_entity_id

        AND labels.term_language = descriptions.term_language

        AND labels.term_entity_type = descriptions.term_entity_type

    LEFT JOIN (SELECT * FROM wb_terms WHERE term_language = "en" AND term_type = "label") AS english

        ON english.term_entity_id = descriptions.term_entity_id

        AND (labels.term_language IS NULL OR english.term_language <> descriptions.term_language)

        AND english.term_entity_type = descriptions.term_entity_type

WHERE descriptions.term_text RLIKE "[Qq][1-9][0-9]{3}" OR descriptions.term_text LIKE "%P[1-9][0-9]%"

ORDER BY descriptions.term_entity_id, descriptions.term_language;