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 (110)) AND (sprop.id = 5 AND sprod.id IN (150)) GROUP BY p.id ORDER BY p.name ASC