month categories without an english label

This query is marked as a draft This query has been published by Nikki.
SQL

USE wikidatawiki_p;
SELECT
	CONCAT("Q",ips_item_id) AS qid,
	'Len',
    CONCAT('"', REPLACE(REPLACE(ips_site_page, "Catégorie", "Category"), "Septembre", "September"), '"') AS label
FROM wb_items_per_site
LEFT JOIN wb_terms
ON wb_terms.term_entity_id=wb_items_per_site.ips_item_id
AND term_language = 'en'
AND term_type = 'label'
AND term_entity_type = 'item'

WHERE -- ips_site_id = 'kowiki'
(
	ips_site_page REGEXP '^Category:(January|February|March|April|May|June|July|August|September|October|November|December) [0-9]{4}$' -- commonswiki, enwikinews
	OR ips_site_page REGEXP '^Catégorie:(Janvier|Février|Mars|Avril|Mai|Juin|Juillet|Août|Septembre|Octobre|Novembre|Décembre) [0-9]{4}$' -- frwiki, frwikinews
	OR ips_site_page REGEXP '^Kategorie:(Januar|Februar|März|April|Mai|Juni|Juli|August|September|Oktober|November|Dezember) [0-9]{4}$' -- dewikinews
	OR ips_site_page REGEXP '^(Category|カテゴリ):[0-9]{4}年[0-9]{1,2}月$' -- jawiki, zhwiki, zh_yuewiki, zhwikinews, jawikinews
	OR ips_site_page REGEXP '^분류:[0-9]{4}년 [0-9]{1,2}월$' -- kowiki, kowikinews
	OR ips_site_page REGEXP '^Категория:(Январь|Февраль|Май|Июнь|Июль|Август|Сентябрь|Октябрь|Ноябрь|Декабрь) [0-9]{4}( года)?$' -- ruwiki, ruwikinews

  	OR ips_site_page REGEXP '^Category:[0-9]{1,2} (January|February|March|April|May|June|July|August|September|October|November|December) [0-9]{4}$' -- commonswiki, enwikinews
  	OR ips_site_page REGEXP '^Category:(January|February|March|April|May|June|July|August|September|October|November|December) [0-9]{1,2}, [0-9]{4}$' -- commonswiki, enwikinews

  	OR ips_site_page REGEXP '^(Category|カテゴリ):[0-9]{4}年[0-9]{1,2}月[0-9]{1,2}日$'
  	OR ips_site_page REGEXP '^(Category|カテゴリ):[0-9]{4}年$'
  	OR ips_site_page REGEXP '^Category:[0-9]{4}-[0-9]{2}-[0-9]{2}$'
  	OR ips_site_page REGEXP '^Catégorie:[0-9]{1,2} (janvier|février|mars|avril|mai|juin|juillet|août|septembre|octobre|novembre|décembre) [0-9]{4}$'

	OR ips_site_page REGEXP '^Kategorija:[0-9]{1,2}\. (januar|februar|mart|april|maj|juni|juli|august|septembar|octobar|novembar|decembar) [0-9]{4}$'
	OR ips_site_page REGEXP '^Categoria:[0-9]{1,2} de (gener|febrer|març|abril|maig|juny|juliol|agost|setembre|octubre|novembre|desembre) del [0-9]{4}$'
	OR ips_site_page REGEXP '^Categoría:[0-9]{1,2} de (enero|febrero|marzo|abril|mayo|junio|julio|agosto|septiembre|octubre|noviembre|diciembre) de [0-9]{4}$'
	OR ips_site_page REGEXP '^Categoria:[0-9]{1,2} de (janeiro|fevereiro|março|abril|maio|junho|julho|agosto|setembro|outubro|novembro|dezembro) de [0-9]{4}$'
	OR ips_site_page REGEXP '^Categoria:[0-9]{1,2} (gennaio|febbraio|marzo|aprile|maggio|giugno|luglio|agosto|settembre|ottobre|novembre|dicembre) [0-9]{4}$'
-- 	OR ips_site_page REGEXP '^[^:]+:[0-9]{1,2} .* [0-9]{4}$'

--  el Κατηγορία:4 Δεκεμβρίου 2015
--  ta பகுப்பு:டிசம்பர் 4, 2015
-- https://www.wikidata.org/wiki/Q9417400
)
AND term_text IS NULL

ORDER BY label, ips_item_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
