array(3) { [0]=> string(5) "42000" [1]=> int(1064) [2]=> string(229) "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'title', title, 'total_ocorrencias', total_ocorrencias) ) FROM friends_ca...' at line 34" } SQL: [1540] WITH city_friends_geral AS ( SELECT fr.id FROM friends fr INNER JOIN users ON users.id = fr.user_id WHERE fr.city = '12674' AND fr.user_id > 0), city_friends_filtro AS ( SELECT fr.id FROM city_friends_geral fr WHERE 1 = 1 ), total_friends AS ( SELECT COALESCE(COUNT(*), 0) AS totalFriends FROM city_friends_filtro ), friends_categories AS ( SELECT fcat.id, fcat.friend_id, fcat.category_id, categories.title, COUNT(*) AS total_ocorrencias FROM friends_categories fcat INNER JOIN city_friends_geral cf ON cf.id = fcat.friend_id INNER JOIN categories ON categories.id = fcat.category_id WHERE categories.active = 1 GROUP BY fcat.category_id ), friends_languages AS ( SELECT flan.id, flan.language_id, languages.en_title AS title, COUNT(*) AS total_ocorrencias FROM friends_languages flan INNER JOIN city_friends_geral cf ON cf.id = flan.friend_id INNER JOIN languages ON languages.id = flan.language_id GROUP BY flan.language_id ) SELECT JSON_OBJECT( 'totalFriends', (SELECT totalFriends FROM total_friends), 'interests', ( SELECT JSON_ARRAYAGG( JSON_OBJECT('id', category_id', category_id, 'title', title, 'total_ocorrencias', total_ocorrencias) ) FROM friends_categories ), 'languages', ( SELECT JSON_ARRAYAGG( JSON_OBJECT('id', language_id', language_id, 'title', title, 'total_ocorrencias', total_ocorrencias) ) FROM friends_languages ) ) AS result Params: 0

Erro: KDWAV78R