Query_time: 19890.914382  Lock_time: 0.000468 Rows_sent: 0  Rows_examined: 0

SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p 
				LEFT JOIN SC_product_options_values PrdOptVal0 ON p.productID=PrdOptVal0.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet0 ON p.productID=PrdOptSet0.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal1 ON p.productID=PrdOptVal1.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet1 ON p.productID=PrdOptSet1.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal2 ON p.productID=PrdOptVal2.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet2 ON p.productID=PrdOptSet2.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal3 ON p.productID=PrdOptVal3.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet3 ON p.productID=PrdOptSet3.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal4 ON p.productID=PrdOptVal4.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet4 ON p.productID=PrdOptSet4.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal5 ON p.productID=PrdOptVal5.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet5 ON p.productID=PrdOptSet5.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal6 ON p.productID=PrdOptVal6.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet6 ON p.productID=PrdOptSet6.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal7 ON p.productID=PrdOptVal7.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet7 ON p.productID=PrdOptSet7.`productID`
			 
				LEFT JOIN SC_product_options_values PrdOptVal8 ON p.productID=PrdOptVal8.`productID`
				LEFT JOIN SC_product_options_set PrdOptSet8 ON p.productID=PrdOptSet8.`productID`
			WHERE ((categoryID IN (653)) AND ( enabled=1 AND 0<=Price  AND Price<=1590 )) AND (
				PrdOptVal0.optionID=47
				AND
				(
					( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=239)
					 OR
					(PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%Balterio (Бельгия)%')
				)) AND (
				PrdOptVal1.optionID=47
				AND
				(
					( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=243)
					 OR
					(PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%Berry Floor (Бельгия)%')
				)) AND (
				PrdOptVal2.optionID=47
				AND
				(
					( PrdOptVal2.option_type=1 AND PrdOptSet2.variantID=241)
					 OR
					(PrdOptVal2.option_type=0 AND PrdOptVal2.option_value_ru LIKE '%Floor Step (Германия)%')
				)) AND (
				PrdOptVal3.optionID=47
				AND
				(
					( PrdOptVal3.option_type=1 AND PrdOptSet3.variantID=378)
					 OR
					(PrdOptVal3.option_type=0 AND PrdOptVal3.option_value_ru LIKE '%Kronotex (Германия)%')
				)) AND (
				PrdOptVal4.optionID=47
				AND
				(
					( PrdOptVal4.option_type=1 AND PrdOptSet4.variantID=380)
					 OR
					(PrdOptVal4.option_type=0 AND PrdOptVal4.option_value_ru LIKE '%Quick Step (Бельгия)%')
				)) AND (
				PrdOptVal5.optionID=50
				AND
				(
					( PrdOptVal5.option_type=1 AND PrdOptSet5.variantID=274)
					 OR
					(PrdOptVal5.option_type=0 AND PrdOptVal5.option_value_ru LIKE '%32 класс%')
				)) AND (
				PrdOptVal6.optionID=50
				AND
				(
					( PrdOptVal6.option_type=1 AND PrdOptSet6.variantID=275)
					 OR
					(PrdOptVal6.option_type=0 AND PrdOptVal6.option_value_ru LIKE '%33 класс%')
				)) AND (
				PrdOptVal7.optionID=52
				AND
				(
					( PrdOptVal7.option_type=1 AND PrdOptSet7.variantID=237)
					 OR
					(PrdOptVal7.option_type=0 AND PrdOptVal7.option_value_ru LIKE '%4-х сторонняя микрофаска%')
				)) AND (
				PrdOptVal8.optionID=49
				AND
				(
					( PrdOptVal8.option_type=1 AND PrdOptSet8.variantID=280)
					 OR
					(PrdOptVal8.option_type=0 AND PrdOptVal8.option_value_ru LIKE '%12 мм%')
				));