SELECT SUM(CASE WHEN ='4' AND p.gen_kid='1' AND pv.option_value_id='711' AND (pv.stock)>0 THEN 1 ELSE 0 END) AS stock,SUM(CASE WHEN ='4' AND p.gen_kid='1' AND pv.option_value_id='711' AND (pv.quantity)>0 THEN 1 ELSE 0 END) AS arrive,SUM(CASE WHEN ='4' AND p.gen_kid='1' AND pv.option_value_id='711' 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 WHERE p.status='1' AND ptc.category_id='8797' AND pv.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 2614

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 2700

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 2800

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 2871

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 2943
Pouzdra na zásobník Pentagon Elpis Pistol Mag - Pentagontac.cz: Pentagon Tactical vybavení
0
0
0

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 1362

Pouzdra na zásobník Pentagon Elpis Pistol Mag

produktů (1 stránka)
Filtry

Kategorie

Filtry

Máte zapnuté filtrování, zobrazuje se vám produktů z celkových 3. Zobrazit vše

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in /home/www/netiq.biz/server/engine/eshop2/themes/default/category.php on line 38
produktů

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in /home/www/netiq.biz/server/engine/eshop2/themes/default/category.php on line 6
Menu

Tento web používá k poskytování služeb, personalizaci reklam a analýze návštěvnosti soubory cookie. Používáním tohoto webu s tím souhlasíte.

Další informace