SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,8449,7382,7921,9131,4432,9175,8342,8522,7226,9001,6859,8960,7897,8959,7922,9092,7416,7898,8660,7895,9062,8447,5326,6204,4678,8397,3989,8321,8302,8962,9134,8476,4205,7424,7896,8004,6955,7437,7446,8222,7495,7436,7430,7383,7729,7444,3918,7438,6727,8264,5332,7782,7447,7442,5325,6958,7783,7441,7427,7781,7429,7435,6650,7443,6668,7419,6818,7440,6181,6926,7423,7434,7017,7660,9088,5827,6667,7392,6671,7659,6942,6983,6175,6919,6816,7445,5330,6646,6941,7730,7498,7870,8431)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 8449 THEN (num*4)+1 WHEN 7382 THEN (num*4)+2 WHEN 7921 THEN (num*4)+3 WHEN 9131 THEN (num*4)+4 WHEN 4432 THEN (num*4)+5 WHEN 9175 THEN (num*4)+6 WHEN 8342 THEN (num*4)+7 WHEN 8522 THEN (num*4)+8 WHEN 7226 THEN (num*4)+9 WHEN 9001 THEN (num*4)+10 WHEN 6859 THEN (num*4)+11 WHEN 8960 THEN (num*4)+12 WHEN 7897 THEN (num*4)+13 WHEN 8959 THEN (num*4)+14 WHEN 7922 THEN (num*4)+15 WHEN 9092 THEN (num*4)+16 WHEN 7416 THEN (num*4)+17 WHEN 7898 THEN (num*4)+18 WHEN 8660 THEN (num*4)+19 WHEN 7895 THEN (num*4)+20 WHEN 9062 THEN (num*4)+21 WHEN 8447 THEN (num*4)+22 WHEN 5326 THEN (num*4)+23 WHEN 6204 THEN (num*4)+24 WHEN 4678 THEN (num*4)+25 WHEN 8397 THEN (num*4)+26 WHEN 3989 THEN (num*4)+27 WHEN 8321 THEN (num*4)+28 WHEN 8302 THEN (num*4)+29 WHEN 8962 THEN (num*4)+30 WHEN 9134 THEN (num*4)+31 WHEN 8476 THEN (num*4)+32 WHEN 4205 THEN (num*4)+33 WHEN 7424 THEN (num*4)+34 WHEN 7896 THEN (num*4)+35 WHEN 8004 THEN (num*4)+36 WHEN 6955 THEN (num*4)+37 WHEN 7437 THEN (num*4)+38 WHEN 7446 THEN (num*4)+39 WHEN 8222 THEN (num*4)+40 WHEN 7495 THEN (num*4)+41 WHEN 7436 THEN (num*4)+42 WHEN 7430 THEN (num*4)+43 WHEN 7383 THEN (num*4)+44 WHEN 7729 THEN (num*4)+45 WHEN 7444 THEN (num*4)+46 WHEN 3918 THEN (num*4)+47 WHEN 7438 THEN (num*4)+48 WHEN 6727 THEN (num*4)+49 WHEN 8264 THEN (num*4)+50 WHEN 5332 THEN (num*4)+51 WHEN 7782 THEN (num*4)+52 WHEN 7447 THEN (num*4)+53 WHEN 7442 THEN (num*4)+54 WHEN 5325 THEN (num*4)+55 WHEN 6958 THEN (num*4)+56 WHEN 7783 THEN (num*4)+57 WHEN 7441 THEN (num*4)+58 WHEN 7427 THEN (num*4)+59 WHEN 7781 THEN (num*4)+60 WHEN 7429 THEN (num*4)+61 WHEN 7435 THEN (num*4)+62 WHEN 6650 THEN (num*4)+63 WHEN 7443 THEN (num*4)+64 WHEN 6668 THEN (num*4)+65 WHEN 7419 THEN (num*4)+66 WHEN 6818 THEN (num*4)+67 WHEN 7440 THEN (num*4)+68 WHEN 6181 THEN (num*4)+69 WHEN 6926 THEN (num*4)+70 WHEN 7423 THEN (num*4)+71 WHEN 7434 THEN (num*4)+72 WHEN 7017 THEN (num*4)+73 WHEN 7660 THEN (num*4)+74 WHEN 9088 THEN (num*4)+75 WHEN 5827 THEN (num*4)+76 WHEN 6667 THEN (num*4)+77 WHEN 7392 THEN (num*4)+78 WHEN 6671 THEN (num*4)+79 WHEN 7659 THEN (num*4)+80 WHEN 6942 THEN (num*4)+81 WHEN 6983 THEN (num*4)+82 WHEN 6175 THEN (num*4)+83 WHEN 6919 THEN (num*4)+84 WHEN 6816 THEN (num*4)+85 WHEN 7445 THEN (num*4)+86 WHEN 5330 THEN (num*4)+87 WHEN 6646 THEN (num*4)+88 WHEN 6941 THEN (num*4)+89 WHEN 7730 THEN (num*4)+90 WHEN 7498 THEN (num*4)+91 WHEN 7870 THEN (num*4)+92 WHEN 8431 THEN (num*4)+93 END,numErr153a