Galera ja tentei usar 3 tipos diferente de layout e todos dão o mesmo error na database
Error Number: 1140
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()
alguem poderia me ajudar ?