SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,4650,1840,9329,9328,8876,6599,1844,8877,9135,7161,9174,9136,9111,8815,9121,9034,9068,8918,5366,4654,5091,1839,7832,4653,5322,5427,6850,5135,2356,9130,9220,9139,9113,2107,7874,8491,8523,8929,9011,9006,9091,9112,9115,5316,5354,9398,6157,9267,7219,9322,9384,9094,6877,9110,8927,9277,8924,9403,9524,8915,5433,9342,9523,9522,9388,9021,9517,9511,8998,9510,7005,9509,5470,9507,9117,9505,9116,9504,9503,9494,9010,9109,9484,9479,9042,9478,9303,5315,9477,5321,8872,9450,9307,9448,9044,9425,6847,9424,8400,9063,9423,9179,9043,8859,9158,9382,9093,8439,9344,9108,9013,9334,9074,9327,7603,9316,9315,8435,9314,5440,8930,6604,8855,1814,9206,9205,8857,9204,9202,8971,1809,8405,6503,6602,8853,3827,5092,8890,8221,7569,1811,3191,8832,8914,8894,5111,7835,8775,8773,6610,5139,7833,4652,5987,8879,5134,7929,8849,6146,6945,8856,6612,8854,8751,8828,5408,6004,7484,7184,3777,6127,8518,8434,8875,7094,8745,5136,7006,5407,6596,5343,8860,6597,3789,8792,8020,7854,8327,5473,7549,5890,8848,6124,6502,7764,5875,8448,5140,7841,6171,5884,7667,8016,8365,8794,1812,7567,7157,5137,8366,8507,8789,5307,8570,6606,7110,8779,7928,6210,8392,8776,7473,8436,7946,5991,8719,7609,8725,7162,8747,5436,5426,5873,8774,7735,8017,8446,8324,8721,6846,8506,5989,7522,8746,5994,8325,7930,8144,8519,7935,4485,5465,5444,8744,4042,6611,8667,5434,8666,7628,4561,8521,8693,5899,5985,5656,8718,5306,7858,5435,6844,7160,8624,6000,5898,8708,5439,5443,5438,5437,6598,8517,8363,7705,8501,5409,4491,8692,8143,8329,8690,6508,5969,6843,7523,8668,7612,7470,5967,8018,6609,8598,8278,3123,8019,6013,8665,8662,5966,8126,7593,6006,6837,8445,4834,8280,4036,6758,7158,7159,7637,2839,4041,4045,2838,2837,4043,7605,8407,8443,8502,4037,5896,6759,8663,6143,6001,6145,8661,7983,8652,8125,7536,6155,7210,7533,6140,8047,7485,3122,6020,3126,7571,3129,8094,6018,4562,7550,7307,3188,7289,6007,8074,7981,3124,7551,5997,7548,4563,7616,8010,8881,6633,8623,8831,7980,8277,8331,8871,8251,8797,8399,8252,7631,6878,7546,7595,7615,3788,7288,8403,7634,8330,6841,8075,7534,8313,6848,5303,7651,6845,7610,5965,5471,5301,5975,5976,5984,7630,5983,5982,7378,5468,8444,6139,7318,8072,8694,8279,8281,5968,6002,7636,6842,8404,7635,6873,8077)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%55%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a