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 volume!=4  AND produit IN(0,9076,6968,6253,7771,8383,7826,4147,9036,2104,7801,9275,8377,7661,8346,1840,7897,9270,7916,7621,4143,4650,8447,6255,6259,7918,7594,7919,7382,4149,9289,8256,8450,7747,4654,9085,9404,8412,9121,6879,8967,9525,9369,8358,7006,9114,9084,9230,9366,8321,7917,1839,7892,8966,9365,7926,6882,6880,8396,8258,9006,8314,7741,7592,8311,9229,4632,8384,9161,7597,9224,7489,8361,9276,9162,8420,9222,8960,8348,9278,9083,6680,9174,7743,9268,9136,6709,9086,5366,7898,6258,9107,7622,9220,8449,7023,6947,9087,9164,9145,7212,9082,9171,8342,8312,6723,1844,9241,6938,6449,9073,8442,9064,9151,7767,4626,8255,7662,9065,9089,9072,7925,4146,9172,9090,7763,6454,9071,9066,9147,7748,7457,8965,8421,9095,9175,8416,7647,9070,7856,4834,8347,6443,8355,5138,7830,7868,8351,7648,8350,8380,9120,9418,8349,7469,8372,9163,8359,8260,7732,9130,9416,8385,8371,9139,9150,7459,8362,2356,9408,8415,6944,8929,9153,7803,9117,9104,6252,6899,9119,9152,6256,8345,9217,6257,6922,8254,8253,8933,6858,6932,9037,8319,6251,6894,9158,7922,8483,6713,4250,8931,9124,7889,7833,9149,9010,9123,7778,9075,9146,9068,8241,7835,9062,9115,9160,8924,8316,7673,5134,9138,9035,9007,7832,6964,9135,9125,9044,9131,5091,3855,7521,9137,9013,4640,9003,4653,1294,5322,6963,9179,6961,9094,8453,5407,8462,4652,9012,6945,9148,9030,9141,5135,9132,7864,9122,9043,9126,7854,9092,8928,9165,6850,8812,9128,9034,9100,9176,8518,9106,9091,9098,6734,9144,5139,9051,8327,8791,9133,8900,9041,9011,9127,8992,9063,9054,9218,9069,8926,9052,8998,8469,9093,9004,8915,9028,8434,9129,8920,9033,8935,9134,7004,8366,9060,7874,8893,8963,9008,8917,9042,9001,8906,9025,8916,9009,8448,1823,8921,9039,3261,9157,9113,8460,7863,9031,7764,9166,5136,8810,8468,8954,9154,5427,9159,9074,8882,9027,9116,9081,8815,9080,5140,8467,7059,9024,5316,8972,9111,9032,8814,8340,8930,9061,8957,9047,5473,5760,7008,8461,8908,8811,7867,7184,8982,7009,6959,7219,8913,7068,6962,5408,9053,7062,8986,8339,8958,8984,8946,6854,8903,8323,4591,9110,5137,8315,4849,8919,6208,7710,6232,8927,9056,7841,9167,2107,7387,8914,8949,5321,8981,7893,8398,8465,7736,7888,8325,8971,8466,8523,8997,7005,6960,7709,8242,7928,8793,5149,9021,5315,8250,7712,2610,8993,8910,3789,7381,8813,8365,6261,7734,9002,6877,9105,7153,8987,8918,9000,8904,8318,5920,9096,7865,4042,8243,8375,8999,8324,5884,8991,9112,8953,8939,8907,8559,5307,9057,7737,8892,9173,7391,8952,6966,6755,8463,6210,8248,8370,9059,8491,8890,8888,6739,8240,5875,589,9168,4432,5443,8326,8940,7851,8922,8947,8883,9049,4656,8452,5444,8529,8408,6169,4561,7226,6006,8427,7858,3846,7711,2609,9170,9022,8297,8566,5306,8950,9109,8246,2839,8983,7714,6737,8899,5431,7842,8341,5890,7384,5433,9055,5899,7131,2101,8392,9079,8364,8936,7048,8912,4045,8995,8363,8231,1812,5422,8666,8970,8905,5329,7130,8994,4037,7589,8911,5465,8454,4041,8945,9108,5326,8435,8887,7705,8343,5768,3432,2837,4264,7866,8959,5438,8884,8407,8937,5437,8969,5354,8456,8507,7857,5470,6754,7420,4043,8564,7157,8886,8245,8322,7094,8962,8439,7895,8443,6204,8400,6859,8880,8480,7819,7887,2598,8978,7750,8429,4663,8567,7599,7735,8508,8405,8894,9019,8951,6706,8394,7386,5426,9097,8519,5336,9169,8352,5343,7845,8505,6862,8414,8249,8989,6861,8909,5439,8974,8667,8891,8436,8499,6874,8280,8261,7930,7921,8367,8527,6970,6977,8664,7850,8528,8502,8432,8446,8513,8500,8511,8501,7590,7010,8478,8395,3027,6685,3128,7609,7606,7013,8274,7605,8226,7061,6240,7667,8235,8521,5817,6974,8660,6846,8943,8517,9156,7929,8985,8512,8520,7603,9102,7787,8525,7024,6284,8003,8302,8923,8526,8522,6731,8335,7663,7896,8397,7593,8275,6844,7424,8705,8889,7574,6837,7890,8955,7861,8004,8445,9101,5435,8976,5409,6955,7862,7923,6758,8486,8329,7677,6881,7706,8336,7637,9077,7160,8484,8506,8271,7628,8221,7818,8278,8430,4036,8338,7680,7813,5434,8232,8393,7729,7814,6847,9103,6929,8504,7668,7632,5440,8230,7159,7585,6684,8433,7158,8239,5436,8406,7900,8437,6759,8247,7307,7588,7162,6888,6843,8225,6773,8237,7715,6978,7650,3788,8973,7615,5191,7758,7586,8277,8470,7631,7598,4799,9058,4759,7000,7576,7001,7495,5303,6732,8281,7383,7056,6200,7067,7649,5301,8233,6708,8222,7846,7444,6999,7635,7633,7154,8498,8313,8217,7820,8214,4287,8213,7630,5816,6740,7792,3918,8961,6263,8881,3861,6848,4205,7744,4158,6864,4587,7859,8481,6996,8510,5468,8455,7616,7811,6838,6472,8418,6876,7619,8264,5471,7894,7651,6967,8227,3998,6883,8252,8386,4597,7011,8228,8331,5332,8479,6873,6727,8403,8885,8404,8739,6705,5785,6958,8257,7658,7063,6887,6841,8473,6842,8938,5873,7816,5278,6982,8441,7782,7716,5325,8330,8272,8503,8497,7636,8438,7690,8223,6690,7815,8279,7783,8251,8276,7671,7587,5798,6845,8337,6863,8332,6875,8298,7781,6682,8417,6990,7644,5834,6868,7683,8268,8328,7620,7788,5175,8399,7870,6878,3254,7860,7595,6650,7665,8423,7612,7427,8444,8425,8234,7828,6691,7899,6692,7429,8898,7400,8440,8381,6871,7490,7410,7379,6668,6733,8488,3952,7452,7596,8515,6972,7822,3844,7423,8424,7812,8334,8477,7659,8516,7768,7591,8485,9020,7776,7660,4268,5824,6818,8216,7844,8267,5174,9142,9099,9088,4922,7875,8215,8401,6983,6942,6886,8220,8431,1289,8496,6667,6238,6941,8218,7672,4920,7871,8219,7624,6829,3881,8489,8196,7392,2463,8487,8494,7425,7730,5584,7022,6885,6926,7903,7491,8474,7777,5218,6217,6199,7817,6671,7583,7584,8262,7829,6040,6866,7426,8422,7434,7774,8236,8273,5330,7775,2464,7607,8204,6688,5827,7641,8391)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a