Rol
SELECT `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`, `at_featured`.`value` AS `featured`, IF(at_sort_priority.value_id > 0, at_sort_priority.value, at_sort_priority_default.value) AS `sort_priority`, 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 `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '6'
LEFT JOIN `catalog_product_entity_int` AS `at_featured` ON (`at_featured`.`entity_id` = `e`.`entity_id`) AND (`at_featured`.`attribute_id` = '137') AND (`at_featured`.`store_id` = 0)
LEFT JOIN `catalog_product_entity_varchar` AS `at_sort_priority_default` ON (`at_sort_priority_default`.`entity_id` = `e`.`entity_id`) AND (`at_sort_priority_default`.`attribute_id` = '154') AND `at_sort_priority_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_sort_priority` ON (`at_sort_priority`.`entity_id` = `e`.`entity_id`) AND (`at_sort_priority`.`attribute_id` = '154') AND (`at_sort_priority`.`store_id` = 6)
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_6` ON mst_sorting_index_6.product_id = e.entity_id AND mst_sorting_index_6.store_id = 6
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0
LEFT JOIN `catalog_category_product_index_store6` AS `sorting_position` ON sorting_position.product_id = e.entity_id AND sorting_position.store_id = 6 AND sorting_position.category_id = 205
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 6 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
LEFT JOIN `inventory_stock_5` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (225, 227, 229, 231, 233, 235, 236, 240, 243, 449, 493, 585, 1106, 1314, 1347, 230, 239, 313, 366, 376, 377, 381, 386, 432, 450, 451, 1354, 237, 1348, 226, 259, 282, 372, 378, 497, 1120)) ORDER BY sorting_position.position desc, FIELD(e.entity_id,225,227,229,231,233,235,236,240,243,449,493,585,1106,1314,1347,230,239,313,366,376,377,381,386,432,450,451,1354,237,1348,226,259,282,372,378,497,1120) , CAST(sort_priority AS SIGNED) DESC
-
DVR WARHAMMER FANTASY NOCHES AGITADAS Y DIAS DIFICILESPrecio habitual 29.990 CLP Precio especial 25.492 CLP
-
DVR Starfinder soles muertos 1 Incidente en la estacionPrecio habitual 19.990 CLP Precio especial 16.992 CLP
-
DVR Starfinder soles muertos 2 El templo de los docePrecio habitual 19.990 CLP Precio especial 16.992 CLP
-
DVR Starfinder soles muertos 6 Imperio de los huesosPrecio habitual 19.990 CLP Precio especial 16.992 CLP
-
Aventuras en la Tierra Media - Guía Regional de La Montaña SolitariaPrecio habitual 39.990 CLP Precio especial 33.992 CLP
-
DVR Starfinder soles muertos 5 El decimo tercer portalPrecio habitual 19.990 CLP Precio especial 16.992 CLP
-
DVR JdR Pathfinder Guia del Mundo del Mar InteriorPrecio habitual 39.990 CLP Precio especial 33.992 CLP
-
DVR Warhammer El Enemigo en la Sombra CompendioPrecio habitual 34.990 CLP Precio especial 29.742 CLP
-
DVR VAESEN Un Secreto Malvado y otros MisteriosPrecio habitual 34.990 CLP Precio especial 29.742 CLP
-
DVR Starfinder soles muertos 3, Mundos fragmentadosPrecio habitual 19.990 CLP Precio especial 16.992 CLP
-
DVR JdR Pathfinder Guía del Jugador Avanzada de bolsilloPrecio habitual 12.990 CLP Precio especial 11.042 CLP
Página
- Actualmente estás leyendo página 1
- Página 2
- Página Siguiente