text: with all_text as (
      select corpus.id,
             lower(coalesce(meta.title, '') || coalesce(meta.abstract, '')) text
      from oecd.en_2010_2020 corpus
               inner join gcp_cset_links_v2.all_metadata_with_cld2_lid meta on meta.id = corpus.id
  )
  select id,
         (text like '%active learning%'
             or text like '%adaptive learning%'
             or text like '%anomaly detection%'
             or text like '%artificial intelligence%'
             or text like '%associative learning%'
             or text like '%autonomous navigation%'
             or text like '%autonomous system%'
             or text like '%autonomous vehicle%'
             or text like '%average link clustering%'
             or text like '%back propagation%'
             or text like '%backpropagation%'
             or text like '%binary classification%'
             or text like '%bionlp%'
             or text like '%boltzmann machine%'
             or text like '%character recognition%'
             or text like '%classification algorithm%'
             or text like '%classification label%'
             or text like '%clustering method%'
             or text like '%complete link clustering%'
             or text like '%computer aided diagnosis%'
             or text like '%computer vision%'
             or text like '%deep learning%'
             or text like '%ensemble learning%'
             or text like '%evolutionary algorithm%'
             or regexp_contains(text, 'fac\\w+ expression recognition')
             or regexp_contains(text, 'fac\\w+ identification')
             or regexp_contains(text, 'fac\\w+ recognition')
             or text like '%feature extraction%'
             or text like '%feature learning%'
             or text like '%feature matching%'
             or text like '%feature selection%'
             or text like '%feature vector%'
             or text like '%feedforward network%'
             or text like '%feedforward neural network%'
             or text like '%fuzzy clustering%'
             or text like '%generative adversarial network%'
             or text like '%gradient algorithm%'
             or text like '%graph matching%'
             or text like '%graphical model%'
             or text like '%handwriting recognition%'
             or text like '%hierarchical clustering%'
             or text like '%hierarchical model%'
             or text like '%human robot%'
             or text like '%image annotation%'
             or text like '%image classification%'
             or text like '%image matching%'
             or text like '%image processing%'
             or text like '%image registration%'
             or text like '%image representation%'
             or text like '%image retrieval%'
             or text like '%incremental clustering%'
             or text like '%information extraction%'
             or text like '%information fusion%'
             or text like '%information retrieval%'
             or text like '%k nearest neighbor%'
             or text like '%knowledge based system%'
             or text like '%knowledge discovery%'
             or text like '%knowledge representation%'
             or text like '%language identification%'
             or text like '%machine learning%'
             or text like '%machine perception%'
             or text like '%machine translation%'
             or text like '%multi class classification%'
             or text like '%multi label classification%'
             or text like '%multi task learning%'
             or text like '%natural language generation%'
             or text like '%natural language processing%'
             or text like '%natural language understanding%'
             or text like '%neural network%'
             or text like '%object recognition%'
             or text like '%one shot learning%'
             or text like '%pattern matching%'
             or text like '%pattern recognition%'
             or text like '%random forest%'
             or regexp_contains(text, 'recommend\\w+ system')
             or text like '%recurrent network%'
             or text like '%reinforcement learning%'
             or regexp_contains(text, 'scene\\w+ classification')
             or regexp_contains(text, 'scene\\w+ understanding')
             or text like '%self driving car%'
             or text like '%semi supervised learning%'
             or text like '%sentiment classification%'
             or text like '%single link clustering%'
             or text like '%spatial learning%'
             or text like '%speech processing%'
             or text like '%speech recognition%'
             or text like '%speech synthesis%'
             or text like '%statistical learning%'
             or text like '%strong artificial intelligence%'
             or text like '%supervised learning%'
             or text like '%support vector machine%'
             or text like '%text mining%'
             or text like '%text processing%'
             or text like '%transfer learning%'
             or text like '%translation system%'
             or text like '%unsupervised learning%'
             or text like '%video classification%'
             or text like '%video processing%'
             or text like '%weak artificial intelligence%'
             or text like '%zero shot learning%') as keyword_hit
  from all_text
  