ANELLI O-RING

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`codicesaptecnica`, `e`.`costruttoredrop`, `e`.`costruttoredrop_value`, `e`.`codiceoriginale`, `e`.`isooforigin`, `e`.`specweightnetmass`, `e`.`diametro_interno`, `e`.`diametro_interno_value`, `e`.`diametro_esterno`, `e`.`diametro_esterno_value`, `e`.`spessore`, `e`.`spessore_value`, `e`.`codice_internazionale`, `e`.`dimensione_a`, `e`.`dimensione_a_value`, `e`.`dimensione_b`, `e`.`dimensione_b_value`, `e`.`dimensione_r`, `e`.`dimensione_r_value`, `e`.`dimensione_foro`, `e`.`dimensione_foro_value`, `e`.`sconto_articolo`, `e`.`dimensione_esterna`, `e`.`dimensione_esterna_value`, `e`.`dimensione_interna`, `e`.`dimensione_interna_value`, `e`.`dettaglio_1`, `e`.`dettaglio_1_value`, `e`.`dettaglio_2`, `e`.`dettaglio_2_value`, `e`.`dettaglio_3`, `e`.`dettaglio_3_value`, `e`.`materiale`, `e`.`materiale_value`, `e`.`numero_denti`, `e`.`numero_denti_value`, `e`.`dimensione_esterna_freno`, `e`.`dimensione_esterna_freno_value`, `e`.`dimensione_interna_freno`, `e`.`dimensione_interna_freno_value`, `e`.`spessore_freno`, `e`.`spessore_freno_value`, `e`.`numero_denti_freno`, `e`.`numero_denti_freno_value`, `e`.`tipo`, `e`.`tipo_value`, `e`.`dimensione_c`, `e`.`dimensione_c_value`, `e`.`codice_iso_cuscinetti`, `e`.`codice_iso_cuscinetti_value`, `e`.`data_consegna`, `e`.`articoli_sostitutivi`, `e`.`diametro_esterno_2`, `e`.`diametro_esterno_2_value`, `e`.`altezza`, `e`.`altezza_value`, `e`.`altezza_2`, `e`.`altezza_2_value`, `e`.`famiglia_prodotto`, `e`.`famiglia_prodotto_value`, `e`.`descrizione_estesa`, `e`.`mescola`, `e`.`mescola_value`, `e`.`availability`, `e`.`availability_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`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`codicesaptecnica`, `e`.`costruttoredrop`, `e`.`costruttoredrop_value`, `e`.`codiceoriginale`, `e`.`isooforigin`, `e`.`specweightnetmass`, `e`.`diametro_interno`, `e`.`diametro_interno_value`, `e`.`diametro_esterno`, `e`.`diametro_esterno_value`, `e`.`spessore`, `e`.`spessore_value`, `e`.`codice_internazionale`, `e`.`dimensione_a`, `e`.`dimensione_a_value`, `e`.`dimensione_b`, `e`.`dimensione_b_value`, `e`.`dimensione_r`, `e`.`dimensione_r_value`, `e`.`dimensione_foro`, `e`.`dimensione_foro_value`, `e`.`sconto_articolo`, `e`.`dimensione_esterna`, `e`.`dimensione_esterna_value`, `e`.`dimensione_interna`, `e`.`dimensione_interna_value`, `e`.`dettaglio_1`, `e`.`dettaglio_1_value`, `e`.`dettaglio_2`, `e`.`dettaglio_2_value`, `e`.`dettaglio_3`, `e`.`dettaglio_3_value`, `e`.`materiale`, `e`.`materiale_value`, `e`.`numero_denti`, `e`.`numero_denti_value`, `e`.`dimensione_esterna_freno`, `e`.`dimensione_esterna_freno_value`, `e`.`dimensione_interna_freno`, `e`.`dimensione_interna_freno_value`, `e`.`spessore_freno`, `e`.`spessore_freno_value`, `e`.`numero_denti_freno`, `e`.`numero_denti_freno_value`, `e`.`tipo`, `e`.`tipo_value`, `e`.`dimensione_c`, `e`.`dimensione_c_value`, `e`.`codice_iso_cuscinetti`, `e`.`codice_iso_cuscinetti_value`, `e`.`data_consegna`, `e`.`articoli_sostitutivi`, `e`.`diametro_esterno_2`, `e`.`diametro_esterno_2_value`, `e`.`altezza`, `e`.`altezza_value`, `e`.`altezza_2`, `e`.`altezza_2_value`, `e`.`famiglia_prodotto`, `e`.`famiglia_prodotto_value`, `e`.`descrizione_estesa`, `e`.`mescola`, `e`.`mescola_value`, `e`.`availability`, `e`.`availability_value`, `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.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((((`e`.`costruttoredrop` = 'costruttoredrop') OR (`e`.`costruttoredrop` = '29')))) AND (e.entity_id IN (1440961, 1440962, 1440963, 1440990, 1441000, 1441005, 1441008, 1441010, 1441012, 1441016, 1441098, 1441109, 1441110, 1441112, 1441114, 1441115, 1441116, 1441117, 1441118, 1441129, 1441130, 1441144, 1441233, 1441234, 1441235, 1441236, 1439913, 1439914, 1439916, 1439917, 1439950, 1439951, 1439952, 1439954, 1439955, 1439956, 1439958, 1439959, 1439965, 1439989, 1439992, 1440012, 1440013, 1440014, 1440015, 1440016, 1440017, 1440020, 1440021, 1440022, 1440023, 1440028, 1440029, 1440031, 1440032, 1440034, 1440036, 1440037, 1440038, 1440050, 1440091, 1440093, 1440095, 1440096, 1440107, 1440162, 1440329, 1440330, 1440345, 1440351, 1440352, 1440353, 1440354, 1440356, 1440359, 1440360, 1440371, 1440402, 1440426, 1440428, 1440429, 1440430, 1440440, 1440447, 1440448, 1440451, 1440467, 1440475, 1440491, 1440494, 1440495, 1440512, 1440513, 1440514, 1440515, 1440516, 1440529, 1440532, 1440533, 1440534, 1440536, 1440539, 1440541, 1440542, 1440543, 1440545, 1440546, 1440641, 1440642, 1440661, 1440662, 1440813, 1440814, 1440817, 1440819, 1440820, 1440821, 1440823, 1440824, 1440826, 1440828, 1440829, 1440830, 1440831, 1440832, 1440836, 1440839, 1440841, 1440842, 1440843, 1440845, 1440860, 1440861, 1440862, 1440863, 1440864, 1440865, 1440866, 1440868, 1440870, 1440871, 1440872, 1440873, 1440874, 1440875, 1440876, 1440877, 1440878, 1440879, 1440880, 1440882, 1440891, 1440894, 1440896, 1440898, 1440901, 1440902, 1440903, 1440905, 1440906, 1440907, 1440908, 1439909, 1439910, 1439912, 1441002, 1441003, 1441004, 1441006, 1441007, 1441009, 1441011, 1441013, 1441014, 1441015, 1441097, 1441111, 1441141, 1441237, 1439941, 1439947, 1439948, 1439957, 1439967, 1439968, 1439984, 1439988, 1439990, 1439991, 1439993, 1439995, 1439996, 1439997, 1439998, 1439999, 1440000, 1440018, 1440019, 1440024, 1440025, 1440026, 1440027, 1440030, 1440033, 1440035, 1440042, 1440049, 1440052, 1440094, 1440109, 1440110, 1440111, 1440119, 1440152, 1440153, 1440154, 1440155, 1440156, 1440157, 1440158, 1440159, 1440160, 1440161, 1440164, 1440165, 1440166, 1440171, 1440173, 1440317, 1440318, 1440320, 1440321, 1440323, 1440324, 1440325, 1440326, 1440328, 1440333, 1440334, 1440335, 1440336, 1440337, 1440338, 1440341, 1440342, 1440361, 1440422, 1440423, 1440427, 1440439, 1440450, 1440452, 1440468, 1440479, 1440490, 1440492, 1440511, 1440522, 1440525, 1440530, 1440535, 1440540, 1440544, 1440550, 1440639, 1440649, 1440655, 1440663, 1440664, 1440666, 1440815, 1440816, 1440818, 1440822, 1440825, 1440827, 1440833, 1440834, 1440835, 1440838, 1440844, 1440851, 1440854, 1440859, 1440867, 1440869, 1440881, 1440897, 1440899, 1440900, 1440904, 1439911, 1440960, 1441001, 1439915, 1439942, 1439943, 1439944, 1439945, 1439946, 1439949, 1439953, 1439977, 1439983, 1439985, 1439986, 1439994, 1440001, 1440002, 1440003, 1440004, 1440005, 1440006, 1440007, 1440008, 1440009, 1440010, 1440011, 1440040, 1440041, 1440047, 1440048, 1440051, 1440055, 1440092, 1440098, 1440099, 1440100, 1440101, 1440102, 1440106, 1440108, 1440112, 1440113, 1440114, 1440115, 1440116, 1440117, 1440118, 1440122, 1440125, 1440163, 1440167, 1440168, 1440169, 1440170, 1440172, 1440174, 1440177, 1440178, 1440179, 1440180, 1440188, 1440314, 1440315, 1440316, 1440319, 1440322, 1440327, 1440331, 1440332, 1440339, 1440340, 1440343, 1440344, 1440346, 1440347, 1440348, 1440349, 1440350, 1440355, 1440380, 1440381, 1440417, 1440425, 1440437, 1440477, 1440478, 1440480, 1440481, 1440482, 1440483, 1440484, 1440485, 1440486, 1440488, 1440489, 1440493, 1440496, 1440497, 1440523, 1440524, 1440526, 1440527, 1440528, 1440531, 1440537, 1440538, 1440626, 1440627, 1440629, 1440636, 1440637, 1440638, 1440640, 1440643, 1440645, 1440646, 1440647, 1440648, 1440650, 1440651, 1440652, 1440653, 1440654, 1440656, 1440657, 1440658, 1440665, 1440722, 1440837, 1440840, 1440846, 1440847, 1440848, 1440849, 1440852, 1440853, 1440855, 1440856, 1440857, 1440858, 1440909, 1440910)) ORDER BY FIELD(e.entity_id,1440961,1440962,1440963,1440990,1441000,1441005,1441008,1441010,1441012,1441016,1441098,1441109,1441110,1441112,1441114,1441115,1441116,1441117,1441118,1441129,1441130,1441144,1441233,1441234,1441235,1441236,1439913,1439914,1439916,1439917,1439950,1439951,1439952,1439954,1439955,1439956,1439958,1439959,1439965,1439989,1439992,1440012,1440013,1440014,1440015,1440016,1440017,1440020,1440021,1440022,1440023,1440028,1440029,1440031,1440032,1440034,1440036,1440037,1440038,1440050,1440091,1440093,1440095,1440096,1440107,1440162,1440329,1440330,1440345,1440351,1440352,1440353,1440354,1440356,1440359,1440360,1440371,1440402,1440426,1440428,1440429,1440430,1440440,1440447,1440448,1440451,1440467,1440475,1440491,1440494,1440495,1440512,1440513,1440514,1440515,1440516,1440529,1440532,1440533,1440534,1440536,1440539,1440541,1440542,1440543,1440545,1440546,1440641,1440642,1440661,1440662,1440813,1440814,1440817,1440819,1440820,1440821,1440823,1440824,1440826,1440828,1440829,1440830,1440831,1440832,1440836,1440839,1440841,1440842,1440843,1440845,1440860,1440861,1440862,1440863,1440864,1440865,1440866,1440868,1440870,1440871,1440872,1440873,1440874,1440875,1440876,1440877,1440878,1440879,1440880,1440882,1440891,1440894,1440896,1440898,1440901,1440902,1440903,1440905,1440906,1440907,1440908,1439909,1439910,1439912,1441002,1441003,1441004,1441006,1441007,1441009,1441011,1441013,1441014,1441015,1441097,1441111,1441141,1441237,1439941,1439947,1439948,1439957,1439967,1439968,1439984,1439988,1439990,1439991,1439993,1439995,1439996,1439997,1439998,1439999,1440000,1440018,1440019,1440024,1440025,1440026,1440027,1440030,1440033,1440035,1440042,1440049,1440052,1440094,1440109,1440110,1440111,1440119,1440152,1440153,1440154,1440155,1440156,1440157,1440158,1440159,1440160,1440161,1440164,1440165,1440166,1440171,1440173,1440317,1440318,1440320,1440321,1440323,1440324,1440325,1440326,1440328,1440333,1440334,1440335,1440336,1440337,1440338,1440341,1440342,1440361,1440422,1440423,1440427,1440439,1440450,1440452,1440468,1440479,1440490,1440492,1440511,1440522,1440525,1440530,1440535,1440540,1440544,1440550,1440639,1440649,1440655,1440663,1440664,1440666,1440815,1440816,1440818,1440822,1440825,1440827,1440833,1440834,1440835,1440838,1440844,1440851,1440854,1440859,1440867,1440869,1440881,1440897,1440899,1440900,1440904,1439911,1440960,1441001,1439915,1439942,1439943,1439944,1439945,1439946,1439949,1439953,1439977,1439983,1439985,1439986,1439994,1440001,1440002,1440003,1440004,1440005,1440006,1440007,1440008,1440009,1440010,1440011,1440040,1440041,1440047,1440048,1440051,1440055,1440092,1440098,1440099,1440100,1440101,1440102,1440106,1440108,1440112,1440113,1440114,1440115,1440116,1440117,1440118,1440122,1440125,1440163,1440167,1440168,1440169,1440170,1440172,1440174,1440177,1440178,1440179,1440180,1440188,1440314,1440315,1440316,1440319,1440322,1440327,1440331,1440332,1440339,1440340,1440343,1440344,1440346,1440347,1440348,1440349,1440350,1440355,1440380,1440381,1440417,1440425,1440437,1440477,1440478,1440480,1440481,1440482,1440483,1440484,1440485,1440486,1440488,1440489,1440493,1440496,1440497,1440523,1440524,1440526,1440527,1440528,1440531,1440537,1440538,1440626,1440627,1440629,1440636,1440637,1440638,1440640,1440643,1440645,1440646,1440647,1440648,1440650,1440651,1440652,1440653,1440654,1440656,1440657,1440658,1440665,1440722,1440837,1440840,1440846,1440847,1440848,1440849,1440852,1440853,1440855,1440856,1440857,1440858,1440909,1440910) LIMIT 5