Untitled

query stops working when trying to group_concat says unknown column
SELECT
    table1.items,
    table2.opt1,
    table3.opt2

FROM table1

LEFT JOIN table2 ON table1.id = table2.table1_id
...
LEFT JOIN table3 ON table2.id = table3.table2_id
WHERE
...
GROUP BY table1.items
HAVING
(SELECT COUNT(*) FROM table3 WHERE table3.table2_id = table2.id AND (table3.opt2 = 1)) = (1)

SELECT
   table1.items,
   table2.opt1,
   GROUP_CONCAT(table3.opt2 SEPERATOR ', ') as concat_opt2

FROM table1

LEFT JOIN table2 ON table1.id = table2.table1_id
...
LEFT JOIN table3 ON table2.id = table3.table2_id
WHERE
...
GROUP BY table1.items
HAVING
(SELECT COUNT(*) FROM table3 WHERE table3.table2_id = table2.id  AND (table3.opt2 = 1)) = (1)