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