Wordpress wp-ml plugin: pivot term by languages

pivot.sql

 SELECT wp_icl_translations.trid,
  group_concat(case when wp_icl_translations.language_code  = "sp" then wp_terms.name end) as title,
  group_concat(case when wp_icl_translations.language_code  = "sp" then wp_term_taxonomy.term_taxonomy_id end) as sp,
  group_concat(case when wp_icl_translations.language_code  = "en" then wp_term_taxonomy.term_taxonomy_id end) as en
  FROM wp_terms 
  INNER JOIN wp_term_taxonomy ON wp_term_taxonomy.term_id = wp_terms.term_id
  INNER JOIN wp_icl_translations ON wp_icl_translations.element_id = wp_term_taxonomy.term_taxonomy_id AND wp_icl_translations.element_type = "tax_event-categories"
  WHERE wp_term_taxonomy.taxonomy = "event-categories" AND wp_term_taxonomy.parent = 0
  GROUP BY wp_icl_translations.trid