Query Error (SELECT
p.produs_id,
p.produs_denumire,
p.produs_img,
p.produs_tip,
p.produs_grad_risc,
p.produs_id_categ_fk,
p.produs_permalink,
p.produs_user_votes_average,
pc.categorie,
pr.producator_denumire
FROM
produse AS p
LEFT JOIN
producatori AS pr ON pr.producator_id = p.producator_id_fk
LEFT JOIN
produse_categorii AS pc ON pc.id_categ = p.produs_id_categ_fk
INNER JOIN
ingrediente_produse_selectie AS ips ON ips.produs_id = p.produs_id
INNER JOIN
ingrediente AS i ON i.ingr_id = ips.ingr_id
WHERE
(
p.produs_denumire LIKE ("%ca psuni%")
OR p.produs_tip LIKE ("%ca psuni%")
OR pr.producator_denumire LIKE ("%ca psuni%")
OR p.produs_ingrediente LIKE ("%ca psuni%")
OR p.produs_ingrediente_pentru_cautare LIKE ("%ca psuni%")
OR i.ingr_denumire LIKE ("%ca psuni%")
)
AND p.produs_activ = "Da"
GROUP BY
p.produs_id
ORDER BY p.produs_id DESC)
