Array ( [0] => 84 [1] => 52 [2] => 190 [3] => 21 [4] => 46511 [5] => 46512 [6] => 46513 [7] => 46514 [8] => 34017 [9] => 141 [10] => 25268 [11] => 145 [12] => 1600 [13] => 25267 [14] => 128 [15] => 34015 [16] => 130 [17] => 38096 [18] => 88 [19] => 146 [20] => 59 [21] => 63 [22] => 103 [23] => 34038 [24] => 39 [25] => 25289 [26] => 695 [27] => 25273 [28] => 22663 [29] => 16 [30] => 22513 [31] => 10 [32] => 154 [33] => 38132 [34] => 38105 [35] => 25280 [36] => 147 [37] => 202 [38] => 104 [39] => 131 [40] => 22669 [41] => 77 [42] => 34023 [43] => 189 [44] => 22655 [45] => 38133 [46] => 61 [47] => 42334 [48] => 34030 [49] => 151 [50] => 118 [51] => 22673 [52] => 252 [53] => 13 [54] => 42306 [55] => 38106 [56] => 34007 [57] => 38116 [58] => 123 [59] => 25293 [60] => 129 [61] => 25357 [62] => 34005 [63] => 38114 [64] => 149 [65] => 229 [66] => 11 [67] => 142 [68] => 25269 [69] => 1606 [70] => 38119 [71] => 22667 [72] => 83 [73] => 38130 [74] => 38111 [75] => 60 [76] => 38120 [77] => 196 [78] => 38101 [79] => 98 [80] => 22660 [81] => 34036 [82] => 1596 [83] => 34021 [84] => 38100 [85] => 314 [86] => 22656 [87] => 222 [88] => 201 [89] => 25272 [90] => 253 [91] => 1602 [92] => 22760 [93] => 38122 [94] => 38124 [95] => 34042 [96] => 37527 [97] => 38098 [98] => 683 [99] => 34033 [100] => 42302 [101] => 38113 [102] => 34006 [103] => 38115 [104] => 25284 [105] => 42329 [106] => 25261 [107] => 150 [108] => 1588 [109] => 195 [110] => 197 [111] => 38131 [112] => 143 [113] => 688 [114] => 34004 [115] => 702 [116] => 32 [117] => 38142 [118] => 206 [119] => 221 [120] => 22666 [121] => 42309 [122] => 46544 [123] => 46518 [124] => 25287 [125] => 42301 [126] => 38104 [127] => 46543 [128] => 42316 [129] => 42335 [130] => 42313 [131] => 42315 [132] => 42304 [133] => 46541 [134] => 42324 [135] => 42305 [136] => 38109 [137] => 42300 [138] => 42312 [139] => 42337 [140] => 46542 [141] => 24415 [142] => 34026 [143] => 42332 [144] => 25286 [145] => 42311 [146] => 34025 [147] => 287 [148] => 46519 [149] => 90 [150] => 34024 [151] => 42090 [152] => 38103 [153] => 42328 [154] => 46520 [155] => 46521 [156] => 42287 [157] => 41240 [158] => 74 [159] => 42089 [160] => 42289 [161] => 175 [162] => 42295 [163] => 38097 [164] => 46522 [165] => 43771 [166] => 43772 [167] => 43773 [168] => 45856 [169] => 45858 [170] => 45859 [171] => 35671 [172] => 42297 [173] => 28263 [174] => 34051 [175] => 42293 [176] => 46515 [177] => 46517 [178] => 46528 [179] => 43770 [180] => 45854 [181] => 45855 [182] => 42344 [183] => 42318 [184] => 42333 [185] => 1640 [186] => 82 [187] => 25282 [188] => 42340 [189] => 22661 [190] => 25260 [191] => 203 [192] => 38134 [193] => 42286 [194] => 42341 [195] => 41265 [196] => 42292 [197] => 22674 [198] => 132 [199] => 42088 [200] => 42298 [201] => 42322 [202] => 33997 [203] => 42338 [204] => 46523 [205] => 46529 [206] => 46619 [207] => 46547 [208] => 45857 [209] => 38095 [210] => 38117 [211] => 670 [212] => 38123 [213] => 41248 [214] => 34 [215] => 24420 [216] => 25288 [217] => 38118 [218] => 42290 [219] => 34001 [220] => 25668 [221] => 42296 [222] => 1647 [223] => 42308 [224] => 42327 [225] => 42920 [226] => 42320 [227] => 34010 [228] => 34029 [229] => 22665 [230] => 34022 [231] => 166 [232] => 38121 [233] => 42288 [234] => 42343 [235] => 42299 [236] => 46516 [237] => 46546 [238] => 38137 [239] => 42323 [240] => 704 [241] => 42339 [242] => 25363 [243] => 34016 [244] => 34047 [245] => 38138 [246] => 42345 [247] => 42319 [248] => 34048 [249] => 41264 [250] => 34002 [251] => 34049 [252] => 38129 [253] => 38135 [254] => 42321 [255] => 42342 [256] => 34012 [257] => 34044 [258] => 42310 [259] => 42317 [260] => 169 [261] => 34045 [262] => 42294 [263] => 46540 [264] => 46531 [265] => 46536 [266] => 46534 [267] => 46535 [268] => 46537 [269] => 33998 [270] => 34689 [271] => 43594 [272] => 12 [273] => 42285 [274] => 43595 [275] => 36 [276] => 42291 [277] => 35679 [278] => 26626 [279] => 43596 [280] => 39259 [281] => 43587 [282] => 34003 [283] => 36482 [284] => 69 [285] => 43597 [286] => 53 [287] => 25263 [288] => 43592 [289] => 30 [290] => 25276 [291] => 34053 [292] => 25362 [293] => 41246 [294] => 43593 [295] => 46532 [296] => 46525 [297] => 46526 [298] => 46549 [299] => 25285 [300] => 42303 [301] => 46524 [302] => 46533 [303] => 38136 [304] => 46527 [305] => 46545 [306] => 46548 [307] => 46550 [308] => 46539 ) Desde: 0 Hasta: 24

