Urbanas y Daypacks

Filtrar por
Filtrar Por
Categoría
  • Urbanas y Daypacks
    • Hombre
    • Mujer
  • Urbanas & Daypacks
    • Hombre
    • Mujer
  • Trekking & Backpacking
    • 30 Litros
      • Hombre
      • Mujer
Color
Más Filtros
Ahora comprando por
  1. Categoría
    Hombre
SELECT DISTINCT  `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `price_index`.`udmp_new_min_price`, `price_index`.`udmp_new_max_price`, `price_index`.`udmp_new_cnt`, `price_index`.`udmp_used_min_price`, `price_index`.`udmp_used_max_price`, `price_index`.`udmp_used_cnt`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `udropship_vendor_product_limit` AS `udsclimit` ON e.entity_id=udsclimit.product_id
 INNER JOIN `catalog_product_index_price_ws2` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0 and price_index.udropship_vendor=0
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id AND (product.created_in <= '1648512180' AND product.updated_in > '1648512180')
 INNER JOIN `inventory_stock_4` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE ((udsclimit.class_id in (-1, '*')) AND (stock_status_index.is_salable = 1) AND (e.entity_id IN (1350008, 1350007, 1350012, 1350011, 1350010, 1350009, 520573, 520593, 520594, 522182, 548946, 675991, 1320650, 1320655, 1332609, 1352622, 1352626, 1354992, 1354993, 1354995))) AND (e.created_in <= '1648512180') AND (e.updated_in > '1648512180') ORDER BY FIELD(e.entity_id,1350008,1350007,1350012,1350011,1350010,1350009,520573,520593,520594,522182,548946,675991,1320650,1320655,1332609,1352622,1352626,1354992,1354993,1354995)
Ver como Parrilla Lista

20 artículos

Por página
Ver como Parrilla Lista

20 artículos

Por página