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,9340,9335,9245,9254,7647,9265,9356,9344,8483,8224,9136,9423,9425,9255,8872,9450,9426,9328,9258,8622,9092,9354,8780,8778,7597,8442,9244,7592,8889,8742,9032,9329,8994,7594,7621,9327,9134,9342,9334,7648,9359,7622,9357,9355,9353,9352,9351,9350,9349,8890,9348,8094,9338,9424,9117,9332,9115,9331,9094,8830,9093,9330,9326,9044,9043,9042,9179,8914,9114,9013,8913,9010,9266,9257,9250,9249,9248,9247,8997,9246,9243,9091,9031,9135,9034,9267,8915,8846,9011,8998,8912,9116,8861,8829,9160,8772,9002,8848,8880,8796,9138,9137,8080,8893,8744,9004,8850,7987,8750,8047,8749,7976,8794,7993,8776,9041,9159,8775,8774,8887,8746,9008,9007,8123,9003,8860,8658,9000,8999,8832,8995,8125,8771,8909,8747,9001,8692,8777,8891,8770,8779,8888,8773,8499,8849,8745,9033,8911,8663,8892,8662,8652,8886,8884,8407,8828,8119,8144,8619,8233,8621,7606,8617,7992,7989,8885,8502,8615,8443,8519,8079,7293,8118,8480,8753,8522,8275,8743,8655,8661,8280,8624,8651,7299,8748,8620,7985,8501,7991,7603,8618,8847,8739,8126,8122,8230,8792,8693,8405,8695,7981,8074,8145,7632,7593,7649,8226,7588,8446,8235,8751,8517,8143,8526,8527,7637,8221,8248,8506,8213,7599,8231,8613,7605,8278,7307,8525,7586,8505,7650,8276,7609,7983,8445,8271,7628,8614,8237,8521,8329,8232,8690,8520,8500,7590,8274,8335,8336,7308,7978,8871,7589,7312,8251,7318,8694,8072,8272,8332,8654,8481,7633,8228,8797,7585,8338,8095,8478,7630,8223,8279,7291,7631,7636,7302,8078,8313,7635,8217,8214,7619,8441,8406,8281,8277,8659,8225,8252,8444,8403,7598,8117,8077,7587,7596,8503,8222,7612,7620,8831,8075,8234,8498,8440,8504,7980,8479,8404,8330,7301,8331,8497,7616,8227,8653,8097,8268,8337,7595,8881,8752,8623,7615,8334,8267,7651,8116,7624,8236,8218,8477,8401,7607,7979,7591,7584,8220,8215,8616,8216,8219,8273,7984,8049,7583,8769,8795,7986)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a