SELECT DISTINCT ps_product.reference, ps_product.id_supplier, ps_product.id_product, ps_product_lang.name, ps_product_lang.link_rewrite, round(pps.price*1.21,2) as precio_sin_descuento, ps_product.ean13, IFNULL(ppad.id_product,0) AS esta_en_avisame FROM ps_product_lang JOIN ps_product ON (ps_product_lang.id_product=ps_product.id_product) JOIN ps_manufacturer ON (ps_product.id_manufacturer=ps_manufacturer.id_manufacturer) LEFT JOIN ps_category ON (ps_category.id_category=ps_product.id_category_default) LEFT JOIN ps_category_product ON (ps_product.id_product = ps_category_product.id_product) LEFT JOIN ps_specific_price psp ON (psp.id_product = ps_product.id_product) JOIN ps_product_shop pps ON (pps.id_product=ps_product.id_product)LEFT JOIN ps_productos_en_avisame_disp ppad ON (pps.id_product = ppad.id_product) WHERE pps.visibility IN ('both', 'catalog') AND (pps.price*1.21>=0 AND pps.price*1.21<=1000) AND ps_product.id_product NOT IN (0) AND ps_product.id_product NOT IN (26223, 26222) AND pps.price!=0 and ps_product_lang.id_lang=2 AND pps.active=1 AND ps_manufacturer.id_manufacturer=10 AND ps_product.id_product IN (84,52,190,21,46511,46512,46513,46514,34017,141,25268,145,1600,25267,128,34015,130,38096,88,146,59,63,103,34038) GROUP BY ps_product.id_product ORDER BY FIELD( ps_product.id_product, 84,52,190,21,46511,46512,46513,46514,34017,141,25268,145,1600,25267,128,34015,130,38096,88,146,59,63,103,34038)