Home /
Search results for: 'dewalt bonus'

Search results for 'dewalt 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(44208, 50584, 50585, 50583, 50560, 50515, 50494, 50442, 50424, 50394, 50298, 50296, 50297, 50295, 50294, 50293, 50292, 50291, 50290, 50288, 50289, 50286, 50287, 50274, 50273, 50198, 50038, 50039, 49966, 49961, 49949, 49821, 49818, 49801, 49800, 49799, 49796, 49798, 49797, 49783, 49782, 49727, 49715, 49705, 49704, 49700, 49702, 49681, 49641, 49643, 49640, 49610, 49611, 49609, 49607, 49583, 49541, 49542, 49510, 49507, 49508, 49509, 49506, 49504, 49503, 49489, 49374, 49359, 49324, 49303, 49146, 49145, 49144, 49143, 49142, 49141, 49140, 49139, 49138, 49137, 49110, 49109, 49108, 49095, 49100, 49094, 49093, 49092, 49089, 49088, 49086, 49084, 49085, 49019, 49018, 49017, 49008, 49010, 49009, 49007, 48989, 48987, 48986, 48984, 48985, 48981, 48983, 48980, 48978, 48979, 48977, 48975, 48976, 48969, 48914, 48893, 48878, 48845, 48815, 48765, 48701, 48700, 48698, 48697, 48696, 48695, 48694, 48693, 48681, 48680, 48662, 48663, 48659, 48655, 48656, 48654, 48653, 48640, 48641, 48639, 48638, 48632, 48631, 48630, 48629, 48627, 48626, 48625, 48623, 48624, 48578, 48576, 48577, 48569, 45586, 45557, 45556, 45554, 45555, 45553, 45552, 45551, 45550, 45549, 45537, 45534, 45532, 45527, 45526, 45520, 45511, 45510, 45509, 45504, 45503, 45502, 45413, 45386, 45354, 45296, 45297, 45298, 45044, 44901, 44900, 44803, 44801, 44752, 44753, 44755, 44748, 44740, 44741, 44742, 44746, 44738, 44739, 44734, 44735, 44733, 44732, 44731, 44726, 44665, 44553, 44524, 44515, 44508, 44506, 44489, 44488, 44487, 44486, 44467, 44466, 44464, 44462, 44450, 44447, 44440, 44439, 44438, 44437, 44436, 44433, 44422, 44421, 44388, 44376, 44374, 44373, 44323, 44296, 44207, 44206, 44205, 44200, 44189, 44181, 44179, 44180, 26645, 44126, 44104, 44105, 44106, 44102, 44103, 44095, 44089, 44068, 44067, 44065, 44066, 44064, 44063, 44061, 44062, 44056, 44057, 44058, 44059, 44060, 44055, 44043, 44044, 44042, 44046, 44045, 44040, 23280, 23343, 23426, 23427, 44034, 44033, 44032, 44031, 44012, 43797, 43765, 43746, 43718, 43717, 43555, 43515, 43502, 43492, 43490, 43491, 43489, 43487, 43488, 43441, 43440, 43433, 43418, 43351, 43350, 43349, 43348, 43347, 43345, 43343, 43342, 43341, 43339, 43338, 43337, 43336, 43335, 43333, 43324, 43319, 43318, 43240, 43241, 43154, 43125, 43078, 43051, 43020, 43019, 43016, 43018, 42979, 42981, 42980, 42881, 42887, 42884, 42877, 42876, 39999, 39836, 39807, 39824, 39796, 39792, 39534, 39492, 39493, 39485, 39467, 39468, 39466, 39465, 39454, 39452, 39439, 39433, 39434, 39423, 39387, 39386, 39385, 32466, 39384, 39368, 39367, 39366, 39348, 39337, 39335, 39334, 39332, 39254, 39256, 39263, 39247, 39214, 39200, 39159, 39158, 39157, 39154, 39153, 39149, 39148, 39144, 39145, 39146, 39147, 39143, 39142, 39141, 39140, 39139, 39138, 39136, 39137, 39134, 39135, 39084, 39081, 39082, 39083, 39080, 39057, 39058, 39059, 39051, 39049, 39048, 39037, 39032, 39031, 39018, 38966, 38867, 38864, 38806, 38805, 38804, 38694, 38693, 38671, 38645, 38642, 38613, 38610, 38608, 38597, 38596, 38595, 38577, 38576, 38575, 38574, 38517, 38502, 38499, 37816, 37707, 37694, 37551, 37465, 37452, 25825, 25826, 25830, 25855, 26054, 37183, 37185, 37187, 37168, 37157, 37100, 37099, 37097, 37086, 37078, 37076, 36676, 36627, 36141, 35247, 34883, 34630, 34631, 34370, 34369, 34155, 34115, 29607, 29608, 29704, 33917, 33881, 33880, 33879, 33878, 33877, 33871, 33872, 33869, 33870, 33864, 33865, 33866, 33867, 33868, 33863, 33858, 33828, 33831, 33826, 33808, 33789, 33665, 33656, 33606, 33605, 33571, 33455, 33030, 32953, 32952, 32950, 32948, 32946, 32947, 32943, 32935, 32936, 32908, 32822, 32847, 32845, 32797, 32775, 32773, 32757, 32737, 32733, 32721, 32690, 32688, 32689, 32639, 32638, 32634, 32588, 32586, 32516, 32369, 32348, 32344, 32320, 32321, 32314, 32312, 32283, 32286, 32270, 32120, 32091, 32073, 32072, 32071, 32070, 32040, 31977, 31964, 31938, 31825, 31792, 31789, 31788, 31787, 31778, 31739, 31722, 31535, 31486, 31383, 31303, 31176, 31152, 31158, 31149, 31148, 31147, 31106, 30786, 30683, 30598, 30589, 30414, 30367, 30344, 30307, 30122, 29994, 29974, 29991, 29943, 29861, 29862, 29852, 29836, 29838, 29839, 29840, 29834, 29835, 29832, 29833, 29828, 29831, 29830, 29829, 29824, 29825, 29826, 29823, 29820, 29821, 29819, 29801, 29777, 29776, 29572, 29478, 29466, 29465, 29464, 29462, 29463, 29420, 29349, 29319, 29251, 29249, 29225, 29000, 28936, 28268, 28105, 28104, 28037, 27948, 27926, 27487, 27477, 27483, 27476, 27472, 27470, 27468, 26967, 26773, 26529, 26530, 26524, 26523, 26521, 26436, 26317, 26307, 25317, 25093, 44209, 24684, 23890, 23802, 23777, 23784, 23769, 23767, 23764, 23761, 23760, 23759, 23758, 23755, 23756, 23754, 23747, 23746, 23745, 23735, 23733, 23732, 23731, 23730, 23725, 23723, 23722, 23535, 23528, 50189, 50593)) ORDER BY FIELD(`e`.`entity_id`, 48641, 48640, 48639, 45534, 45532, 45509, 44665, 44553, 44515, 44467, 44466, 44450, 44189, 44061, 44057, 44046, 44045, 44044, 44042, 43441, 43020, 43018, 42884, 39386, 39385, 39149, 39148, 39142, 39082, 39059, 33869, 33868, 33789, 32943, 32270, 29828, 23769, 50593, 50585, 50584, 50583, 50560, 50515, 50494, 50442, 50424, 50394, 50298, 50297, 50296, 50295, 50294, 50293, 50292, 50291, 50290, 50289, 50288, 50287, 50286, 50274, 50273, 50198, 50189, 50039, 50038, 49966, 49961, 49949, 49821, 49818, 49801, 49800, 49799, 49798, 49797, 49796, 49783, 49782, 49727, 49715, 49705, 49704, 49702, 49700, 49681, 49643, 49641, 49640, 49611, 49610, 49609, 49607, 49583, 49542, 49541, 49510, 49509, 49508, 49507, 49506, 49504, 49503, 49489, 49374, 49359, 49324, 49303, 49146, 49145, 49144, 49143, 49142, 49141, 49140, 49139, 49138, 49137, 49110, 49109, 49108, 49100, 49095, 49094, 49093, 49092, 49089, 49088, 49086, 49085, 49084, 49019, 49018, 49017, 49010, 49009, 49008, 49007, 48989, 48987, 48986, 48985, 48984, 48983, 48981, 48980, 48979, 48978, 48977, 48976, 48975, 48969, 48914, 48893, 48878, 48845, 48815, 48765, 48701, 48700, 48698, 48697, 48696, 48695, 48694, 48693, 48681, 48680, 48663, 48662, 48659, 48656, 48655, 48654, 48653, 48638, 48632, 48631, 48630, 48629, 48627, 48626, 48625, 48624, 48623, 48578, 48577, 48576, 48569, 45586, 45557, 45556, 45555, 45554, 45553, 45552, 45551, 45550, 45549, 45537, 45527, 45526, 45520, 45511, 45510, 45504, 45503, 45502, 45413, 45386, 45354, 45298, 45297, 45296, 45044, 44901, 44900, 44803, 44801, 44755, 44753, 44752, 44748, 44746, 44742, 44741, 44740, 44739, 44738, 44735, 44734, 44733, 44732, 44731, 44726, 44524, 44508, 44506, 44489, 44488, 44487, 44486, 44464, 44462, 44447, 44440, 44439, 44438, 44437, 44436, 44433, 44422, 44421, 44388, 44376, 44374, 44373, 44323, 44296, 44209, 44208, 44207, 44206, 44205, 44200, 44181, 44180, 44179, 44126, 44106, 44105, 44104, 44103, 44102, 44095, 44089, 44068, 44067, 44066, 44065, 44064, 44063, 44062, 44060, 44059, 44058, 44056, 44055, 44043, 44040, 44034, 44033, 44032, 44031, 44012, 43797, 43765, 43746, 43718, 43717, 43555, 43515, 43502, 43492, 43491, 43490, 43489, 43488, 43487, 43440, 43433, 43418, 43351, 43350, 43349, 43348, 43347, 43345, 43343, 43342, 43341, 43339, 43338, 43337, 43336, 43335, 43333, 43324, 43319, 43318, 43241, 43240, 43154, 43125, 43078, 43051, 43019, 42981, 42980, 42979, 42887, 42881, 42877, 42876, 39999, 39836, 39824, 39807, 39796, 39792, 39534, 39493, 39492, 39485, 39468, 39467, 39466, 39465, 39454, 39452, 39439, 39434, 39433, 39423, 39387, 39384, 39368, 39367, 39366, 39348, 39337, 39335, 39334, 39332, 39263, 39256, 39254, 39247, 39214, 39200, 39159, 39158, 39157, 39154, 39153, 39147, 39146, 39145, 39144, 39143, 39141, 39140, 39139, 39138, 39137, 39136, 39135, 39134, 39084, 39083, 39081, 39080, 39058, 39057, 39051, 39049, 39048, 39037, 39032, 39031, 39018, 38966, 38867, 38864, 38806, 38805, 38804, 38694, 38693, 38671, 38645, 38642, 38613, 38610, 38608, 38597, 38596, 38595, 38577, 38576, 38575, 38574, 38517, 38502, 38499, 37816, 37707, 37694, 37551, 37465, 37452, 37187, 37185, 37183, 37168, 37157, 37100, 37099, 37097, 37086, 37078, 37076, 36676, 36627, 36141, 35247, 34883, 34631, 34630, 34370, 34369, 34155, 34115, 33917, 33881, 33880, 33879, 33878, 33877, 33872, 33871, 33870, 33867, 33866, 33865, 33864, 33863, 33858, 33831, 33828, 33826, 33808, 33656, 33606, 33605, 33571, 33455, 33030, 32953, 32952, 32950, 32948, 32947, 32946, 32936, 32935, 32908, 32847, 32845, 32822, 32797, 32775, 32773, 32757, 32737, 32733, 32721, 32690, 32689, 32688, 32639, 32638, 32634, 32588, 32586, 32516, 32466, 32369, 32348, 32344, 32321, 32320, 32314, 32312, 32286, 32283, 32120, 32091, 32073, 32072, 32071, 32070, 32040, 31977, 31938, 31825, 31792, 31789, 31788, 31787, 31739, 31722, 31535, 31486, 31383, 31303, 31176, 31158, 31152, 31149, 31148, 31147, 31106, 30786, 30683, 30598, 30589, 30414, 30367, 30344, 30307, 30122, 29994, 29991, 29974, 29943, 29862, 29861, 29852, 29840, 29839, 29838, 29836, 29835, 29834, 29833, 29832, 29831, 29830, 29829, 29826, 29825, 29824, 29823, 29821, 29820, 29819, 29801, 29777, 29776, 29704, 29608, 29607, 29572, 29478, 29466, 29465, 29464, 29463, 29462, 29420, 29349, 29319, 29251, 29249, 29225, 29000, 28936, 28268, 28105, 28104, 28037, 27948, 27926, 27487, 27483, 27477, 27476, 27472, 27470, 27468, 26967, 26773, 26645, 26530, 26529, 26524, 26523, 26521, 26436, 26317, 26307, 26054, 25855, 25830, 25826, 25825, 25317, 25093, 24684, 23890, 23802, 23784, 23777, 23767, 23764, 23761, 23760, 23759, 23758, 23756, 23755, 23754, 23747, 23746, 23745, 23735, 23733, 23732, 23731, 23730, 23725, 23723, 23722, 23535, 23528, 23427, 23426, 23343, 23280, 43016, 33665, 31964, 31778) ASC LIMIT 48