Nalgene

SELECT DISTINCT  1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`price_view`, `e`.`url_key`, `e`.`links_exist`, `e`.`swatch_image`, `e`.`weltpixel_hover_image`, `e`.`destacado2`, `e`.`discount_percent_filter`, `e`.`tela`, `e`.`tela_value`, `e`.`destacado5`, `e`.`destacado4`, `e`.`rt_only`, `e`.`sin_stock`, `e`.`destacado`, `e`.`child_color_sku`, `e`.`new_arrival`, `e`.`edit_choice`, `e`.`disponibilidad_tienda_fisica`, `e`.`tipo_fit`, `e`.`tipo_fit_value`, `e`.`color_multiple`, `e`.`material`, `e`.`sale`, `e`.`nombre_ingles`, `e`.`marca`, `e`.`marca_value`, `e`.`cyber`, `e`.`destacado3`, `e`.`oversized`, `e`.`genero`, `e`.`genero_value`, `e`.`disponible_online`, `e`.`color`, `e`.`color_value`, `e`.`priority_order`, `e`.`udropship_vendor`, `e`.`udropship_vendor_value`, `e`.`retiro_express`, `e`.`retiro_express_value`, `e`.`mp_sizechart`, `e`.`curva`, `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`, `product_entity`.`row_id`, `stock_status_index`.`is_salable` FROM `catalog_product_flat_2` 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_entity` ON product_entity.entity_id = e.entity_id AND (product_entity.created_in <= '1670199120' AND product_entity.updated_in > '1670199120')
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id AND (product.created_in <= '1670199120' AND product.updated_in > '1670199120')
 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 (1382117, 1382118, 1382116, 1382115, 1382113, 1382112, 1382111, 1382110, 1382109, 1382108, 1382107, 1382106, 1382105, 1382104, 1382103, 1382102, 1382101, 1382100, 1382099, 1382119, 1382120, 1382125, 1382124, 1382123, 1382122, 1382121, 1382130, 1382129, 1382128, 1382127, 1382126)) ORDER BY FIELD(e.entity_id,1382117,1382118,1382116,1382115,1382113,1382112,1382111,1382110,1382109,1382108,1382107,1382106,1382105,1382104,1382103,1382102,1382101,1382100,1382099,1382119,1382120,1382125,1382124,1382123,1382122,1382121,1382130,1382129,1382128,1382127,1382126)
Ver como Parrilla Lista

31 artículos

Por página
  1. 16oz Wide Mouth Sustain
    16oz Wide Mouth Sustain
    $13.900
  2. Easy Sipper 63mm
    Easy Sipper 63mm
    $3.900
  3. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  4. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  5. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  6. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  7. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  8. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  9. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  10. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  11. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  12. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  13. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  14. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  15. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  16. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  17. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  18. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  19. Grip-n-Gulp Sustain
    Grip-n-Gulp Sustain
    $16.500
  20. Nalgene 32oz Cool Stuff Neoprene Carrier
    Nalgene 32oz Cool Stuff Neoprene Carrier
    $11.900
  21. Nalgene 32oz Cool Stuff Neoprene Carrier
    Nalgene 32oz Cool Stuff Neoprene Carrier
    $7.900
  22. Nalgene 32oz Wide Mouth Sustain
    Nalgene 32oz Wide Mouth Sustain
    $16.900
  23. Nalgene 32oz Wide Mouth Sustain
    Nalgene 32oz Wide Mouth Sustain
    $16.900
  24. Nalgene 32oz Wide Mouth Sustain
    Nalgene 32oz Wide Mouth Sustain
    $16.900
  25. Nalgene 32oz Wide Mouth Sustain
    Nalgene 32oz Wide Mouth Sustain
    $16.900
  26. Nalgene 32oz Wide Mouth Sustain
    Nalgene 32oz Wide Mouth Sustain
    $16.900
  27. Nalgene 63 mm Loop-Top Closure
    Nalgene 63 mm Loop-Top Closure
    $4.390
  28. Nalgene 63 mm Loop-Top Closure
    Nalgene 63 mm Loop-Top Closure
    $4.390
  29. Nalgene 63 mm Loop-Top Closure
    Nalgene 63 mm Loop-Top Closure
    $4.390
  30. Nalgene 63 mm Loop-Top Closure
    Nalgene 63 mm Loop-Top Closure
    $4.390
  31. Nalgene 63 mm Loop-Top Closure
    Nalgene 63 mm Loop-Top Closure
    $4.390
Ver como Parrilla Lista

31 artículos

Por página