Accesorios
(0)
SELECT COUNT(*) AS total FROM catalog_product_entity cp INNER JOIN catalog_product_entity_int cpi ON cp.entity_id=cpi.`entity_id` AND (cpi.attribute_id=95 AND cpi.`value`=4) AND cpi.store_id=0 INNER JOIN catalog_product_entity_int cpi2 ON cp.entity_id=cpi2.`entity_id` AND (cpi2.attribute_id=89 AND cpi2.`value`=1) AND cpi2.store_id=0 INNER JOIN cataloginventory_stock_status csi ON csi.product_id=cp.entity_id AND csi.`stock_status`=1 WHERE cp.entity_id IN(SELECT ccpx.`product_id` FROM catalog_category_product ccpx, catalog_category_product ccpx2 WHERE (ccpx.category_id=1208 AND ccpx2.`category_id`=6) AND ccpx.`product_id`=ccpx2.`product_id` );
Bicicletas
(0)
SELECT COUNT(*) AS total FROM catalog_product_entity cp INNER JOIN catalog_product_entity_int cpi ON cp.entity_id=cpi.`entity_id` AND (cpi.attribute_id=95 AND cpi.`value`=4) AND cpi.store_id=0 INNER JOIN catalog_product_entity_int cpi2 ON cp.entity_id=cpi2.`entity_id` AND (cpi2.attribute_id=89 AND cpi2.`value`=1) AND cpi2.store_id=0 INNER JOIN cataloginventory_stock_status csi ON csi.product_id=cp.entity_id AND csi.`stock_status`=1 WHERE cp.entity_id IN(SELECT ccpx.`product_id` FROM catalog_category_product ccpx, catalog_category_product ccpx2 WHERE (ccpx.category_id=1208 AND ccpx2.`category_id`=3) AND ccpx.`product_id`=ccpx2.`product_id` );
Calzado
(0)
SELECT COUNT(*) AS total FROM catalog_product_entity cp INNER JOIN catalog_product_entity_int cpi ON cp.entity_id=cpi.`entity_id` AND (cpi.attribute_id=95 AND cpi.`value`=4) AND cpi.store_id=0 INNER JOIN catalog_product_entity_int cpi2 ON cp.entity_id=cpi2.`entity_id` AND (cpi2.attribute_id=89 AND cpi2.`value`=1) AND cpi2.store_id=0 INNER JOIN cataloginventory_stock_status csi ON csi.product_id=cp.entity_id AND csi.`stock_status`=1 WHERE cp.entity_id IN(SELECT ccpx.`product_id` FROM catalog_category_product ccpx, catalog_category_product ccpx2 WHERE (ccpx.category_id=1208 AND ccpx2.`category_id`=5) AND ccpx.`product_id`=ccpx2.`product_id` );
Complementos
(0)
SELECT COUNT(*) AS total FROM catalog_product_entity cp INNER JOIN catalog_product_entity_int cpi ON cp.entity_id=cpi.`entity_id` AND (cpi.attribute_id=95 AND cpi.`value`=4) AND cpi.store_id=0 INNER JOIN catalog_product_entity_int cpi2 ON cp.entity_id=cpi2.`entity_id` AND (cpi2.attribute_id=89 AND cpi2.`value`=1) AND cpi2.store_id=0 INNER JOIN cataloginventory_stock_status csi ON csi.product_id=cp.entity_id AND csi.`stock_status`=1 WHERE cp.entity_id IN(SELECT ccpx.`product_id` FROM catalog_category_product ccpx, catalog_category_product ccpx2 WHERE (ccpx.category_id=1208 AND ccpx2.`category_id`=7) AND ccpx.`product_id`=ccpx2.`product_id` );
Electrónica
(0)
SELECT COUNT(*) AS total FROM catalog_product_entity cp INNER JOIN catalog_product_entity_int cpi ON cp.entity_id=cpi.`entity_id` AND (cpi.attribute_id=95 AND cpi.`value`=4) AND cpi.store_id=0 INNER JOIN catalog_product_entity_int cpi2 ON cp.entity_id=cpi2.`entity_id` AND (cpi2.attribute_id=89 AND cpi2.`value`=1) AND cpi2.store_id=0 INNER JOIN cataloginventory_stock_status csi ON csi.product_id=cp.entity_id AND csi.`stock_status`=1 WHERE cp.entity_id IN(SELECT ccpx.`product_id` FROM catalog_category_product ccpx, catalog_category_product ccpx2 WHERE (ccpx.category_id=1208 AND ccpx2.`category_id`=9) AND ccpx.`product_id`=ccpx2.`product_id` );
Recambios
(0)
SELECT COUNT(*) AS total FROM catalog_product_entity cp INNER JOIN catalog_product_entity_int cpi ON cp.entity_id=cpi.`entity_id` AND (cpi.attribute_id=95 AND cpi.`value`=4) AND cpi.store_id=0 INNER JOIN catalog_product_entity_int cpi2 ON cp.entity_id=cpi2.`entity_id` AND (cpi2.attribute_id=89 AND cpi2.`value`=1) AND cpi2.store_id=0 INNER JOIN cataloginventory_stock_status csi ON csi.product_id=cp.entity_id AND csi.`stock_status`=1 WHERE cp.entity_id IN(SELECT ccpx.`product_id` FROM catalog_category_product ccpx, catalog_category_product ccpx2 WHERE (ccpx.category_id=1208 AND ccpx2.`category_id`=8) AND ccpx.`product_id`=ccpx2.`product_id` );
Ropa
(32)
SELECT COUNT(*) AS total FROM catalog_product_entity cp INNER JOIN catalog_product_entity_int cpi ON cp.entity_id=cpi.`entity_id` AND (cpi.attribute_id=95 AND cpi.`value`=4) AND cpi.store_id=0 INNER JOIN catalog_product_entity_int cpi2 ON cp.entity_id=cpi2.`entity_id` AND (cpi2.attribute_id=89 AND cpi2.`value`=1) AND cpi2.store_id=0 INNER JOIN cataloginventory_stock_status csi ON csi.product_id=cp.entity_id AND csi.`stock_status`=1 WHERE cp.entity_id IN(SELECT ccpx.`product_id` FROM catalog_category_product ccpx, catalog_category_product ccpx2 WHERE (ccpx.category_id=1208 AND ccpx2.`category_id`=4) AND ccpx.`product_id`=ccpx2.`product_id` );
Utilizamos cookies para poderte ofrecer una experiencia mejorada. Si sigues navegando, entendemos que aceptas su uso MAS INFO