Home /
Search results for: 'sp tools bonus'

Search results for 'sp tools bonus'

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `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`, `cat_index`.`position` AS `cat_index_position` 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 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(3, 4) AND cat_index.category_id = '3' WHERE (e.status = 1) AND (e.entity_id IN(25830, 25825, 38597, 43765, 25826, 43797, 39337, 49800, 29801, 39332, 38596, 38595, 49085, 49783, 49782, 26773, 38577, 38576, 38575, 38574, 39247, 44447, 49801, 49799, 32822, 32348, 39335, 39334, 43718, 43717, 48659, 48654, 44740, 42876, 34370, 34369, 32320, 38645, 43555, 38862, 49010, 49017, 44726, 45298, 49821, 32286, 43490, 49089, 49798, 49797, 49796, 49818, 44752, 43515, 49715, 30589, 30598, 31778, 49009, 49008, 49007, 49086, 23802, 25317, 31535, 31964, 32369, 33665, 35247, 35238, 37452, 36141, 39254, 42877, 43016, 43324, 43318, 43502, 44422, 44421, 45413, 45386, 23769, 27477, 30786, 31176, 31158, 32120, 32344, 33030, 34155, 37187, 37185, 37183, 37076, 36676, 36627, 37694, 38613, 38517, 38642, 39256, 39348, 39999, 42884, 43492, 43491, 43489, 44524, 44515, 44462, 44553, 44753, 44742, 44741, 44739, 44738, 44735, 44734, 44733, 44732, 44731, 45526, 49019, 49018, 49607, 44803, 37707, 48656, 48653, 48893, 49700, 49704, 44801, 49702, 48663, 48662, 31106, 50274, 50273)) ORDER BY FIELD(`e`.`entity_id`, 25830, 25825, 38597, 43765, 25826, 43797, 39337, 49800, 29801, 39332, 38596, 38595, 49085, 49783, 49782, 26773, 38577, 38576, 38575, 38574, 39247, 44447, 49801, 49799, 32822, 32348, 39335, 39334, 43718, 43717, 48659, 48654, 44740, 42876, 34370, 34369, 32320, 38645, 43555, 38862, 49010, 49017, 44726, 45298, 49821, 32286, 43490, 49089, 49798, 49797, 49796, 49818, 44752, 43515, 49715, 30589, 30598, 31778, 49009, 49008, 49007, 49086, 23802, 25317, 31535, 31964, 32369, 33665, 35247, 35238, 37452, 36141, 39254, 42877, 43016, 43324, 43318, 43502, 44422, 44421, 45413, 45386, 23769, 27477, 30786, 31176, 31158, 32120, 32344, 33030, 34155, 37187, 37185, 37183, 37076, 36676, 36627, 37694, 38613, 38517, 38642, 39256, 39348, 39999, 42884, 43492, 43491, 43489, 44524, 44515, 44462, 44553, 44753, 44742, 44741, 44739, 44738, 44735, 44734, 44733, 44732, 44731, 45526, 49019, 49018, 49607, 44803, 37707, 48656, 48653, 48893, 49700, 49704, 44801, 49702, 48663, 48662, 31106, 50274, 50273) ASC LIMIT 48