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,8447,8315,8342,8319,8248,8242,8314,9413,8343,6964,6880,7382,6879,4632,4640,6968,6881,6961,7888,6963,7489,8241,6962,8243,6232,7923,7887,7226,5329,6959,7383,1823,8340,7381,8339,8240,5336,7894,6208,7435,8321,2461,7400,2101,7897,8316,5326,7391,5422,6966,7427,7543,7441,7922,7471,7422,6109,7429,7898,7387,7443,7416,7921,6967,6106,6871,7436,7420,6108,7437,7495,7446,8341,8250,8323,7430,6960,8322,7895,6864,7438,7447,7554,7432,7556,7450,7384,7558,7328,7442,7411,8318,7896,7545,7541,7385,7386,7322,7490,7448,7424,7451,5332,7331,7444,7329,7389,7428,7452,7379,7493,5325,7330,7449,7544,2462,7542,7390,7410,6868,1818,7323,6317,7325,7425,7494,7423,7445,7392,5330,7491,7414,6284,7419,7440,7388,7026,7025,7434,7426,7403,7417,7380,6866)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%62%'ORDER BY CASE produit WHEN 7892 THEN (num*6)+1 WHEN 2104 THEN (num*6)+2 WHEN 7893 THEN (num*6)+3 WHEN 8447 THEN (num*6)+4 WHEN 8315 THEN (num*6)+5 WHEN 8342 THEN (num*6)+6 WHEN 8319 THEN (num*6)+7 WHEN 8248 THEN (num*6)+8 WHEN 8242 THEN (num*6)+9 WHEN 8314 THEN (num*6)+10 WHEN 9413 THEN (num*6)+11 WHEN 8343 THEN (num*6)+12 WHEN 6964 THEN (num*6)+13 WHEN 6880 THEN (num*6)+14 WHEN 7382 THEN (num*6)+15 WHEN 6879 THEN (num*6)+16 WHEN 4632 THEN (num*6)+17 WHEN 4640 THEN (num*6)+18 WHEN 6968 THEN (num*6)+19 WHEN 6881 THEN (num*6)+20 WHEN 6961 THEN (num*6)+21 WHEN 7888 THEN (num*6)+22 WHEN 6963 THEN (num*6)+23 WHEN 7489 THEN (num*6)+24 WHEN 8241 THEN (num*6)+25 WHEN 6962 THEN (num*6)+26 WHEN 8243 THEN (num*6)+27 WHEN 6232 THEN (num*6)+28 WHEN 7923 THEN (num*6)+29 WHEN 7887 THEN (num*6)+30 WHEN 7226 THEN (num*6)+31 WHEN 5329 THEN (num*6)+32 WHEN 6959 THEN (num*6)+33 WHEN 7383 THEN (num*6)+34 WHEN 1823 THEN (num*6)+35 WHEN 8340 THEN (num*6)+36 WHEN 7381 THEN (num*6)+37 WHEN 8339 THEN (num*6)+38 WHEN 8240 THEN (num*6)+39 WHEN 5336 THEN (num*6)+40 WHEN 7894 THEN (num*6)+41 WHEN 6208 THEN (num*6)+42 WHEN 7435 THEN (num*6)+43 WHEN 8321 THEN (num*6)+44 WHEN 2461 THEN (num*6)+45 WHEN 7400 THEN (num*6)+46 WHEN 2101 THEN (num*6)+47 WHEN 7897 THEN (num*6)+48 WHEN 8316 THEN (num*6)+49 WHEN 5326 THEN (num*6)+50 WHEN 7391 THEN (num*6)+51 WHEN 5422 THEN (num*6)+52 WHEN 6966 THEN (num*6)+53 WHEN 7427 THEN (num*6)+54 WHEN 7543 THEN (num*6)+55 WHEN 7441 THEN (num*6)+56 WHEN 7922 THEN (num*6)+57 WHEN 7471 THEN (num*6)+58 WHEN 7422 THEN (num*6)+59 WHEN 6109 THEN (num*6)+60 WHEN 7429 THEN (num*6)+61 WHEN 7898 THEN (num*6)+62 WHEN 7387 THEN (num*6)+63 WHEN 7443 THEN (num*6)+64 WHEN 7416 THEN (num*6)+65 WHEN 7921 THEN (num*6)+66 WHEN 6967 THEN (num*6)+67 WHEN 6106 THEN (num*6)+68 WHEN 6871 THEN (num*6)+69 WHEN 7436 THEN (num*6)+70 WHEN 7420 THEN (num*6)+71 WHEN 6108 THEN (num*6)+72 WHEN 7437 THEN (num*6)+73 WHEN 7495 THEN (num*6)+74 WHEN 7446 THEN (num*6)+75 WHEN 8341 THEN (num*6)+76 WHEN 8250 THEN (num*6)+77 WHEN 8323 THEN (num*6)+78 WHEN 7430 THEN (num*6)+79 WHEN 6960 THEN (num*6)+80 WHEN 8322 THEN (num*6)+81 WHEN 7895 THEN (num*6)+82 WHEN 6864 THEN (num*6)+83 WHEN 7438 THEN (num*6)+84 WHEN 7447 THEN (num*6)+85 WHEN 7554 THEN (num*6)+86 WHEN 7432 THEN (num*6)+87 WHEN 7556 THEN (num*6)+88 WHEN 7450 THEN (num*6)+89 WHEN 7384 THEN (num*6)+90 WHEN 7558 THEN (num*6)+91 WHEN 7328 THEN (num*6)+92 WHEN 7442 THEN (num*6)+93 WHEN 7411 THEN (num*6)+94 WHEN 8318 THEN (num*6)+95 WHEN 7896 THEN (num*6)+96 WHEN 7545 THEN (num*6)+97 WHEN 7541 THEN (num*6)+98 WHEN 7385 THEN (num*6)+99 WHEN 7386 THEN (num*6)+100 WHEN 7322 THEN (num*6)+101 WHEN 7490 THEN (num*6)+102 WHEN 7448 THEN (num*6)+103 WHEN 7424 THEN (num*6)+104 WHEN 7451 THEN (num*6)+105 WHEN 5332 THEN (num*6)+106 WHEN 7331 THEN (num*6)+107 WHEN 7444 THEN (num*6)+108 WHEN 7329 THEN (num*6)+109 WHEN 7389 THEN (num*6)+110 WHEN 7428 THEN (num*6)+111 WHEN 7452 THEN (num*6)+112 WHEN 7379 THEN (num*6)+113 WHEN 7493 THEN (num*6)+114 WHEN 5325 THEN (num*6)+115 WHEN 7330 THEN (num*6)+116 WHEN 7449 THEN (num*6)+117 WHEN 7544 THEN (num*6)+118 WHEN 2462 THEN (num*6)+119 WHEN 7542 THEN (num*6)+120 WHEN 7390 THEN (num*6)+121 WHEN 7410 THEN (num*6)+122 WHEN 6868 THEN (num*6)+123 WHEN 1818 THEN (num*6)+124 WHEN 7323 THEN (num*6)+125 WHEN 6317 THEN (num*6)+126 WHEN 7325 THEN (num*6)+127 WHEN 7425 THEN (num*6)+128 WHEN 7494 THEN (num*6)+129 WHEN 7423 THEN (num*6)+130 WHEN 7445 THEN (num*6)+131 WHEN 7392 THEN (num*6)+132 WHEN 5330 THEN (num*6)+133 WHEN 7491 THEN (num*6)+134 WHEN 7414 THEN (num*6)+135 WHEN 6284 THEN (num*6)+136 WHEN 7419 THEN (num*6)+137 WHEN 7440 THEN (num*6)+138 WHEN 7388 THEN (num*6)+139 WHEN 7026 THEN (num*6)+140 WHEN 7025 THEN (num*6)+141 WHEN 7434 THEN (num*6)+142 WHEN 7426 THEN (num*6)+143 WHEN 7403 THEN (num*6)+144 WHEN 7417 THEN (num*6)+145 WHEN 7380 THEN (num*6)+146 WHEN 6866 THEN (num*6)+147 END,numErr153a