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 volume!=4  AND produit IN(0,7663,7783,7782,7368,6667,6958,7364,7199,7367,7361,6096,7365,6668,7202,7371,7519,7233,7373,7200,7673,7230,6331,7360,6957,7510,7762,6320,6985,6923,6956,6332,6101,6052,5824,6919,7118,7198,6181,6942,6941,7021,6311)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%56%'ORDER BY CASE produit WHEN 7663 THEN (num*2)+1 WHEN 7783 THEN (num*2)+2 WHEN 7782 THEN (num*2)+3 WHEN 7368 THEN (num*2)+4 WHEN 6667 THEN (num*2)+5 WHEN 6958 THEN (num*2)+6 WHEN 7364 THEN (num*2)+7 WHEN 7199 THEN (num*2)+8 WHEN 7367 THEN (num*2)+9 WHEN 7361 THEN (num*2)+10 WHEN 6096 THEN (num*2)+11 WHEN 7365 THEN (num*2)+12 WHEN 6668 THEN (num*2)+13 WHEN 7202 THEN (num*2)+14 WHEN 7371 THEN (num*2)+15 WHEN 7519 THEN (num*2)+16 WHEN 7233 THEN (num*2)+17 WHEN 7373 THEN (num*2)+18 WHEN 7200 THEN (num*2)+19 WHEN 7673 THEN (num*2)+20 WHEN 7230 THEN (num*2)+21 WHEN 6331 THEN (num*2)+22 WHEN 7360 THEN (num*2)+23 WHEN 6957 THEN (num*2)+24 WHEN 7510 THEN (num*2)+25 WHEN 7762 THEN (num*2)+26 WHEN 6320 THEN (num*2)+27 WHEN 6985 THEN (num*2)+28 WHEN 6923 THEN (num*2)+29 WHEN 6956 THEN (num*2)+30 WHEN 6332 THEN (num*2)+31 WHEN 6101 THEN (num*2)+32 WHEN 6052 THEN (num*2)+33 WHEN 5824 THEN (num*2)+34 WHEN 6919 THEN (num*2)+35 WHEN 7118 THEN (num*2)+36 WHEN 7198 THEN (num*2)+37 WHEN 6181 THEN (num*2)+38 WHEN 6942 THEN (num*2)+39 WHEN 6941 THEN (num*2)+40 WHEN 7021 THEN (num*2)+41 WHEN 6311 THEN (num*2)+42 END,numErr153a