SELECT SUM(CASE WHEN (p.price_special!='0') AND p.manufacturer_id='829' AND pd.filter_id='30' AND pv.option_value_id='705' AND (pv.stock2)>0 THEN 1 ELSE 0 END) AS stock,SUM(CASE WHEN (p.price_special!='0') AND p.manufacturer_id='829' AND pd.filter_id='30' AND pv.option_value_id='705' AND (pv.quantity)>0 THEN 1 ELSE 0 END) AS arrive,SUM(CASE WHEN (p.price_special!='0') AND p.manufacturer_id='829' AND pd.filter_id='30' AND pv.option_value_id='705' AND (pv.quantity_store)>0 THEN 1 ELSE 0 END) AS instore FROM `product` p INNER JOIN `product_to_category` ptc ON p.product_id=ptc.product_id INNER JOIN `product_variant` pv ON pv.product_id=p.product_id INNER JOIN `product_description` pd ON pd.product_id=p.product_id WHERE p.status='1' AND ptc.category_id='8792' AND pv.language_id='1' AND pd.language_id='1'
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in /home/www/netiq.biz/server/engine/eshop2/themes/default/fc.php on line 2623
Pánské oblečení Pentagon s cenou od 351 do 7141, od značky Pentagon, v barvě CCE, ve velikosti 50 L - Pentagontac.cz: Pentagon Tactical vybavení