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,9174,4653,8020,2356,1814,1809,1811,5132,3827,6599,9322,9510,9494,9503,9505,9504,9509,5133,9508,9403,9511,5109,9507,8019,6610,5967,6612,1844,5656,6598,5366,8018,9304,5091,1840,5135,1839,4654,5136,8016,4650,5322,7832,4652,9301,9016,5108,5315,9014,5321,8017,3777,5408,6597,5991,6001,6611,2107,8918,5745,5966,7928,5137,6609,8435,6155,9316,6140,9315,5433,9314,1812,9308,9307,5343,8010,5354,6844,8436,6846,5440,5989,7248,6847,5436,6139,5984,6002,5965,2363,7249,5983,5975,5969,3788,5696,6842,6613,5107,5738,7532,5968)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a