SELECT DISTINCT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `vproduct`.`vendor_id`, `vstatus`.`shop_disable` AS `vendor_status`, `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`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`swatch_image`, `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`, `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`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`swatch_image` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2'
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `ced_csmarketplace_vendor_products` AS `vproduct` ON e.entity_id = vproduct.product_id
LEFT JOIN `ced_csmarketplace_vendor_shop` AS `vstatus` ON vproduct.vendor_id = vstatus.vendor_id
INNER JOIN `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 WHERE (stock_status_index.stock_status = 1) AND (vstatus.shop_disable is null or vstatus.shop_disable = 1) AND (e.entity_id IN('64328', '64329', '64330', '64331', '64332', '64333', '64338', '64339', '64340', '64341', '64349', '64350', '64351', '64352', '64355', '64356', '64357', '64358', '64359', '64360', '64361', '64362', '66920', '66921', '66922', '66923', '66925', '66926', '66927', '66928', '67062', '67063', '68530', '68532', '68533', '68534', '68535', '68536', '68537', '68538', '68539', '68540', '68541', '68542', '68543', '68544', '68545', '68546', '68547', '68548', '68555', '68556', '68557', '68558', '68559', '68566', '68567', '68568', '68569', '68601', '68607', '68613', '68614', '68622', '68623', '68624', '68625', '68627', '68628', '68629', '68630', '68631', '68632', '68633', '68634', '68635', '68636', '68637', '68638', '68639', '68640', '68641', '68642', '68643', '68644', '68645', '68646', '68647', '68648', '68649', '68650', '68651', '68652', '68653', '68654', '68655', '68656', '68657', '68658', '68659', '68660', '69083', '69084', '69085', '69086', '69087', '69088', '69089', '69090', '69091', '69092', '69093', '69094', '69095', '69096', '69097', '69098', '69101', '69102', '69103', '69104', '69105', '69106', '69107', '69108', '69109', '69110', '69111', '69112', '69113', '69114', '69115', '69116', '69126', '69127', '69128', '69129', '69130', '69131', '69132', '69133', '69134', '69135', '69136', '69137', '69138', '69139', '69140', '69141', '69146', '69147', '69148', '69149', '69150', '69151', '69152', '69153', '69154', '69155', '69156', '69157', '69158', '69159', '69160', '69161', '69162', '69163', '69164', '69165', '69166', '69167', '69168', '69169', '83226', '83227', '83228', '83229', '83284', '83285', '83286', '83287', '108758', '108759', '108760', '108761', '108762', '108763', '108764', '108765', '108766', '108767', '108768', '108769', '108770', '108771', '108772', '108773', '108774', '108775', '108776', '108777', '108778', '108932', '110119', '110120', '110121', '110123', '110124', '110125', '110126', '110127', '110128', '110129', '110130')) ORDER BY `cat_index_position` asc, `cat_index`.`position` asc, `e`.`entity_id` DESC
LIMIT 25
Filter
