Untitled query #55433

SQL

USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), "|Lbn|", CONCAT('"',Lx.wbx_text,'"') AS label/*, (
  SELECT Dx.wbx_text FROM wbt_item_terms AS Dwbit
  JOIN wbt_term_in_lang AS Dwbtl ON Dwbtl.wbtl_id = Dwbit.wbit_term_in_lang_id
  JOIN wbt_type AS Dy            ON Dy.wby_id = Dwbtl.wbtl_type_id
  JOIN wbt_text_in_lang AS Dwbxl ON Dwbxl.wbxl_id = Dwbtl.wbtl_text_in_lang_id
  JOIN wbt_text AS Dx            ON Dx.wbx_id = Dwbxl.wbxl_text_id
  WHERE Lwbit.wbit_item_id = Dwbit.wbit_item_id
  AND Dy.wby_name = 'description'
  AND Dwbxl.wbxl_language = Lwbxl.wbxl_language
) AS description */
FROM wbt_item_terms   AS Lwbit
JOIN wbt_term_in_lang AS Lwbtl ON Lwbit.wbit_term_in_lang_id = Lwbtl.wbtl_id
JOIN wbt_type         AS Ly    ON Lwbtl.wbtl_type_id = Ly.wby_id
JOIN wbt_text_in_lang AS Lwbxl ON Lwbtl.wbtl_text_in_lang_id = Lwbxl.wbxl_id
JOIN wbt_text         AS Lx    ON Lwbxl.wbxl_text_id = Lx.wbx_id
WHERE Ly.wby_name = 'label'
AND Lwbxl.wbxl_language = 'bn'
AND Lx.wbx_text LIKE '% (%)'
AND Lx.wbx_text NOT LIKE '%:%'
AND Lx.wbx_text NOT LIKE '%)%(%'
LIMIT 500;
SQL

Checking query status...
