SELECT p.id, p.class_id, p.name, p.description, p.ua_name, p.ua_description,
p.image, p.price, p.vote, p.voters, p.i1, p.i2, p.i3, p.i4, p.storage,
p.visits, p.mopt, p.kolvo, p.comment, p.adddate, p.special,
a.name AS aname, fg.name AS fname
FROM products p
JOIN sumki av ON p.id = av.product_id
JOIN attributes a ON av.attr_id = a.id AND a.class_id = 223
JOIN filters_groups fg ON av.filter_group = fg.id AND fg.class_id = 223
RIGHT JOIN (SELECT av.product_id FROM attributes a LEFT JOIN sumki av ON a.id=av.attr_id WHERE a.class_id=223 AND ( av.attr_id=1490 AND av.value=1 ) GROUP BY product_id) products_ids ON p.id = products_ids.product_id
WHERE p.class_id = 223 AND p.i1 <> 'nophoto.jpg'
GROUP BY p.id
az
LIMIT 0, 32
Разом: 
