COVID-19:IMPORTANT DELIVERY NOTICE Due to COVID-19 restrictions there may be a delay on some orders being dispatched due to suppliers not having stock. We always endeavour to dispatch orders as soon as possible but sometimes this is not possible due to factors out of our control.
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`price`, `e`.`small_image`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`thumbnail`, `e`.`short_description`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`links_exist`, `e`.`wtp_model`, `e`.`call_for_price_active`, `e`.`tool_a_day_date`, `e`.`tool_a_day_price`, `e`.`wtp_nav_product`, `e`.`wtp_newsletter`, `e`.`wtp_bonus_description`, `e`.`wtp_bonus_type`, `e`.`wtp_bonus_type_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` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index` 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 = '794'
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 (e.status = 1) AND ((price_index.min_price -(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 2 THEN 0.1000 WHEN 4 THEN 0.1000 ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN 0.1000 WHEN 4 THEN 0.1000 ELSE 0 END)+((price_index.min_price-(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 2 THEN 0.1000 WHEN 4 THEN 0.1000 ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN 0.1000 WHEN 4 THEN 0.1000 ELSE 0 END))*CASE price_index.tax_class_id WHEN 2 THEN 0.1000 WHEN 4 THEN 0.1000 ELSE 0 END)) >= 49.995000) ORDER BY `e`.`name` ASC LIMIT 48
© 2018 VEK TOOLS. All Rights Reserved. | Powered by 
