SQL
AخA
# SELECT CONCAT('Q', wbt_item_terms.wbit_item_id) as p
SELECT *
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
AND wbt_item_terms.wbit_item_id IN (142791, 187223)
# 142791 - uk, en, 187223 - en
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 IN ('uk', 'en')
# AND TRUE
# AND NOT EXISTS (SELECT * FROM wbt_text_in_lang WHERE 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
# AND wbt_text.wbx_text = 'шаблон проекту Вікімедіа'
#WHERE NOT EXISTS (
# SELECT * FROM wbt_type WHERE
# wbt_type.wby_name = 'alias'
# )
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.