SELECT p.id AS `id`, p.name AS `name`, p.price AS `price`, p.cat AS `cat`, p.description AS `desc`, p.model AS `model`, p.company AS `company`, p.atrgroup AS `atrg`, c.name AS `cname`, AVG(ype_review.rating) AS `rating` FROM `ype_product` `p` JOIN `ype_company` c ON (p.company = c.id) LEFT JOIN `ype_review` ON(ype_review.product = p.id) JOIN `ype_category` cat ON (cat.id = p.cat) JOIN `ype_spec_prop` sprop ON (sprop.spec = cat.spec) JOIN `ype_spec_prop_prod` spp ON (spp.product = p.id) JOIN `ype_spec_prod` sprod ON (spp.prod = sprod.id) WHERE p.cat = 81 AND (sprop.id = 3 AND sprod.id IN (174)) AND (sprop.id = 5 AND sprod.id IN (150)) GROUP BY p.id ORDER BY p.name ASC