SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`baseprice_product_amount`, `e`.`baseprice_product_unit`, `e`.`baseprice_product_unit_value`, `e`.`baseprice_reference_amount`, `e`.`baseprice_reference_unit`, `e`.`baseprice_reference_unit_value`, `e`.`cost`, `e`.`created_at`, `e`.`delivery_time`, `e`.`description`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`required_options`, `e`.`search_weight`, `e`.`short_description`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`storecredit_dropdown`, `e`.`storecredit_from`, `e`.`storecredit_rate`, `e`.`storecredit_to`, `e`.`storecredit_value`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`weight`, `e`.`weight_type`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_1` AS `e` 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 WHERE (e.visibility = '4') AND (e.type_id = 'customercredit') AND (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `e`.`entity_id` ASC LIMIT 12Credit Products /

Credit Products

Copyright © 2008-2019 www.ugou.de All rights reserved.