SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table b_crm_dynamic_items_129 (ID int, CREATED_BY int) engine = InnoDB; create table b_user ( ID int(18) ) engine = InnoDB; create table b_utm_user ( VALUE_ID int not null, VALUE_INT int null ) engine = InnoDB; create table b_iblock_section ( ID int, NAME varchar(255) not null ) engine = InnoDB; INSERT INTO b_crm_dynamic_items_129 (ID, CREATED_BY) VALUES (1, 333), (2, 333), (3, 333), (4, 333), (5, 333), (6, 333), (7, 333); INSERT INTO b_user (ID) VALUES (333); INSERT INTO b_utm_user (VALUE_ID, VALUE_INT) VALUES (333, 61), (333, 63); INSERT INTO b_iblock_section (ID, NAME) VALUES (61, 'Подразделение1'), (63, 'Подразделение2'); SELECT t.ID, t.CREATED_BY, SUBSTRING_INDEX(GROUP_CONCAT(buu.VALUE_INT), ',', 1) VALUE_INT, GROUP_CONCAT(bis.NAME) NAME FROM b_crm_dynamic_items_129 t LEFT JOIN b_user bu ON bu.ID = t.CREATED_BY LEFT JOIN b_utm_user buu ON buu.VALUE_ID = bu.ID LEFT JOIN b_iblock_section bis ON bis.ID = buu.VALUE_INT WHERE t.CREATED_BY = 333 GROUP BY t.ID, t.CREATED_BY ORDER BY t.ID
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear