Array ( [0] => 84 [1] => 190 [2] => 52 [3] => 21 [4] => 44395 [5] => 44394 [6] => 128 [7] => 42312 [8] => 34017 [9] => 24408 [10] => 141 [11] => 25267 [12] => 1600 [13] => 145 [14] => 34015 [15] => 25268 [16] => 130 [17] => 88 [18] => 146 [19] => 34038 [20] => 25289 [21] => 22663 [22] => 38127 [23] => 25273 [24] => 63 [25] => 38132 [26] => 25359 [27] => 202 [28] => 147 [29] => 38105 [30] => 39 [31] => 104 [32] => 131 [33] => 25275 [34] => 38140 [35] => 38099 [36] => 38133 [37] => 22669 [38] => 34023 [39] => 22655 [40] => 34018 [41] => 61 [42] => 189 [43] => 38102 [44] => 695 [45] => 34030 [46] => 118 [47] => 151 [48] => 13 [49] => 38106 [50] => 38116 [51] => 34007 [52] => 25280 [53] => 25293 [54] => 25269 [55] => 38114 [56] => 129 [57] => 38111 [58] => 142 [59] => 34005 [60] => 38096 [61] => 123 [62] => 25357 [63] => 83 [64] => 149 [65] => 1606 [66] => 22760 [67] => 38130 [68] => 38120 [69] => 34039 [70] => 1602 [71] => 16 [72] => 38101 [73] => 22667 [74] => 34032 [75] => 25281 [76] => 38119 [77] => 38100 [78] => 38122 [79] => 34042 [80] => 34036 [81] => 314 [82] => 24430 [83] => 98 [84] => 22660 [85] => 25272 [86] => 34011 [87] => 38108 [88] => 38124 [89] => 253 [90] => 1596 [91] => 38098 [92] => 11 [93] => 683 [94] => 25264 [95] => 22656 [96] => 42302 [97] => 38115 [98] => 38113 [99] => 34006 [100] => 25261 [101] => 34027 [102] => 34004 [103] => 25284 [104] => 38131 [105] => 150 [106] => 1588 [107] => 702 [108] => 22666 [109] => 38142 [110] => 32 [111] => 91 [112] => 197 [113] => 206 [114] => 143 [115] => 221 [116] => 195 [117] => 688 [118] => 42306 [119] => 42301 [120] => 42334 [121] => 38104 [122] => 25287 [123] => 42316 [124] => 287 [125] => 42304 [126] => 42313 [127] => 42305 [128] => 42300 [129] => 42315 [130] => 38109 [131] => 34026 [132] => 42324 [133] => 42337 [134] => 42332 [135] => 34025 [136] => 1647 [137] => 25286 [138] => 42335 [139] => 90 [140] => 41240 [141] => 34024 [142] => 42299 [143] => 34010 [144] => 34033 [145] => 43773 [146] => 34020 [147] => 42311 [148] => 42286 [149] => 42089 [150] => 24415 [151] => 34689 [152] => 42090 [153] => 42336 [154] => 38103 [155] => 138 [156] => 43771 [157] => 25288 [158] => 43772 [159] => 42329 [160] => 132 [161] => 24422 [162] => 34022 [163] => 38134 [164] => 38097 [165] => 38136 [166] => 42297 [167] => 42310 [168] => 670 [169] => 74 [170] => 28263 [171] => 35671 [172] => 43580 [173] => 24420 [174] => 33996 [175] => 34051 [176] => 34044 [177] => 42292 [178] => 38095 [179] => 38117 [180] => 42320 [181] => 42341 [182] => 38112 [183] => 34 [184] => 42327 [185] => 34002 [186] => 38118 [187] => 42342 [188] => 82 [189] => 42295 [190] => 42290 [191] => 42343 [192] => 38125 [193] => 25285 [194] => 41265 [195] => 38126 [196] => 42333 [197] => 22665 [198] => 38138 [199] => 42303 [200] => 42088 [201] => 42340 [202] => 43770 [203] => 704 [204] => 42920 [205] => 34001 [206] => 34047 [207] => 38123 [208] => 43579 [209] => 34048 [210] => 38135 [211] => 42321 [212] => 41248 [213] => 12 [214] => 42285 [215] => 42322 [216] => 41264 [217] => 22674 [218] => 25363 [219] => 42291 [220] => 42308 [221] => 166 [222] => 42323 [223] => 42344 [224] => 42317 [225] => 34029 [226] => 34052 [227] => 42298 [228] => 42318 [229] => 69 [230] => 25668 [231] => 34016 [232] => 42293 [233] => 34053 [234] => 38139 [235] => 42288 [236] => 25260 [237] => 26626 [238] => 34041 [239] => 38129 [240] => 41243 [241] => 42294 [242] => 915 [243] => 38107 [244] => 42289 [245] => 1640 [246] => 24417 [247] => 25362 [248] => 38141 [249] => 22661 [250] => 25263 [251] => 34049 [252] => 34043 [253] => 42296 [254] => 34012 [255] => 35679 [256] => 43582 [257] => 38137 [258] => 22512 [259] => 33997 [260] => 42339 [261] => 25667 [262] => 36482 [263] => 38110 [264] => 39259 [265] => 169 [266] => 25294 [267] => 38121 [268] => 42287 [269] => 42345 [270] => 34000 [271] => 34046 [272] => 203 [273] => 25276 [274] => 175 [275] => 42325 [276] => 43594 [277] => 43595 [278] => 43596 [279] => 43597 [280] => 43592 [281] => 43593 [282] => 201 [283] => 18348 [284] => 22918 [285] => 25330 [286] => 25534 [287] => 26627 [288] => 27438 [289] => 34471 [290] => 35676 [291] => 37533 [292] => 38024 [293] => 38924 [294] => 39262 [295] => 41263 [296] => 18798 [297] => 22919 [298] => 25333 [299] => 25535 [300] => 26628 [301] => 28261 [302] => 34472 [303] => 35677 [304] => 37534 [305] => 38722 [306] => 38925 [307] => 39263 [308] => 41266 [309] => 18799 [310] => 22920 [311] => 25334 [312] => 25556 [313] => 26629 [314] => 28262 [315] => 34473 [316] => 35678 [317] => 37535 [318] => 38723 [319] => 38926 [320] => 39264 [321] => 41267 [322] => 1059 [323] => 18800 [324] => 22921 [325] => 25335 [326] => 25557 [327] => 26630 [328] => 28265 [329] => 34474 [330] => 36476 [331] => 37536 [332] => 38724 [333] => 38927 [334] => 39265 [335] => 41268 [336] => 1060 [337] => 18801 [338] => 23006 [339] => 25337 [340] => 25558 [341] => 26631 [342] => 28266 [343] => 34475 [344] => 36477 [345] => 38012 [346] => 38725 [347] => 38928 [348] => 39266 [349] => 41269 [350] => 1061 [351] => 18803 [352] => 23008 [353] => 25339 [354] => 25559 [355] => 26632 [356] => 28267 [357] => 34476 [358] => 36479 [359] => 38013 [360] => 38726 [361] => 39116 [362] => 39267 [363] => 41270 [364] => 1062 [365] => 18804 [366] => 23009 [367] => 25341 [368] => 25560 [369] => 27428 [370] => 28268 [371] => 34690 [372] => 36480 [373] => 38014 [374] => 38727 [375] => 39117 [376] => 39268 [377] => 42309 [378] => 1063 [379] => 22456 [380] => 24393 [381] => 25342 [382] => 25561 [383] => 27429 [384] => 28269 [385] => 34691 [386] => 36481 [387] => 38015 [388] => 38728 [389] => 39118 [390] => 41241 [391] => 42319 [392] => 1064 [393] => 22458 [394] => 24451 [395] => 25343 [396] => 25662 [397] => 27430 [398] => 34693 [399] => 36483 [400] => 38016 [401] => 38729 [402] => 39119 [403] => 41242 [404] => 1065 [405] => 22459 [406] => 24452 [407] => 25344 [408] => 25663 [409] => 27431 [410] => 34695 [411] => 36484 [412] => 38017 [413] => 38730 [414] => 39120 [415] => 41244 [416] => 42338 [417] => 1745 [418] => 22460 [419] => 24453 [420] => 25377 [421] => 25664 [422] => 27432 [423] => 34021 [424] => 34696 [425] => 37527 [426] => 38018 [427] => 38731 [428] => 39121 [429] => 41245 [430] => 43587 [431] => 10 [432] => 18342 [433] => 22461 [434] => 25043 [435] => 25529 [436] => 25665 [437] => 27433 [438] => 34697 [439] => 37528 [440] => 38019 [441] => 38732 [442] => 39122 [443] => 41246 [444] => 43775 [445] => 18343 [446] => 22463 [447] => 25047 [448] => 25530 [449] => 25666 [450] => 27434 [451] => 34045 [452] => 35672 [453] => 37529 [454] => 38020 [455] => 38920 [456] => 39123 [457] => 41247 [458] => 43776 [459] => 18344 [460] => 22464 [461] => 25282 [462] => 25531 [463] => 26623 [464] => 27435 [465] => 34468 [466] => 35673 [467] => 37530 [468] => 38021 [469] => 38921 [470] => 39124 [471] => 41260 [472] => 18345 [473] => 25325 [474] => 25532 [475] => 26624 [476] => 27436 [477] => 34469 [478] => 35674 [479] => 37531 [480] => 38022 [481] => 38922 [482] => 39260 [483] => 41261 [484] => 18346 [485] => 22673 [486] => 25329 [487] => 25533 [488] => 26625 [489] => 27437 [490] => 34470 [491] => 35675 [492] => 37532 [493] => 38023 [494] => 38923 [495] => 39261 [496] => 41262 [497] => 222 [498] => 252 [499] => 42328 [500] => 34003 [501] => 34031 [502] => 60 [503] => 22513 [504] => 33998 [505] => 196 [506] => 77 [507] => 154 [508] => 30 [509] => 36 [510] => 53 [511] => 59 [512] => 103 [513] => 42326 ) 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,190,52,21,44395,44394,128,42312,34017,24408,141,25267,1600,145,34015,25268,130,88,146,34038,25289,22663,38127,25273) GROUP BY ps_product.id_product ORDER BY FIELD( ps_product.id_product, 84,190,52,21,44395,44394,128,42312,34017,24408,141,25267,1600,145,34015,25268,130,88,146,34038,25289,22663,38127,25273)