Array ( [0] => 46539 [1] => 46522 [2] => 46534 [3] => 190 [4] => 49314 [5] => 42321 [6] => 42322 [7] => 42323 [8] => 21 [9] => 34017 [10] => 141 [11] => 25268 [12] => 128 [13] => 38096 [14] => 130 [15] => 146 [16] => 59 [17] => 63 [18] => 103 [19] => 22663 [20] => 10 [21] => 25273 [22] => 154 [23] => 22513 [24] => 16 [25] => 25280 [26] => 202 [27] => 147 [28] => 22669 [29] => 61 [30] => 38133 [31] => 189 [32] => 38102 [33] => 77 [34] => 34030 [35] => 118 [36] => 22673 [37] => 151 [38] => 252 [39] => 42334 [40] => 38116 [41] => 42306 [42] => 123 [43] => 38130 [44] => 34036 [45] => 34021 [46] => 38114 [47] => 98 [48] => 253 [49] => 60 [50] => 22656 [51] => 22660 [52] => 22667 [53] => 25272 [54] => 222 [55] => 1596 [56] => 1606 [57] => 196 [58] => 38111 [59] => 38122 [60] => 38119 [61] => 229 [62] => 38124 [63] => 314 [64] => 11 [65] => 34019 [66] => 201 [67] => 34042 [68] => 25357 [69] => 38120 [70] => 1602 [71] => 34033 [72] => 143 [73] => 38115 [74] => 206 [75] => 22666 [76] => 688 [77] => 221 [78] => 42302 [79] => 195 [80] => 38131 [81] => 32 [82] => 42329 [83] => 702 [84] => 197 [85] => 25287 [86] => 38109 [87] => 34022 [88] => 69 [89] => 42301 [90] => 46518 [91] => 38103 [92] => 46543 [93] => 42324 [94] => 46513 [95] => 42300 [96] => 34003 [97] => 34053 [98] => 670 [99] => 42313 [100] => 34001 [101] => 34051 [102] => 25260 [103] => 34 [104] => 43772 [105] => 42333 [106] => 42337 [107] => 46512 [108] => 704 [109] => 25286 [110] => 46542 [111] => 12 [112] => 43773 [113] => 38134 [114] => 25270 [115] => 38095 [116] => 38129 [117] => 38121 [118] => 22661 [119] => 25263 [120] => 170 [121] => 34012 [122] => 34044 [123] => 43770 [124] => 43771 [125] => 46521 [126] => 25363 [127] => 42917 [128] => 43775 [129] => 42288 [130] => 38143 [131] => 42920 [132] => 38097 [133] => 42311 [134] => 38123 [135] => 46511 [136] => 43776 [137] => 34002 [138] => 38110 [139] => 203 [140] => 46519 [141] => 1640 [142] => 34037 [143] => 42090 [144] => 46520 [145] => 46525 [146] => 38137 [147] => 42340 [148] => 90 [149] => 42290 [150] => 41265 [151] => 1591 [152] => 38136 [153] => 24420 [154] => 42339 [155] => 46524 [156] => 46528 [157] => 46537 [158] => 42289 [159] => 132 [160] => 287 [161] => 34029 [162] => 38135 [163] => 46536 [164] => 46529 [165] => 46538 [166] => 24417 [167] => 42315 [168] => 42328 [169] => 22674 [170] => 22665 [171] => 42291 [172] => 228 [173] => 42327 [174] => 42338 [175] => 46532 [176] => 46531 [177] => 46514 [178] => 46515 [179] => 46516 [180] => 46517 [181] => 46523 [182] => 46533 [183] => 46535 [184] => 46547 [185] => 46530 [186] => 43593 [187] => 43594 [188] => 74 [189] => 38117 [190] => 43595 [191] => 22678 [192] => 42335 [193] => 43596 [194] => 42310 [195] => 42296 [196] => 82 [197] => 42286 [198] => 43597 [199] => 43592 [200] => 30 ) 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 (46539,46522,46534,190,49314,42321,42322,42323,21,34017,141,25268,128,38096,130,146,59,63,103,22663,10,25273,154,22513) GROUP BY ps_product.id_product ORDER BY FIELD( ps_product.id_product, 46539,46522,46534,190,49314,42321,42322,42323,21,34017,141,25268,128,38096,130,146,59,63,103,22663,10,25273,154,22513)