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,8882,7833,1844,5138,7832,7712,5408,2356,8327,8518,9174,9164,9220,9130,9036,9065,9120,9171,9222,1840,9076,4650,5366,1839,7835,9075,8924,8933,7521,9030,9170,9037,9112,6850,9068,9035,4652,6945,5407,9224,4653,9139,5091,9113,8930,3261,8434,9163,8920,9135,9121,9169,5134,6734,7062,5322,5354,3789,8908,9111,9172,9064,9066,3777,5136,7854,9508,4591,9506,7184,9094,9006,7709,9011,9218,5343,9110,9217,4654,8448,8964,9173,7006,7094,5135,5890,5140,9168,9109,7219,8929,5139,8917,7068,9158,5473,9021,7005,7841,7874,8491,6974,7764,9093,7008,5316,5315,8324,9063,5875,8297,8791,5137,8392,8436,8931,7842,8366,7004,7885,8815,8927,7900,7161,8935,7667,7153,5426,7131,8963,8812,5321,8946,8435,8948,8954,7735,8971,8446,8326,8944,5884,6877,4042,4663,5470,7714,5306,7009,8919,8928,2107,7734,6157,7010,6847,7850,5440,7736,8375,7886,5896,8325,6787,6844,5768,8921,8906,6731,8367,8918,5438,8249,8408,8363,7750,6685,8926,7013,8923,8221,8900,8245,8916,8922,8814,5409,8907,5427,5436,8903,6759,8910,8904,8914,5920,8370,8811,8905,7059,4597,5433,8365,7711,7157,8899,4656,8398,8507,5307,8793,7706,6210,7737,7061,7609,7162,6739,6861,5873,7680,8364,6846,7048,8506,6862,6874,8519,8894,5465,5444,7063,7677,5434,7851,8883,8521,5899,7669,7668,6754,7858,6755,4155,5435,7130,7160,5898,5439,5443,5437,7705,6843,7715,4036,7158,8445,2839,7159,8407,8443,4834,4045,4043,4041,2837,2838,6970,7603,6837,7890,6758,7665,7716,6873,6684,6848,7682,6841,8328,7000,5278,5834,3998,7860,4759,6708,3446,4799,4158,7563,3788,6999,7634,6990,5785,6249,6838,6842,6682,7717,7758,6978,6878,6949,5303,8313,7683,6863,4587,6690,5468,7049,4287,5471,7710,6845,7154,8295,6996,7056,7744,7671,5301,6740,7067,7001,4266,6705,5798)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%62%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a