with data as (
select groupId, FORMAT_TIMESTAMP("%Y-%m-%dT%X%Ez", date, "UTC") eventTime, STRUCT('topic' as name, 'monkeypox' as stringVal) as dimensions from (
SELECT FARM_FINGERPRINT( CONCAT(ngram, post, url) ) groupId, min(date) date FROM `gdelt-bq.gdeltv2.webngrams` WHERE ( DATE(date) >= "2022-04-01" AND DATE(date) <= "2022-05-31") and (

(lang='am' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^የዝንጀሮ በሽታ\b')) OR
(lang='hi' AND REGEXP_CONTAINS(LOWER(ngram), r'^मंकीपॉक्स\b')) OR
(lang='hi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^मंकी पॉक्स\b')) OR
(lang='ku' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='ku' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^meymûn pox\b')) OR
(lang='ps' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^د بندر پوکس\b')) OR
(lang='ps' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='qu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^viruela de mono\b')) OR
(lang='qu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mono viruela\b')) OR
(lang='ti' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ፍንጣጣ ኣህባይ\b')) OR
(lang='xh' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^irhashalala yenkawu\b')) OR
(lang='xh' AND REGEXP_CONTAINS(LOWER(ngram), r'^inkawu\b')) OR
(lang='sm' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^gata manuki\b')) OR
(lang='sm' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^manuki pox\b')) OR
(lang='nl' AND REGEXP_CONTAINS(LOWER(ngram), r'^apenpokken\b')) OR
(lang='cy' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^brech mwnci\b')) OR
(lang='cy' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^brech y mwnci\b')) OR
(lang='bs' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^majmunske boginje\b')) OR
(lang='km' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^ជំងឺគ្រុនពោះវៀន')) OR
(lang='km' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^ជំងឺអុតស្វាយ')) OR
(lang='hy' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^կապիկի ծաղիկ\b')) OR
(lang='hy' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^կապիկ ծաղիկ\b')) OR
(lang='sd' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^monkey pox\b')) OR
(lang='sd' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='ht' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^makak pox\b')) OR
(lang='ht' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='sw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^tumbili tetekuwanga\b')) OR
(lang='sw' AND REGEXP_CONTAINS(LOWER(ngram), r'^tumbili\b')) OR
(lang='sa' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^वानर चेचकम्\b')) OR
(lang='sa' AND REGEXP_CONTAINS(LOWER(ngram), r'^वानरचेचकः\b')) OR
(lang='gl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^varíola de mono\b')) OR
(lang='gl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^varíola do mono\b')) OR
(lang='eu' AND REGEXP_CONTAINS(LOWER(ngram), r'^tximino-pox\b')) OR
(lang='eu' AND REGEXP_CONTAINS(LOWER(ngram), r'^tximinoa\b')) OR
(lang='pa' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='pa' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ਬਾਂਦਰ ਪੋਕਸ\b')) OR
(lang='hmn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^liab kab mob\b')) OR
(lang='hmn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^liab pox\b')) OR
(lang='ml' AND REGEXP_CONTAINS(LOWER(ngram), r'^കുരങ്ങുപനി\b')) OR
(lang='ee' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^bosowo ƒe dɔléle\b')) OR
(lang='ee' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^boso ƒe ʋuʋudedi\b')) OR
(lang='eo' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^simia variolo\b')) OR
(lang='yi' AND REGEXP_CONTAINS(LOWER(ngram), r'^מאַלפּעפּאָקס\b')) OR
(lang='yi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^מאַלפּע פּאָקס\b')) OR
(lang='is' AND REGEXP_CONTAINS(LOWER(ngram), r'^apabólu\b')) OR
(lang='lo' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^ພະຍາດລີງ')) OR
(lang='si' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^වඳුරු උවදුර\b')) OR
(lang='bho' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^बंदर के चेचक के बेमारी होला\b')) OR
(lang='bho' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^बंदर के चेचक के बारे में बतावल गइल बा\b')) OR
(lang='mai' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^मंकी पॉक्स\b')) OR
(lang='mai' AND REGEXP_CONTAINS(LOWER(ngram), r'^मंकीपॉक्स\b')) OR
(lang='sq' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^lisë majmuni\b')) OR
(lang='sq' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^lija e majmunit\b')) OR
(lang='pl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ospa małp\b')) OR
(lang='pl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^małpia ospa\b')) OR
(lang='gn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^viruela mono rehegua\b')) OR
(lang='ky' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^маймыл чечеги\b')) OR
(lang='pt' AND REGEXP_CONTAINS(LOWER(ngram), r'^varicela\b')) OR
(lang='pt' AND REGEXP_CONTAINS(LOWER(ngram), r'^catapora\b')) OR
(lang='la' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^simia pox\b')) OR
(lang='la' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='th' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^โรคฝีลิง')) OR
(lang='th' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^ไข้ทรพิษลิง')) OR
(lang='rw' AND REGEXP_CONTAINS(LOWER(ngram), r'^inguge\b')) OR
(lang='rw' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='ckb' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='ckb' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^meymûn pox\b')) OR
(lang='tr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^maymun çiçeği\b')) OR
(lang='ny' AND REGEXP_CONTAINS(LOWER(ngram), r'^nyanipox\b')) OR
(lang='ny' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^nyani pox\b')) OR
(lang='be' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^воспа малпаў\b')) OR
(lang='te' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^కోతి వ్యాధి\b')) OR
(lang='tk' AND REGEXP_CONTAINS(LOWER(ngram), r'^maýmyn\b')) OR
(lang='ga' AND REGEXP_CONTAINS(LOWER(ngram), r'^deilgneach\b')) OR
(lang='ga' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^deilgneach moncaí\b')) OR
(lang='lv' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^pērtiķu bakas\b')) OR
(lang='lv' AND REGEXP_CONTAINS(LOWER(ngram), r'^mērkaķbakas\b')) OR
(lang='bn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^বানর পক্স\b')) OR
(lang='bn' AND REGEXP_CONTAINS(LOWER(ngram), r'^বানরপক্স\b')) OR
(lang='lg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^obulwadde bw’enkima\b')) OR
(lang='lg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ekizimba ky’enkima\b')) OR
(lang='zh-CN' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^猴痘')) OR
(lang='kk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^маймыл шешек\b')) OR
(lang='en' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^monkey pox\b')) OR
(lang='en' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='ru' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^обезьянья оспа\b')) OR
(lang='ru' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^оспа обезьян\b')) OR
(lang='ar' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^جدرى القرود\b')) OR
(lang='ar' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^جدري القرد\b')) OR
(lang='ceb' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^unggoy pox\b')) OR
(lang='ceb' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^buto sa unggoy\b')) OR
(lang='ur' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='ur' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^بندر پاکس\b')) OR
(lang='jw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^cacar monyet\b')) OR
(lang='jw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^cacar kethek\b')) OR
(lang='mi' AND REGEXP_CONTAINS(LOWER(ngram), r'^makimaki\b')) OR
(lang='mi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^makimaki pox\b')) OR
(lang='af' AND REGEXP_CONTAINS(LOWER(ngram), r'^apepokke\b')) OR
(lang='af' AND REGEXP_CONTAINS(LOWER(ngram), r'^aappokkies\b')) OR
(lang='ig' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^enwe pox\b')) OR
(lang='ig' AND REGEXP_CONTAINS(LOWER(ngram), r'^enwe\b')) OR
(lang='sv' AND REGEXP_CONTAINS(LOWER(ngram), r'^apkoppor\b')) OR
(lang='et' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ahvi rõuged\b')) OR
(lang='et' AND REGEXP_CONTAINS(LOWER(ngram), r'^ahvirõuged\b')) OR
(lang='ha' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^cutar sankarau\b')) OR
(lang='ha' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^kashin biri\b')) OR
(lang='ja' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^サル痘')) OR
(lang='ay' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ukatsti uka ch’uqi usu\b')) OR
(lang='ay' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ukatsti uka ch’uqi ch’uqi\b')) OR
(lang='dv' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^މަކުނު ޕޮކްސް އެވެ\b')) OR
(lang='ug' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='ug' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^مايمۇن پوك\b')) OR
(lang='hr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^majmunske boginje\b')) OR
(lang='zh' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^猴痘')) OR
(lang='ak' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^bonsu akisikuru\b')) OR
(lang='ne' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^बाँदर पोक्स\b')) OR
(lang='ta' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^குரங்கு நோய்\b')) OR
(lang='tl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^monkey pox\b')) OR
(lang='tl' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='lb' AND REGEXP_CONTAINS(LOWER(ngram), r'^afenpocken\b')) OR
(lang='lb' AND REGEXP_CONTAINS(LOWER(ngram), r'^apepox\b')) OR
(lang='ka' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^მაიმუნის ყვავილი\b')) OR
(lang='ko' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^원숭이 수두\b')) OR
(lang='ko' AND REGEXP_CONTAINS(LOWER(ngram), r'^원숭이두\b')) OR
(lang='fr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^variole du singe\b')) OR
(lang='bg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^маймунска шарка\b')) OR
(lang='sl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^opičje koze\b')) OR
(lang='sl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^opičja koza\b')) OR
(lang='it' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^vaiolo delle scimmie\b')) OR
(lang='iw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^אבעבועות קוף\b')) OR
(lang='iw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^אבעבועות קופים\b')) OR
(lang='tt' AND REGEXP_CONTAINS(LOWER(ngram), r'^маймыл\b')) OR
(lang='no' AND REGEXP_CONTAINS(LOWER(ngram), r'^apekopper\b')) OR
(lang='fa' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^آبله میمون\b')) OR
(lang='mr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^माकड पॉक्स\b')) OR
(lang='mr' AND REGEXP_CONTAINS(LOWER(ngram), r'^माकडपॉक्स\b')) OR
(lang='as' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^বান্দৰ পক্স\b')) OR
(lang='sk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^opičie kiahne\b')) OR
(lang='yo' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^obo pox\b')) OR
(lang='yo' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^obo obo\b')) OR
(lang='mn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^сармагчингийн цэцэг\b')) OR
(lang='sn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^monkey pox\b')) OR
(lang='sn' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='om' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^dhukkuba saree\b')) OR
(lang='om' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^busaa saree\b')) OR
(lang='mg' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='mg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^pox gidro\b')) OR
(lang='fi' AND REGEXP_CONTAINS(LOWER(ngram), r'^apinarokko\b')) OR
(lang='he' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^אבעבועות קוף\b')) OR
(lang='he' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^אבעבועות קופים\b')) OR
(lang='tg' AND REGEXP_CONTAINS(LOWER(ngram), r'^маймун\b')) OR
(lang='tg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^бемории маймун\b')) OR
(lang='da' AND REGEXP_CONTAINS(LOWER(ngram), r'^abekopper\b')) OR
(lang='uk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^віспа мавп\b')) OR
(lang='gu' AND REGEXP_CONTAINS(LOWER(ngram), r'^વાનરપોક્સ\b')) OR
(lang='gu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^વાનર પોક્સ\b')) OR
(lang='st' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^tshwene pox\b')) OR
(lang='st' AND REGEXP_CONTAINS(LOWER(ngram), r'^tshwene\b')) OR
(lang='my' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^မျောက် သီတာ။')) OR
(lang='my' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^မျောက်ကျောက်')) OR
(lang='de' AND REGEXP_CONTAINS(LOWER(ngram), r'^affenpocken\b')) OR
(lang='lt' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^beždžionių raupai\b')) OR
(lang='zu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^i-monkey pox\b')) OR
(lang='zu' AND REGEXP_CONTAINS(LOWER(ngram), r'^inkawu\b')) OR
(lang='haw' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='haw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^monkey pox\b')) OR
(lang='sr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^мајмунске богиње\b')) OR
(lang='es' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^viruela del mono\b')) OR
(lang='es' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^viruela del simio\b')) OR
(lang='so' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^bus-bus daayeer\b')) OR
(lang='so' AND REGEXP_CONTAINS(LOWER(ngram), r'^busbuska\b')) OR
(lang='cs' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^opičí neštovice\b')) OR
(lang='vi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^bệnh đậu mùa khỉ\b')) OR
(lang='vi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^đậu khỉ\b')) OR
(lang='ro' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^variola de maimuta\b')) OR
(lang='ro' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^variola maimuțelor\b')) OR
(lang='ln' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^maladi ya nyoka\b')) OR
(lang='ln' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^varicelle ya nyama ya zamba\b')) OR
(lang='uz' AND REGEXP_CONTAINS(LOWER(ngram), r'^maymunchechak\b')) OR
(lang='uz' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^maymun poxi\b')) OR
(lang='kri' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mɔnki pɔks\b')) OR
(lang='kri' AND REGEXP_CONTAINS(LOWER(ngram), r'^mɔnkipɔks\b')) OR
(lang='nso' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^seboko sa ditšhwene\b')) OR
(lang='mk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^мајмунски сипаници\b')) OR
(lang='mk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^мајмунска сипаница\b')) OR
(lang='ts' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^xitsongwatsongwana xa tinyenyana\b')) OR
(lang='id' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^cacar monyet\b')) OR
(lang='zh-TW' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^猴痘')) OR
(lang='az' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^meymun pox\b')) OR
(lang='az' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^meymun çiçəyi\b')) OR
(lang='el' AND REGEXP_CONTAINS(LOWER(ngram), r'^μαϊμουβλογιά\b')) OR
(lang='el' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^μαϊμού ευλογιά\b')) OR
(lang='kn' AND REGEXP_CONTAINS(LOWER(ngram), r'^ಮಂಕಿಪಾಕ್ಸ್\b')) OR
(lang='kn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ಮಂಕಿ ಪಾಕ್ಸ್\b')) OR
(lang='or' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ମାଙ୍କଡ଼ ପକ୍ସ\b')) OR
(lang='or' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ମାଙ୍କଡପକ୍ସ |\b')) OR
(lang='hu' AND REGEXP_CONTAINS(LOWER(ngram), r'^majomhimlő\b')) OR
(lang='mt' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ġidri tax-xadini\b')) OR
(lang='ms' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^cacar monyet\b')) OR
(lang='ca' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^verola del mico\b')) OR
(lang='su' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^cacar monyét\b')) OR
(lang='gd' AND REGEXP_CONTAINS(LOWER(ngram), r'^breac-mhonaidh\b')) OR
(lang='gd' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^breac muncaidh\b')) OR
(lang='fy' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) OR
(lang='fy' AND REGEXP_CONTAINS(LOWER(ngram), r'^aappokken\b')) OR
(lang='co' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^vaiola di scimmia\b')) OR
(lang='co' AND REGEXP_CONTAINS(LOWER(ngram), r'^monkeypox\b')) 

) group by groupId )
) select eventTime, groupId, ARRAY_AGG(dimensions) AS dimensions FROM data GROUP BY eventTime, groupId