SELECT r.*,
FROM jos_p_review_att as a left join jos_p_review_value as v ON v.id_att= a.id_att
left join jos_p_review as r ON v.id_rev=r.id_rev
WHERE r.id_produkt=
AND r.published=1
AND a.show=1
GROUP BY r.id_rev
ORDER BY r.created ,ordering