Unknown column 'P.peso' in 'field list'
SELECT P.*,
JSON_EXTRACT_BRIGHT(P.nome, '$.pt') AS nome,
JSON_EXTRACT_BRIGHT(P.url, '$.pt') AS url,
JSON_EXTRACT_BRIGHT(P.foto_pequena, '$.pt') AS foto_pequena,
P.peso,
P.preco_riscado,
P.preco_riscado,
P.volume,
C.quantity,
C.user_id,
C.product_id,
C.is_requires_client_shipping,
C.viatura,
V.id AS variacao_id,
V.preco AS variacao_preco,
V.preco_riscado AS variacao_preco_riscado,
V.nome AS variacao_nome
FROM cart C
LEFT JOIN produtos AS P ON P.id = C.product_id
LEFT JOIN variacao AS V ON V.id = C.variacao_id
WHERE C.user_id = '6lo1uva34e89uq6sstpaqd7nju'
GROUP BY C.id
