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