SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,2104,1840,7897,7916,4650,7918,7919,7382,4654,6879,7006,1839,7892,7917,9174,9151,9147,9150,9148,1844,2356,5366,7835,7833,7521,7832,4632,6964,6850,4653,4652,4640,6963,3777,5354,5322,8518,8434,5408,7888,3789,8448,7184,5343,6208,1823,8523,5316,7005,7841,7893,6232,2107,5336,7928,5321,6877,8436,7887,7923,5329,6847,7226,5315,8435,7471,7898,5433,7894,2101,7422,5326,7922,6846,7441,5440,1812,7930,5436,7427,7895,5422,7384,7420,5435,7436,6844,7921,5434,5409,7929,7444,7430,6843,7437,6842,7896,7438,6841,7387,6878,7495,6845,7432,7442,5332,3788,7411,7424,5325,6848,7385,7392,7445,5330,6866,6284,7414,7388,7419)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%61%'ORDER BY CASE produit WHEN 2104 THEN (num*5)+1 WHEN 1840 THEN (num*5)+2 WHEN 7897 THEN (num*5)+3 WHEN 7916 THEN (num*5)+4 WHEN 4650 THEN (num*5)+5 WHEN 7918 THEN (num*5)+6 WHEN 7919 THEN (num*5)+7 WHEN 7382 THEN (num*5)+8 WHEN 4654 THEN (num*5)+9 WHEN 6879 THEN (num*5)+10 WHEN 7006 THEN (num*5)+11 WHEN 1839 THEN (num*5)+12 WHEN 7892 THEN (num*5)+13 WHEN 7917 THEN (num*5)+14 WHEN 9174 THEN (num*5)+15 WHEN 9151 THEN (num*5)+16 WHEN 9147 THEN (num*5)+17 WHEN 9150 THEN (num*5)+18 WHEN 9148 THEN (num*5)+19 WHEN 1844 THEN (num*5)+20 WHEN 2356 THEN (num*5)+21 WHEN 5366 THEN (num*5)+22 WHEN 7835 THEN (num*5)+23 WHEN 7833 THEN (num*5)+24 WHEN 7521 THEN (num*5)+25 WHEN 7832 THEN (num*5)+26 WHEN 4632 THEN (num*5)+27 WHEN 6964 THEN (num*5)+28 WHEN 6850 THEN (num*5)+29 WHEN 4653 THEN (num*5)+30 WHEN 4652 THEN (num*5)+31 WHEN 4640 THEN (num*5)+32 WHEN 6963 THEN (num*5)+33 WHEN 3777 THEN (num*5)+34 WHEN 5354 THEN (num*5)+35 WHEN 5322 THEN (num*5)+36 WHEN 8518 THEN (num*5)+37 WHEN 8434 THEN (num*5)+38 WHEN 5408 THEN (num*5)+39 WHEN 7888 THEN (num*5)+40 WHEN 3789 THEN (num*5)+41 WHEN 8448 THEN (num*5)+42 WHEN 7184 THEN (num*5)+43 WHEN 5343 THEN (num*5)+44 WHEN 6208 THEN (num*5)+45 WHEN 1823 THEN (num*5)+46 WHEN 8523 THEN (num*5)+47 WHEN 5316 THEN (num*5)+48 WHEN 7005 THEN (num*5)+49 WHEN 7841 THEN (num*5)+50 WHEN 7893 THEN (num*5)+51 WHEN 6232 THEN (num*5)+52 WHEN 2107 THEN (num*5)+53 WHEN 5336 THEN (num*5)+54 WHEN 7928 THEN (num*5)+55 WHEN 5321 THEN (num*5)+56 WHEN 6877 THEN (num*5)+57 WHEN 8436 THEN (num*5)+58 WHEN 7887 THEN (num*5)+59 WHEN 7923 THEN (num*5)+60 WHEN 5329 THEN (num*5)+61 WHEN 6847 THEN (num*5)+62 WHEN 7226 THEN (num*5)+63 WHEN 5315 THEN (num*5)+64 WHEN 8435 THEN (num*5)+65 WHEN 7471 THEN (num*5)+66 WHEN 7898 THEN (num*5)+67 WHEN 5433 THEN (num*5)+68 WHEN 7894 THEN (num*5)+69 WHEN 2101 THEN (num*5)+70 WHEN 7422 THEN (num*5)+71 WHEN 5326 THEN (num*5)+72 WHEN 7922 THEN (num*5)+73 WHEN 6846 THEN (num*5)+74 WHEN 7441 THEN (num*5)+75 WHEN 5440 THEN (num*5)+76 WHEN 1812 THEN (num*5)+77 WHEN 7930 THEN (num*5)+78 WHEN 5436 THEN (num*5)+79 WHEN 7427 THEN (num*5)+80 WHEN 7895 THEN (num*5)+81 WHEN 5422 THEN (num*5)+82 WHEN 7384 THEN (num*5)+83 WHEN 7420 THEN (num*5)+84 WHEN 5435 THEN (num*5)+85 WHEN 7436 THEN (num*5)+86 WHEN 6844 THEN (num*5)+87 WHEN 7921 THEN (num*5)+88 WHEN 5434 THEN (num*5)+89 WHEN 5409 THEN (num*5)+90 WHEN 7929 THEN (num*5)+91 WHEN 7444 THEN (num*5)+92 WHEN 7430 THEN (num*5)+93 WHEN 6843 THEN (num*5)+94 WHEN 7437 THEN (num*5)+95 WHEN 6842 THEN (num*5)+96 WHEN 7896 THEN (num*5)+97 WHEN 7438 THEN (num*5)+98 WHEN 6841 THEN (num*5)+99 WHEN 7387 THEN (num*5)+100 WHEN 6878 THEN (num*5)+101 WHEN 7495 THEN (num*5)+102 WHEN 6845 THEN (num*5)+103 WHEN 7432 THEN (num*5)+104 WHEN 7442 THEN (num*5)+105 WHEN 5332 THEN (num*5)+106 WHEN 3788 THEN (num*5)+107 WHEN 7411 THEN (num*5)+108 WHEN 7424 THEN (num*5)+109 WHEN 5325 THEN (num*5)+110 WHEN 6848 THEN (num*5)+111 WHEN 7385 THEN (num*5)+112 WHEN 7392 THEN (num*5)+113 WHEN 7445 THEN (num*5)+114 WHEN 5330 THEN (num*5)+115 WHEN 6866 THEN (num*5)+116 WHEN 6284 THEN (num*5)+117 WHEN 7414 THEN (num*5)+118 WHEN 7388 THEN (num*5)+119 WHEN 7419 THEN (num*5)+120 END,numErr153a