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 'AND fr.user_id > 0
AND (fr.friend_badge = 2 AND fr.guru_status = 1)
-- ...' at line 13"
}
SQL: [579]
SELECT
fr.id,
fr.name,
fr.slug,
cou.name AS country_name,
(SELECT asb.key FROM active_storage_attachments asa JOIN active_storage_blobs asb ON asb.id = asa.blob_id WHERE asa.record_id = fr.user_id AND asa.name = 'avatar' ORDER BY asb.id DESC LIMIT 1) AS avatar
FROM
friends fr
LEFT JOIN users ON users.id = fr.user_id
LEFT JOIN countries cou ON cou.id = fr.country
WHERE
fr.id !=
AND fr.user_id > 0
AND (fr.friend_badge = 2 AND fr.guru_status = 1)
-- AND fr.highlighted = 1
AND fr.excluido = 0
ORDER BY RAND()
LIMIT 20
Params: 0
Erro: GM5EYRXX