Wikidata MDanielsBot 1d(?) (4)

SQL

SELECT
  wbx_text AS current_label,
  REPLACE(wbx_text, "(čvor)", "([your replacement here, let me know below])") AS proposed_replacement_label_1,
  REPLACE(wbx_text, " (čvor)", "") AS proposed_replacement_label_2,
  CONCAT("{{Q|Q", wbit_item_id, "}}") AS item
FROM wbt_item_terms
  LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
  LEFT JOIN wbt_type ON wbtl_type_id = wby_id
  LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
  LEFT JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE wbtl_type_id = 1 # Label
  AND wbxl_language = 'bs'
  AND (wbx_text LIKE '%(čvor)')
GROUP BY wbx_text;
SQL

Checking query status...
