Výprodej značky Pentagon s cenou od 17 do 2654, skladem
33 produktů (2 stránky)
Filtry
Kategorie
- Pentagon Tactical372
- Pánské +286
- Doplňky +32
- Obuv a ponožky +30
- Outdoor +23
- Dárkové poukazy1
- Výprodej51
Filtry
Od Kč do Kč
SELECT SUM(CASE WHEN p.stock2>0 AND (p.price_special!='0') AND (p.stock)>0 THEN 1 ELSE 0 END) AS stock,SUM(CASE WHEN p.stock2>0 AND (p.price_special!='0') AND (p.quantity)>0 THEN 1 ELSE 0 END) AS arrive,SUM(CASE WHEN p.stock2>0 AND (p.price_special!='0') AND (p.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 WHERE p.status='1' AND ptc.category_id='10960'