SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prixgros,promogros,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prixgros!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,7892,2104,7893,8315,8248,8242,8314,8343,6964,6880,6879,4632,4640,6968,6881,6961,7888,6963,7489,8241,6962,8243,6232,7923,7887,5329,6959,1823,8340,7381,8339,8240,5336,7894,6208,2461,7400,2101,8316,7391,5422,6966,7471,7422,6109,7387,6967,6106,7420,6108,8341,8250,8323,6960,8322,7432,7450,7384,7328,7411,8318,7385,7386,7322,7490,7448,7451,7331,7329,7389,7428,7452,7379,7493,7330,7449,2462,7390,7410,1818,7323,7325,7425,7494,7491,7414,7388,7026,7025,7426,7403,7417,7380)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%56%'ORDER BY CASE produit WHEN 7892 THEN (num*4)+1 WHEN 2104 THEN (num*4)+2 WHEN 7893 THEN (num*4)+3 WHEN 8315 THEN (num*4)+4 WHEN 8248 THEN (num*4)+5 WHEN 8242 THEN (num*4)+6 WHEN 8314 THEN (num*4)+7 WHEN 8343 THEN (num*4)+8 WHEN 6964 THEN (num*4)+9 WHEN 6880 THEN (num*4)+10 WHEN 6879 THEN (num*4)+11 WHEN 4632 THEN (num*4)+12 WHEN 4640 THEN (num*4)+13 WHEN 6968 THEN (num*4)+14 WHEN 6881 THEN (num*4)+15 WHEN 6961 THEN (num*4)+16 WHEN 7888 THEN (num*4)+17 WHEN 6963 THEN (num*4)+18 WHEN 7489 THEN (num*4)+19 WHEN 8241 THEN (num*4)+20 WHEN 6962 THEN (num*4)+21 WHEN 8243 THEN (num*4)+22 WHEN 6232 THEN (num*4)+23 WHEN 7923 THEN (num*4)+24 WHEN 7887 THEN (num*4)+25 WHEN 5329 THEN (num*4)+26 WHEN 6959 THEN (num*4)+27 WHEN 1823 THEN (num*4)+28 WHEN 8340 THEN (num*4)+29 WHEN 7381 THEN (num*4)+30 WHEN 8339 THEN (num*4)+31 WHEN 8240 THEN (num*4)+32 WHEN 5336 THEN (num*4)+33 WHEN 7894 THEN (num*4)+34 WHEN 6208 THEN (num*4)+35 WHEN 2461 THEN (num*4)+36 WHEN 7400 THEN (num*4)+37 WHEN 2101 THEN (num*4)+38 WHEN 8316 THEN (num*4)+39 WHEN 7391 THEN (num*4)+40 WHEN 5422 THEN (num*4)+41 WHEN 6966 THEN (num*4)+42 WHEN 7471 THEN (num*4)+43 WHEN 7422 THEN (num*4)+44 WHEN 6109 THEN (num*4)+45 WHEN 7387 THEN (num*4)+46 WHEN 6967 THEN (num*4)+47 WHEN 6106 THEN (num*4)+48 WHEN 7420 THEN (num*4)+49 WHEN 6108 THEN (num*4)+50 WHEN 8341 THEN (num*4)+51 WHEN 8250 THEN (num*4)+52 WHEN 8323 THEN (num*4)+53 WHEN 6960 THEN (num*4)+54 WHEN 8322 THEN (num*4)+55 WHEN 7432 THEN (num*4)+56 WHEN 7450 THEN (num*4)+57 WHEN 7384 THEN (num*4)+58 WHEN 7328 THEN (num*4)+59 WHEN 7411 THEN (num*4)+60 WHEN 8318 THEN (num*4)+61 WHEN 7385 THEN (num*4)+62 WHEN 7386 THEN (num*4)+63 WHEN 7322 THEN (num*4)+64 WHEN 7490 THEN (num*4)+65 WHEN 7448 THEN (num*4)+66 WHEN 7451 THEN (num*4)+67 WHEN 7331 THEN (num*4)+68 WHEN 7329 THEN (num*4)+69 WHEN 7389 THEN (num*4)+70 WHEN 7428 THEN (num*4)+71 WHEN 7452 THEN (num*4)+72 WHEN 7379 THEN (num*4)+73 WHEN 7493 THEN (num*4)+74 WHEN 7330 THEN (num*4)+75 WHEN 7449 THEN (num*4)+76 WHEN 2462 THEN (num*4)+77 WHEN 7390 THEN (num*4)+78 WHEN 7410 THEN (num*4)+79 WHEN 1818 THEN (num*4)+80 WHEN 7323 THEN (num*4)+81 WHEN 7325 THEN (num*4)+82 WHEN 7425 THEN (num*4)+83 WHEN 7494 THEN (num*4)+84 WHEN 7491 THEN (num*4)+85 WHEN 7414 THEN (num*4)+86 WHEN 7388 THEN (num*4)+87 WHEN 7026 THEN (num*4)+88 WHEN 7025 THEN (num*4)+89 WHEN 7426 THEN (num*4)+90 WHEN 7403 THEN (num*4)+91 WHEN 7417 THEN (num*4)+92 WHEN 7380 THEN (num*4)+93 END,numErr153a