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

SQL

AخA
 
SELECT wbt_text.wbx_text as description, '' as tmp1, '' as tmp2, count(*) as c
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
JOIN wbt_text_in_lang ON wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id
                     AND wbt_text_in_lang.wbxl_language = 'en'
JOIN wbt_type         ON wbt_term_in_lang.wbtl_type_id = wbt_type.wby_id
                     AND wbt_type.wby_name = 'description'
JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
WHERE wbt_text.wbx_text NOT IN (
  SELECT wbt_text.wbx_text 
  FROM wbt_item_terms
  JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
  JOIN wbt_text_in_lang ON wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id
                       AND wbt_text_in_lang.wbxl_language = 'uk'
  JOIN wbt_type         ON wbt_term_in_lang.wbtl_type_id = wbt_type.wby_id
                       AND wbt_type.wby_name = 'description'
  JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
)
group by wbt_text.wbx_text 
order by c desc, wbt_text.wbx_text
limit 500000
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
All SQL code is licensed under CC0 License.

Checking query status...