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,2104,1840,7897,7916,4650,7918,7919,7382,4654,6879,7006,1839,7892,7917,9174,9151,9147,9150,9148,1844,2356,5366,7835,7833,7521,7832,4632,6964,6850,4653,4652,4640,6963,3777,5354,5322,8518,8434,5408,7888,3789,8448,7184,5343,6208,1823,8523,5316,7005,7841,7893,6232,2107,5336,7928,5321,6877,8436,7887,7923,5329,6847,7226,5315,8435,7471,7898,5433,7894,2101,7422,5326,7922,6846,7441,5440,1812,7930,5436,7427,7895,5422,7384,7420,5435,7436,6844,7921,5434,5409,7929,7444,7430,6843,7437,6842,7896,7438,6841,7387,6878,7495,6845,7432,7442,5332,3788,7411,7424,5325,6848,7385,7392,7445,5330,6866,6284,7414,7388,7419)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%60%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a