SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,8732,8841,6497,1840,2356,7239,5004,6474,6377,8897,4650,1839,5541,6476,6362,3777,9121,6473,1844,9044,9064,7238,9309,9076,9204,5031,9508,9075,8931,8781,8924,9066,9065,9013,9217,8860,9120,8882,8928,8957,5315,8920,8963,8870,8775,8788,8926,5321,8944,7062,8922,8958,5138,8703,7954,8953,9173,5306,5542,5009,8731,8895,8952,7531,8964,8751,5091,5408,5322,5136,9074,8832,6734,6415,5890,8327,6035,7709,5473,6007,8896,8144,8776,7764,5316,5140,8746,8366,8398,9109,5137,9108,7171,6151,7734,6210,3140,7737,5427,8375,8951,7858,6155,5465,8370,5875,6754,6755,7714,5433,5439,5443,5438,5437,8408,8722,7705,8395,7956,5884,3094,7131,3261,5898,8392,8745,8502,8747,6413,8394,5896,8779,8692,5991,6862,8245,8501,8720,6970,6861,8003,7845,7890,8512,8044,8249,5435,7013,8124,6787,5409,8013,8701,6974,7224,7159,7680,7158,5434,5440,5436,6978,7715,7631,7243,8071,8097,8120,6509,6499,5303,6493,6396,2363,6365,5301,7744,7154,7651,1569,6740,5468,6996,6682,4587,4266,8961,8503,8831,8871,4597,7682,7063,7859,7716,7717,7980,5785,7671,8328,8025,6417,7612,4158,6708,7788,6249,7753,5969,7166,8100)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a