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 volume!=4  AND produit IN(0,6504,6362,6599,5969,6597,3827,9322,8019,5094,8877,8018,6377,7562,8872,8841,9423,8855,8876,8020,8895,8790,6612,7482,7470,6596,9528,9527,9524,9523,9522,9520,9519,9518,9517,9511,9510,9509,9504,9507,9503,9484,9479,9478,6503,9477,8842,8781,8875,8775,8848,9463,9476,9450,9422,9447,9430,9421,9420,9419,9412,9411,9410,8820,9409,8789,8699,8599,6601,3191,3196,8732,1814,5133,8721,8782,6132,6602,8697,9403,9398,9390,9389,9388,9384,9383,7935,9362,9382,9364,5132,9363,8719,9361,8794,9360,8696,9341,9336,9327,7943,9017,8612,5109,6506,8725,7217,5108,9206,9304,9014,9303,9016,9205,9204,8691,9202,5111,6505,8668,7110,6004,5987,6610,8897,8896,9301,7523,8788,7947,7377,5656,8634,8879,6603,5004,8589,7473,9339,8773,5009,8853,6142,7239,6124,5985,8094,8731,7303,5967,8569,7477,4422,8586,3609,5511,8595,7216,6502,5092,4423,3123,8685,6565,8718,8766,8854,6461,8598,7946,6146,5994,7565,8635,8047,6611,9302,8866,8593,6564,6459,7951,7238,6598,8562,6013,8744,8632,8822,6609,5966,3126,7298,7294,8627,7297,7488,8630,6035,8628,6127,8017,6007,7300,8588,8126,3122,4563,6001,3610,8590,8665,7309,8144,6143,8631,7295,9316,6464,5745,8765,7564,8688,7486,9308,3188,5744,8698,5093,6000,6403,4562,6145,8687,7306,8597,8570,8783,6508,7478,7236,8046,8640,7472,8606,8686,7950,8652,7955,9315,8821,9314,9307,5920,8638,8639,8684,7940,7571,8633,8637,7399,8568,7995,7944,7374,5991,7949,7210,6151,3124,7218,7945,6171,7938,7942,7408,6606,6607,8604,6155,6140,8125,6018,6020,8013,7941,8596,8693,8585,6566,7394,7406,7395,8798,7522,8800,7476,7355,7551,7241,7549,8024,7475,7964,8824,6520,7937,6604,8016,3008,7413,7936,5645,7352,7235,3094,7550,8074,7234,7247,7398,8008,7393,5989,3023,5997,7548,6361,8010,7289,8014,8636,7313,8129,7520,6396,8587,1569,6365,8072,2363,6364,7243,8162,6340,8051,7532,7203,8055,7357,7552,8823,7405,7939,8629,4491,8071,8025,8077,8075,8808,7957,7546,6647,6613,6633,5738,8871,5107,7253,7407,5696,7311,8694,6352,6509,8100,7290,6133,7378,7319,7487,8095,6139,6501,7308,7318,7166,7177,7353,6002)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a