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,3827,8586,8597,1809,9383,5656,9382,7218,9303,5994,9522,9517,9509,9507,9425,9430,8595,5109,9302,6610,8593,6004,6124,5111,7523,8568,6596,8562,7110,7473,3007,6459,9388,7940,8624,7482,8685,7944,7374,7477,5745,7294,7949,7565,7470,6464,7564,7938,7942,9308,9307,7472,3129,7522,8690,7478,7476,7549,7395,7955,7475,7551,7393,8024,7413,7394,7399,7408,7407,5738,5107,7939,6647)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 3827 THEN (num*3)+1 WHEN 8586 THEN (num*3)+2 WHEN 8597 THEN (num*3)+3 WHEN 1809 THEN (num*3)+4 WHEN 9383 THEN (num*3)+5 WHEN 5656 THEN (num*3)+6 WHEN 9382 THEN (num*3)+7 WHEN 7218 THEN (num*3)+8 WHEN 9303 THEN (num*3)+9 WHEN 5994 THEN (num*3)+10 WHEN 9522 THEN (num*3)+11 WHEN 9517 THEN (num*3)+12 WHEN 9509 THEN (num*3)+13 WHEN 9507 THEN (num*3)+14 WHEN 9425 THEN (num*3)+15 WHEN 9430 THEN (num*3)+16 WHEN 8595 THEN (num*3)+17 WHEN 5109 THEN (num*3)+18 WHEN 9302 THEN (num*3)+19 WHEN 6610 THEN (num*3)+20 WHEN 8593 THEN (num*3)+21 WHEN 6004 THEN (num*3)+22 WHEN 6124 THEN (num*3)+23 WHEN 5111 THEN (num*3)+24 WHEN 7523 THEN (num*3)+25 WHEN 8568 THEN (num*3)+26 WHEN 6596 THEN (num*3)+27 WHEN 8562 THEN (num*3)+28 WHEN 7110 THEN (num*3)+29 WHEN 7473 THEN (num*3)+30 WHEN 3007 THEN (num*3)+31 WHEN 6459 THEN (num*3)+32 WHEN 9388 THEN (num*3)+33 WHEN 7940 THEN (num*3)+34 WHEN 8624 THEN (num*3)+35 WHEN 7482 THEN (num*3)+36 WHEN 8685 THEN (num*3)+37 WHEN 7944 THEN (num*3)+38 WHEN 7374 THEN (num*3)+39 WHEN 7477 THEN (num*3)+40 WHEN 5745 THEN (num*3)+41 WHEN 7294 THEN (num*3)+42 WHEN 7949 THEN (num*3)+43 WHEN 7565 THEN (num*3)+44 WHEN 7470 THEN (num*3)+45 WHEN 6464 THEN (num*3)+46 WHEN 7564 THEN (num*3)+47 WHEN 7938 THEN (num*3)+48 WHEN 7942 THEN (num*3)+49 WHEN 9308 THEN (num*3)+50 WHEN 9307 THEN (num*3)+51 WHEN 7472 THEN (num*3)+52 WHEN 3129 THEN (num*3)+53 WHEN 7522 THEN (num*3)+54 WHEN 8690 THEN (num*3)+55 WHEN 7478 THEN (num*3)+56 WHEN 7476 THEN (num*3)+57 WHEN 7549 THEN (num*3)+58 WHEN 7395 THEN (num*3)+59 WHEN 7955 THEN (num*3)+60 WHEN 7475 THEN (num*3)+61 WHEN 7551 THEN (num*3)+62 WHEN 7393 THEN (num*3)+63 WHEN 8024 THEN (num*3)+64 WHEN 7413 THEN (num*3)+65 WHEN 7394 THEN (num*3)+66 WHEN 7399 THEN (num*3)+67 WHEN 7408 THEN (num*3)+68 WHEN 7407 THEN (num*3)+69 WHEN 5738 THEN (num*3)+70 WHEN 5107 THEN (num*3)+71 WHEN 7939 THEN (num*3)+72 WHEN 6647 THEN (num*3)+73 END,numErr153a