SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=2 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,7868,3479,6655,6723,9278,5190,9289,9525,4149,9230,6680,9270,9268,9276,9275,7830,4143,9404,4626,4147,4250,8311,6947,8963,6713,7732,7826,7733,6709,6894,4146,7889,8312,9038,7748,7747,8964,3140,2610,8954,8948,4591,9241,3855,7133,5760,2598,8249,8297,6157,8245,8439,8302,4155,8456,5149,6169,9039,8660,4663,2609,4432,8476,7574,6787,8484,7677,3004,8937,6731,5831,6694,3846,6970,7667,8955,7890,3027,6706,7669,7680,8352,7668,4667,4622,8246,4678,7715,7729,7716,4266,4587,8414,8486,7753,6708,3179,7576,7758,6682,7682,7665,7825,6286,6949,8437,6705,4158,7717,8470,7671,8257,6690,4597,3861,7639,8247,7690,5182,7683,8420,8328,3918,5798,2602,8295,3028,7573,8418,8298,8417,5816,7644,8488,8438,6650,3254,8423,7828,6691,7581,7577,8357,8487,8515,6688,7643,8424,4612,8422,5178,7642,8425,7829,8516,6692,3362,7870,5759,7730,7903,8485,6786,9088)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7868 THEN (num*6)+1 WHEN 3479 THEN (num*6)+2 WHEN 6655 THEN (num*6)+3 WHEN 6723 THEN (num*6)+4 WHEN 9278 THEN (num*6)+5 WHEN 5190 THEN (num*6)+6 WHEN 9289 THEN (num*6)+7 WHEN 9525 THEN (num*6)+8 WHEN 4149 THEN (num*6)+9 WHEN 9230 THEN (num*6)+10 WHEN 6680 THEN (num*6)+11 WHEN 9270 THEN (num*6)+12 WHEN 9268 THEN (num*6)+13 WHEN 9276 THEN (num*6)+14 WHEN 9275 THEN (num*6)+15 WHEN 7830 THEN (num*6)+16 WHEN 4143 THEN (num*6)+17 WHEN 9404 THEN (num*6)+18 WHEN 4626 THEN (num*6)+19 WHEN 4147 THEN (num*6)+20 WHEN 4250 THEN (num*6)+21 WHEN 8311 THEN (num*6)+22 WHEN 6947 THEN (num*6)+23 WHEN 8963 THEN (num*6)+24 WHEN 6713 THEN (num*6)+25 WHEN 7732 THEN (num*6)+26 WHEN 7826 THEN (num*6)+27 WHEN 7733 THEN (num*6)+28 WHEN 6709 THEN (num*6)+29 WHEN 6894 THEN (num*6)+30 WHEN 4146 THEN (num*6)+31 WHEN 7889 THEN (num*6)+32 WHEN 8312 THEN (num*6)+33 WHEN 9038 THEN (num*6)+34 WHEN 7748 THEN (num*6)+35 WHEN 7747 THEN (num*6)+36 WHEN 8964 THEN (num*6)+37 WHEN 3140 THEN (num*6)+38 WHEN 2610 THEN (num*6)+39 WHEN 8954 THEN (num*6)+40 WHEN 8948 THEN (num*6)+41 WHEN 4591 THEN (num*6)+42 WHEN 9241 THEN (num*6)+43 WHEN 3855 THEN (num*6)+44 WHEN 7133 THEN (num*6)+45 WHEN 5760 THEN (num*6)+46 WHEN 2598 THEN (num*6)+47 WHEN 8249 THEN (num*6)+48 WHEN 8297 THEN (num*6)+49 WHEN 6157 THEN (num*6)+50 WHEN 8245 THEN (num*6)+51 WHEN 8439 THEN (num*6)+52 WHEN 8302 THEN (num*6)+53 WHEN 4155 THEN (num*6)+54 WHEN 8456 THEN (num*6)+55 WHEN 5149 THEN (num*6)+56 WHEN 6169 THEN (num*6)+57 WHEN 9039 THEN (num*6)+58 WHEN 8660 THEN (num*6)+59 WHEN 4663 THEN (num*6)+60 WHEN 2609 THEN (num*6)+61 WHEN 4432 THEN (num*6)+62 WHEN 8476 THEN (num*6)+63 WHEN 7574 THEN (num*6)+64 WHEN 6787 THEN (num*6)+65 WHEN 8484 THEN (num*6)+66 WHEN 7677 THEN (num*6)+67 WHEN 3004 THEN (num*6)+68 WHEN 8937 THEN (num*6)+69 WHEN 6731 THEN (num*6)+70 WHEN 5831 THEN (num*6)+71 WHEN 6694 THEN (num*6)+72 WHEN 3846 THEN (num*6)+73 WHEN 6970 THEN (num*6)+74 WHEN 7667 THEN (num*6)+75 WHEN 8955 THEN (num*6)+76 WHEN 7890 THEN (num*6)+77 WHEN 3027 THEN (num*6)+78 WHEN 6706 THEN (num*6)+79 WHEN 7669 THEN (num*6)+80 WHEN 7680 THEN (num*6)+81 WHEN 8352 THEN (num*6)+82 WHEN 7668 THEN (num*6)+83 WHEN 4667 THEN (num*6)+84 WHEN 4622 THEN (num*6)+85 WHEN 8246 THEN (num*6)+86 WHEN 4678 THEN (num*6)+87 WHEN 7715 THEN (num*6)+88 WHEN 7729 THEN (num*6)+89 WHEN 7716 THEN (num*6)+90 WHEN 4266 THEN (num*6)+91 WHEN 4587 THEN (num*6)+92 WHEN 8414 THEN (num*6)+93 WHEN 8486 THEN (num*6)+94 WHEN 7753 THEN (num*6)+95 WHEN 6708 THEN (num*6)+96 WHEN 3179 THEN (num*6)+97 WHEN 7576 THEN (num*6)+98 WHEN 7758 THEN (num*6)+99 WHEN 6682 THEN (num*6)+100 WHEN 7682 THEN (num*6)+101 WHEN 7665 THEN (num*6)+102 WHEN 7825 THEN (num*6)+103 WHEN 6286 THEN (num*6)+104 WHEN 6949 THEN (num*6)+105 WHEN 8437 THEN (num*6)+106 WHEN 6705 THEN (num*6)+107 WHEN 4158 THEN (num*6)+108 WHEN 7717 THEN (num*6)+109 WHEN 8470 THEN (num*6)+110 WHEN 7671 THEN (num*6)+111 WHEN 8257 THEN (num*6)+112 WHEN 6690 THEN (num*6)+113 WHEN 4597 THEN (num*6)+114 WHEN 3861 THEN (num*6)+115 WHEN 7639 THEN (num*6)+116 WHEN 8247 THEN (num*6)+117 WHEN 7690 THEN (num*6)+118 WHEN 5182 THEN (num*6)+119 WHEN 7683 THEN (num*6)+120 WHEN 8420 THEN (num*6)+121 WHEN 8328 THEN (num*6)+122 WHEN 3918 THEN (num*6)+123 WHEN 5798 THEN (num*6)+124 WHEN 2602 THEN (num*6)+125 WHEN 8295 THEN (num*6)+126 WHEN 3028 THEN (num*6)+127 WHEN 7573 THEN (num*6)+128 WHEN 8418 THEN (num*6)+129 WHEN 8298 THEN (num*6)+130 WHEN 8417 THEN (num*6)+131 WHEN 5816 THEN (num*6)+132 WHEN 7644 THEN (num*6)+133 WHEN 8488 THEN (num*6)+134 WHEN 8438 THEN (num*6)+135 WHEN 6650 THEN (num*6)+136 WHEN 3254 THEN (num*6)+137 WHEN 8423 THEN (num*6)+138 WHEN 7828 THEN (num*6)+139 WHEN 6691 THEN (num*6)+140 WHEN 7581 THEN (num*6)+141 WHEN 7577 THEN (num*6)+142 WHEN 8357 THEN (num*6)+143 WHEN 8487 THEN (num*6)+144 WHEN 8515 THEN (num*6)+145 WHEN 6688 THEN (num*6)+146 WHEN 7643 THEN (num*6)+147 WHEN 8424 THEN (num*6)+148 WHEN 4612 THEN (num*6)+149 WHEN 8422 THEN (num*6)+150 WHEN 5178 THEN (num*6)+151 WHEN 7642 THEN (num*6)+152 WHEN 8425 THEN (num*6)+153 WHEN 7829 THEN (num*6)+154 WHEN 8516 THEN (num*6)+155 WHEN 6692 THEN (num*6)+156 WHEN 3362 THEN (num*6)+157 WHEN 7870 THEN (num*6)+158 WHEN 5759 THEN (num*6)+159 WHEN 7730 THEN (num*6)+160 WHEN 7903 THEN (num*6)+161 WHEN 8485 THEN (num*6)+162 WHEN 6786 THEN (num*6)+163 WHEN 9088 THEN (num*6)+164 END,numErr153a