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=2 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,9344,9424,5366,6504,1840,7947,9328,9329,4654,1844,9220,9174,8176,6377,8791,9412,9409,7833,9410,9411,9067,9095,8812,9301,6503,9523,9524,9522,9520,9519,9518,9517,9484,9479,9478,9076,9477,9364,9476,9342,8790,5969,9035,9448,8882,8815,8809,8933,9450,9447,8906,9442,4650,9423,9422,9421,9420,9419,8814,5138,8793,8900,2356,9006,8019,1839,9130,9164,9066,9143,9065,9163,9171,9064,9222,8920,9334,9172,9425,9115,9305,9267,8929,9120,9139,8924,9037,8915,9277,9339,8810,9093,9036,9116,9303,8919,8918,9044,9075,9043,8931,8963,9034,8708,9010,9362,8895,9322,1814,9011,5134,9113,1809,7835,6601,8855,5133,8811,8869,8935,9217,9361,9304,9135,9363,9403,9042,9398,8908,9391,9091,8916,7832,9390,8599,9389,9360,9388,9384,5094,9327,6602,8944,8807,5091,6474,9030,8917,8946,8926,9309,4653,1811,7943,8971,5135,8921,9013,5132,4652,8890,3827,8872,9074,7854,8903,9224,8774,9206,9205,6132,9202,8842,8841,5108,9017,3777,5322,6376,9341,8813,9336,8853,5407,5542,8899,5139,3191,8964,9014,3196,3140,8781,7217,8904,8866,9016,9117,8020,9179,8877,5136,8957,6734,8434,8927,8518,9158,8848,7521,6362,8666,5109,7864,6604,8870,6599,6375,6850,8820,8910,5004,8905,6506,5473,8954,8448,7874,8948,3789,8907,8789,8366,6142,5140,8166,7764,8922,8875,5427,8782,9094,7711,7863,9096,7484,5092,5985,7377,5408,3007,8327,5315,8018,8879,6473,7009,3261,7303,5316,5987,5009,7239,8883,4591,8562,5137,7841,8773,6004,6124,7062,7184,6877,7004,7734,7954,6505,6610,8699,6597,7059,4423,7216,6612,8721,7710,3123,8958,8732,2107,8523,5111,5307,8365,8857,5321,6603,8719,7951,8325,6476,6146,5967,8398,5884,6461,7712,8998,8667,7736,8370,6598,8859,8167,3609,5031,7709,8953,7219,8375,8952,8854,5656,9173,8788,6502,9168,8691,7006,5875,8665,4422,8392,8589,8894,7238,5306,7737,4554,6013,5920,8783,7523,4485,6882,8507,8326,1812,8324,6564,7133,8697,7309,3124,8491,8765,7130,4563,6415,8569,7531,8612,7928,2598,8775,8696,8951,7735,3122,7486,5511,5433,4656,4279,8249,7946,7374,9169,8718,4561,6739,3126,5890,7161,6171,8297,8593,8725,8598,6001,4041,6495,6412,6007,8364,7488,5896,7298,8822,8408,6157,7171,8245,6565,6127,8439,8047,7858,4562,6035,6609,7944,7935,8570,8688,8016,6497,7297,7094,4043,7048,8435,8797,6210,2837,5966,5470,5426,8794,4834,4042,8635,2839,6006,5030,7157,7861,7300,7851,7965,5768,7474,5438,8668,7981,7567,3188,5444,2838,4155,8126,8744,6754,8400,6755,8143,7236,5898,5541,5343,6018,6874,5899,8604,8596,8684,3129,8585,8436,8446,8514,8363,8568,8722,8017,7536,7562,3610,6403,8624,8704,8645,6508,6000,8590,7950,6143,8606,7850,6861,7131,7294,8634,5465,8627,8633,8513,8632,8766,6496,8747,8588,4663,6151,8125,8698,8443,7956,8731,8459,8685,5437,8703,8856,6607,8693,8457,8001,7930,7819,8501,7574,6155,8280,6787,6140,8720,8630,8144,8395,7807,7845,3657,8849,5093,8628,6020,4037,4045,7677,7533,7936,6475,7550,7295,8445,8663,8519,8405,6731,7983,8013,8329,6685,8394,7349,8640,8652,7964,8074,8003,7929,8521,6974,7569,5991,6977,7937,7538,7787,8631,6413,5409,8687,8010,8128,7663,7941,6970,7460,7667,7628,7995,8046,3008,8512,3094,7464,8124,7862,7890,3023,7234,8517,8639,8506,7603,7250,8044,8221,7669,8002,6929,7680,4036,8686,7706,7355,8278,7668,8701,7241,8393,7247,6684,6361,7351,5435,7637,5645,7235,7289,7398,5989,5434,8008,7468,7224,6759,7162,5997,6773,7251,7715,7458,6978,7352,7463,7248,5436,8808,7716,7534,2363,7245,7612,4266,7631,6878,6417,8277,7744,3446,7610,5471,8279,7311,8881,4587,7318,7067,7177,6499,4491,8653,7630,7636,7939,8075,7859,7056,7753,6708,6501,6249,3179,7243,6365,8162,6340,8025,8129,6493,7959,6396,7487,8313,8100,6139,6352,8071,5301,8120,6002,7049,7651,7166,8051,7539,8281,7758,7485,7249,5303,6364,7378,6682,4287,7203,8072,6740,1569,5468,8694,7001,7957,7682,8399,7288,8014,7665,7615,7063,7319,8961,8330,8331,5873,7634,5696,8623,7825,8823,6286,6949,8251,6613,5107,6990,8077,7595,6633,5738,8403,6705,7532,7537,7353,4158,8252,8444,5278,7717,6863,8404,6873,8871,7152,7671,8257,8095,7635,7520,7357,7616,6690,7308,4597,6996,6509,8097,7540,6876,7639,3998,7860,6875,7788,7000,7690,8629,7792,3788,8055,4759,7683,7820,8328,4799,7546,7253,6999,5798,8295)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a