SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=1 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,7748,6894,6349,9276,9284,6716,9360,8576,9525,8304,9289,9524,9526,9270,9520,9519,9268,9518,9278,7873,9306,7830,9230,9275,9410,9475,9295,9474,9473,9446,9240,4149,9404,9294,9449,9239,4147,4143,9447,4626,7826,8312,8299,9420,9411,9409,7756,9345,7580,9269,9364,9281,3002,9333,9421,9226,4250,9448,6377,9234,9406,9405,9336,9419,9412,4146,8311,9282,9363,7732,9362,8656,6713,6947,9343,7889,6680,9305,9391,7747,9287,7868,9233,6723,6709,9286,9235,9299,9347,9346,9236,9231,9232,9283,9337,9313,9312,9311,9277,9341,9298,9297,3621,9296,9293,9292,8673,9288,6384,9280,9279,9361,9274,9273,9272,9271,8954,5535,9300,9242,9241,9238,9339,9237,7137,5950,7954,9227,9310,9291,8819,8963,8626,8584,9285,5537,8706,8827,3769,9228,8577,8303,8820,8873,8643,7952,9290,8787,8642,8592,8789,8874,9039,8866,6291,3855,8708,8782,8781,8765,6296,8591,8707,8699,8767,7726,8671,8865,8580,8660,8696,8683,7731,7238,4279,8575,7474,7729,7725,5031,8709,5004,3609,8937,4423,4422,3610,5009,7239,7714,6362,4591,7480,8766,8818,6169,7204,4429,8160,8439,7574,6731,8641,8864,7236,7956,8585,6970,7996,8297,4497,6390,8955,4663,2609,3846,8674,7960,8822,8697,8245,7890,7995,7965,8437,8825,7667,8669,8470,7247,4432,3023,8246,7235,8420,6290,5760,8414,8486,5149,4485,7241,2598,7964,8128,6361,7715,2610,8249,3861,7668,8698,8247,7680,7677,8484,8302,6365,3029,8162,8823,6509,8055,8051,8120,6364,3918,7203,8456,7319,8352,7758,6690,4587,7644,6682,8426,6650,8418,6708,6706,7671,7576,5816,4491,6352,6692,8417,3008,3027,8438,5798,7665,8423,7716,3254,8328,6691,8298,7828,4597,8425,6705,6340,7253,7177,8257,8129,8100,8023,8700,6501,8625,7683,4158,7997,7690,7258,7870,8488,7998,8582,6818,6238,3844,6972,8516,4426,7727,8485,7822,7336,6688,8422,7871,7262,7259,8826,6344,7829,9088,8424,8571,8474,6382,8161,7335,8259,7966,8489,6642,7261,8515,6217,6484,8487,8672,7263,8475,7260,7903,8131,7730,4268)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a