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`, `e`.`ramstorlek`, `e`.`ramstorlek_value`, `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`, `e`.`ramstorlek`, `e`.`ramstorlek_value` 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('156255', '160097', '160098', '160099', '160100', '160133', '160134', '160135', '160136', '160137', '160138', '160139', '160140', '160141', '160142', '160143', '160144', '160145', '160147', '160148', '160149', '160150', '160151', '160152', '160153', '160154', '160155', '160156', '160157', '160158', '160159', '160160', '160161', '160162', '160163', '160164', '160165', '160166', '160167', '160168', '160169', '160170', '160171', '160172', '160173', '160174', '160175', '160176', '160177', '160178', '160179', '160180', '160181', '160182', '160183', '160184', '160185', '160186', '160187', '160188', '160189', '160190', '160191', '160192', '160193', '160194', '163388', '163389', '163390', '163391', '163392', '163393', '163394', '163395', '163404', '163405', '163406', '163407', '163408', '163409', '163410', '163411', '163412', '163413', '163414', '163415', '163416', '163417', '163418', '163419', '163471', '163472', '163473', '163474', '163562', '163563', '163564', '163565', '163566', '163567', '163568', '163569', '163570', '163571', '163572', '163573', '163574', '163575', '163576', '163577', '163578', '163579', '163580', '163581', '163582', '163583', '163584', '163585', '163586', '163587', '163588', '163589', '163590', '163591', '163592', '163593', '163594', '163595', '163596', '163623', '163626', '163627', '163628', '163629', '164059', '164092', '164752', '164753', '164754', '164755', '164756', '164757', '164758', '164759', '164760', '164761', '164762', '164763', '164831', '164832', '164833', '164834', '164835', '164844', '164845', '164846', '164848', '164849', '164850', '165039', '165098', '165099', '165100', '165101', '165102', '165103', '165104', '168096', '168097', '168098', '168099', '168100', '168105', '168106', '168130', '168131', '168135', '168136', '168137', '168138', '168139', '168171', '168172', '168173', '168174', '168175', '168176', '168177', '168204', '168205', '168206', '168257', '168258', '168259', '168260', '168261', '168262', '168310', '168311', '168312', '168313', '168314', '188367', '188368', '188369', '188370', '188629', '188630', '188631', '188632', '188633', '188634', '194452', '194453', '194629', '194630', '194631', '194632', '198189', '198190', '198191', '198192', '201049', '201050', '201051', '201052', '201053', '201054')) ORDER BY `e`.`created_at` DESC, `e`.`entity_id` DESC
LIMIT 25
Filter