SELECT DISTINCT p.*, spf.feature_value_id AS type__id, spv3.value AS brand, spv4.value as model
					FROM shop_product p
					LEFT OUTER JOIN shop_product_features spf ON spf.product_id = p.id AND spf.feature_id = 668
					LEFT JOIN shop_product_features spf3 ON spf3.product_id = p.id AND spf3.feature_id = 1
					LEFT JOIN shop_feature_values_varchar spv3 ON spv3.feature_id = spf3.feature_id AND spf3.feature_value_id = spv3.id

					LEFT JOIN shop_product_features spf4 ON spf4.product_id = p.id AND spf4.feature_id = 665
					LEFT JOIN shop_feature_values_double spv4 ON spv4.feature_id = spf4.feature_id AND spf4.feature_value_id = spv4.id

					WHERE p.price>0 AND p.status=1 AND p.name NOT LIKE '%чехол%' AND p.name NOT LIKE '%стекло%' AND p.name NOT LIKE '%apple watch%' AND p.name NOT LIKE '%бампер%' AND p.name NOT LIKE '%накладка%'
						AND ( p.count>0 OR p.count IS NULL
						--	or p.summary LIKE '%preorder%'
						)
					GROUP BY p.id
					ORDER BY ppt DESC
					-- LIMIT 500