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