GB5
SELECT DISTINCT `e`.*, `at_category_id`.`category_id`, `at_userid`.`userid`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `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_stock_status`.`stock_status` FROM `osn_catalog_product_entity` AS `e`
LEFT JOIN `osn_catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id)
LEFT JOIN `osn_marketplace_product` AS `at_userid` ON (at_userid.`mageproductid`=e.entity_id)
INNER JOIN `osn_catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 11)
INNER JOIN `osn_catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 11)
INNER JOIN `osn_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `osn_cataloginventory_stock_status` AS `at_stock_status` ON (at_stock_status.`product_id`=e.entity_id) AND (at_stock_status.stock_status = '1') AND (at_stock_status.website_id = '1') WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (at_userid.userid IN('3051', '3053', '3048', '3046', '305', '3052')) AND (price_index.final_price = price_index.price) GROUP BY `e`.`entity_id` ORDER BY FIELD(at_userid.userid,3051,3053,3048,3046,305,3052)
SELECT DISTINCT `e`.*, `at_category_id`.`category_id`, `at_userid`.`userid`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `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_stock_status`.`stock_status` FROM `osn_catalog_product_entity` AS `e`
LEFT JOIN `osn_catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id)
LEFT JOIN `osn_marketplace_product` AS `at_userid` ON (at_userid.`mageproductid`=e.entity_id)
INNER JOIN `osn_catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 11)
INNER JOIN `osn_catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 11)
INNER JOIN `osn_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `osn_cataloginventory_stock_status` AS `at_stock_status` ON (at_stock_status.`product_id`=e.entity_id) AND (at_stock_status.stock_status = '1') AND (at_stock_status.website_id = '1') WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (at_userid.userid IN('3051', '3053', '3048', '3046', '305', '3052')) AND (price_index.final_price = price_index.price) GROUP BY `e`.`entity_id` ORDER BY FIELD(at_userid.userid,3051,3053,3048,3046,305,3052)
No hay tiendas Se han encontrado , por favor redefinen Buscar
