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( url ) groupId, min(date) date FROM `gdelt-bq.gdeltv2.webngrams` WHERE ( DATE(date) >= "2022-04-01" AND DATE(date) <= "2022-05-31") and (

(lang='iw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^שמן חמניות\b')) OR
(lang='sv' AND REGEXP_CONTAINS(LOWER(ngram), r'^solrosolja\b')) OR
(lang='uk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^соняшникова олія\b')) OR
(lang='ka' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^მზესუმზირის ზეთი\b')) OR
(lang='vi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^dầu hướng dương\b')) OR
(lang='mn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^наран цэцгийн тос\b')) OR
(lang='is' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^sólblóma olía\b')) OR
(lang='ar' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^زيت عباد الشمس\b')) OR
(lang='su' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^minyak sunflower\b')) OR
(lang='lb' AND REGEXP_CONTAINS(LOWER(ngram), r'^sonneblummenueleg\b')) OR
(lang='gu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^સૂર્યમુખી તેલ\b')) OR
(lang='zu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^amafutha kabhekilanga\b')) OR
(lang='ur' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^سورج مکھی کا تیل\b')) OR
(lang='sn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mafuta ezuva\b')) OR
(lang='pa' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ਸੂਰਜਮੁਖੀ ਦਾ ਤੇਲ\b')) OR
(lang='tl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^langis ng mirasol\b')) OR
(lang='ne' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^सूर्यमुखी तेल\b')) OR
(lang='cs' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^slunečnicový olej\b')) OR
(lang='bs' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^suncokretovo ulje\b')) OR
(lang='gl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^aceite de xirasol\b')) OR
(lang='ru' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^подсолнечное масло\b')) OR
(lang='fy' AND REGEXP_CONTAINS(LOWER(ngram), r'^sinneblomoalje\b')) OR
(lang='hi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^सूरजमुखी का तेल\b')) OR
(lang='bn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^সূর্যমুখীর তেল\b')) OR
(lang='jw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^lenga kembang srengenge\b')) OR
(lang='sw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mafuta ya alizeti\b')) OR
(lang='lo' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^ນ້ ຳ ມັນດອກຕາເວັນ')) OR
(lang='ha' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^man sunflower\b')) OR
(lang='mr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^सूर्यफूल तेल\b')) OR
(lang='sd' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^سورج مکي جو تيل\b')) OR
(lang='hu' AND REGEXP_CONTAINS(LOWER(ngram), r'^napraforgóolaj\b')) OR
(lang='si' 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='ug' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ئاپتاپپەرەس مېيى\b')) OR
(lang='qu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^girasolmanta aceite\b')) OR
(lang='co' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^oliu di girasole\b')) OR
(lang='so' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^saliid gabbaldayaha\b')) OR
(lang='bho' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^सूरजमुखी के तेल के इस्तेमाल होला\b')) OR
(lang='as' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^সূৰ্য্যমুখী তেল\b')) OR
(lang='ln' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mafuta ya tournesol\b')) OR
(lang='cy' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^olew blodyn yr haul\b')) OR
(lang='fa' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^روغن آفتابگردان\b')) OR
(lang='hr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^suncokretovo ulje\b')) OR
(lang='gn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^girasol aséite\b')) OR
(lang='ms' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^minyak bunga matahari\b')) OR
(lang='or' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ସୂର୍ଯ୍ୟମୁଖୀ ତେଲ |\b')) OR
(lang='zh-CN' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^葵花籽油')) OR
(lang='rw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^amavuta yizuba\b')) OR
(lang='om' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^zayita aduu\b')) OR
(lang='be' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^сланечнікавы алей\b')) OR
(lang='mt' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^żejt tal-ġirasol\b')) OR
(lang='ko' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^해바라기 유\b')) OR
(lang='id' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^minyak bunga matahari\b')) OR
(lang='sq' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^vaj luledielli\b')) OR
(lang='fi' AND REGEXP_CONTAINS(LOWER(ngram), r'^auringonkukkaöljy\b')) OR
(lang='ku' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^rûnê gulberojê\b')) OR
(lang='az' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^günəbaxan yağı\b')) OR
(lang='ts' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mafurha ya swiluva swa dyambu\b')) OR
(lang='st' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^oli ea soneblomo\b')) OR
(lang='ny' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mafuta a mpendadzuwa\b')) OR
(lang='mai' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^सूरजमुखी का तेल\b')) OR
(lang='sk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^slnečnicový olej\b')) OR
(lang='km' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^ប្រេង​ផ្កាឈូករ័ត្ន')) OR
(lang='en' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^sunflower oil\b')) OR
(lang='ga' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ola lus na gréine\b')) OR
(lang='eu' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ekilore olioa\b')) OR
(lang='eo' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^sunflora oleo\b')) OR
(lang='kk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^күнбағыс майы\b')) OR
(lang='sl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^sončnično olje\b')) OR
(lang='zh' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^葵花籽油')) OR
(lang='he' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^שמן חמניות\b')) OR
(lang='nl' AND REGEXP_CONTAINS(LOWER(ngram), r'^zonnebloemolie\b')) OR
(lang='hmn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^sunflower roj\b')) OR
(lang='yi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^זונרויז ייל\b')) OR
(lang='lg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^amafuta ga sunflower\b')) OR
(lang='tg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^равғани офтобпараст\b')) OR
(lang='sr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^сунцокретово уље\b')) OR
(lang='tr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ayçiçek yağı\b')) OR
(lang='te' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^పొద్దుతిరుగుడు నూనె\b')) OR
(lang='lv' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^saulespuķu eļļa\b')) OR
(lang='ak' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^owia-nsoromma ngo\b')) OR
(lang='ht' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^lwil tounsòl\b')) OR
(lang='af' AND REGEXP_CONTAINS(LOWER(ngram), r'^sonneblomolie\b')) OR
(lang='ig' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^mmanụ sunflower\b')) OR
(lang='pl' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^olej słonecznikowy\b')) OR
(lang='ca' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^oli de gira-sol\b')) OR
(lang='la' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^helianthus oleum\b')) OR
(lang='ml' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^സൂര്യകാന്തി എണ്ണ\b')) OR
(lang='nso' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^oli ya sonoplomo\b')) OR
(lang='ckb' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^rûnê gulberojê\b')) OR
(lang='uz' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^kungaboqar yog'i\b')) OR
(lang='ja' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^ひまわり油')) OR
(lang='sa' AND REGEXP_CONTAINS(LOWER(ngram), r'^सूर्यपुष्पतैलम्\b')) OR
(lang='bg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^слънчогледово олио\b')) OR
(lang='es' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^aceite de girasol\b')) OR
(lang='gd' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ola lus na grèine\b')) OR
(lang='fr' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^huile de tournesol\b')) OR
(lang='hy' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^արեւածաղկի ձեթ\b')) OR
(lang='et' AND REGEXP_CONTAINS(LOWER(ngram), r'^päevalilleõli\b')) OR
(lang='mi' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^hinu putirā\b')) OR
(lang='kri' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^sanflawa ɔyl\b')) OR
(lang='xh' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ioli kajongilanga\b')) OR
(lang='pt' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^óleo de girassol\b')) OR
(lang='yo' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^epo sunflower\b')) OR
(lang='da' AND REGEXP_CONTAINS(LOWER(ngram), r'^solsikkeolie\b')) OR
(lang='mg' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^menaka tanamasoandro\b')) OR
(lang='ps' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^د لمر ګل غوړ\b')) OR
(lang='tt' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^көнбагыш мае\b')) OR
(lang='de' AND REGEXP_CONTAINS(LOWER(ngram), r'^sonnenblumenöl\b')) OR
(lang='ky' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^күн карама майы\b')) OR
(lang='haw' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ʻaila ʻaila\b')) OR
(lang='it' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^olio di semi di girasole\b')) OR
(lang='sm' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^suauu sunflower\b')) OR
(lang='ceb' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^lana sa sunflower\b')) OR
(lang='dv' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ސަންފްލާވާ ތެޔޮ އެވެ\b')) OR
(lang='ee' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ɣe ƒe keklẽŋusẽ ƒe ami\b')) OR
(lang='am' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^የሱፍ ዘይት\b')) OR
(lang='ro' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ulei de floarea soarelui\b')) OR
(lang='el' AND REGEXP_CONTAINS(LOWER(ngram), r'^ηλιέλαιο\b')) OR
(lang='kn' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ಸೂರ್ಯಕಾಂತಿ ಎಣ್ಣೆ\b')) OR
(lang='tk' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^günebakar ýagy\b')) OR
(lang='ti' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^ዘይቲ ዕምባባ ጸሓይ\b')) OR
(lang='zh-TW' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^葵花籽油')) OR
(lang='th' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^น้ำมันดอกทานตะวัน')) OR
(lang='ay' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^girasol ukata aceite\b')) OR
(lang='lt' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^saulėgrąžų aliejus\b')) OR
(lang='no' AND REGEXP_CONTAINS(LOWER(ngram), r'^solsikkeolje\b')) OR
(lang='my' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), LOWER(post)), r'^နေကြာဆီ')) OR
(lang='ta' AND REGEXP_CONTAINS(CONCAT(LOWER(ngram), ' ', LOWER(post)), r'^சூரியகாந்தி எண்ணெய்\b')) 

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