Welcome to Pacific Wise , let's subscribe our newsletter to GET more updated promotion

Hotline: 1700-81-9022

My Cart
Error filtering template: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'min_price' in where clause is ambiguous, query was: SELECT DISTINCT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `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`.`manufacturer`, `e`.`manufacturer_value`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `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`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`tax_class_id`, `e`.`size`, `e`.`size_value`, `e`.`swatch_image`, `e`.`sm_featured`, `e`.`paint_brush`, `e`.`paint_brush_value`, `e`.`max_price`, `e`.`min_price`, `e`.`material_paper`, `e`.`material_paper_value`, `e`.`code`, `e`.`code_value`, `e`.`stick_on_note`, `e`.`special_from_date`, `e`.`special_to_date`, `at_category_id`.`category_id`, `cat_index`.`position` AS `cat_index_position`, `mv`.*, `bs`.*, `ra`.`reviews_count` AS `num_reviews_count`, `ra`.`rating_summary` AS `num_rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_1` AS `e` 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 LEFT JOIN `catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id) 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' LEFT JOIN (SELECT `report_event`.*, COUNT(`event_id`) AS `num_view_counts` FROM `report_event` WHERE (event_type_id = 1 AND store_id=1) GROUP BY `object_id`) AS `mv` ON mv.object_id = e.entity_id LEFT JOIN (SELECT `sales_bestsellers_aggregated_monthly`.`product_id`, SUM(`qty_ordered`) AS `ordered_qty` FROM `sales_bestsellers_aggregated_monthly` WHERE (store_id=1) GROUP BY `product_id`) AS `bs` ON bs.product_id = e.entity_id LEFT JOIN `review_entity_summary` AS `ra` ON e.entity_id = ra.entity_pk_value AND ra.store_id=1 LEFT 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 (min_price < 100) AND ((at_category_id.category_id IN('97', '185', '271', '274', '275', '276', '186', '272', '351', '352', '187', '273', '353', '354', '388', '188', '362', '363', '365', '355', '356', '357', '358', '359', '360', '366', '367', '368', '369', '370', '371', '372', '373', '374', '540', '375', '376', '377', '378', '379', '380', '381', '382', '383', '385', '386', '387', '389', '390', '391', '392', '393', '433'))) GROUP BY `e`.`entity_id` ORDER BY `ordered_qty` ASC LIMIT 5