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