SELECT id,diametre,largeur,`offset`,marque,modele,UPPER(finition) as finition,forged,winter, (CASE WHEN jantes.marque IN ('OZ', 'MSW', 'KW', 'ST') and RC=0 THEN GREATEST(ROUND((prix-(prix*((RA/(100/18))/100))+livraison),2), prix * 0.90) WHEN RC > 0 THEN prix * (1 - (RC / 100)) ELSE prix - ((prix - PA) * 0.18) END)+livraison AS prix_client, prix+livraison AS prix_catalogue ,PA,GROUP_CONCAT(DISTINCT(diametre) SEPARATOR '|') as sizes FROM jantes WHERE (pcd = '5x120') AND (`offset` >= '20' AND `offset` <= '47') AND (diametre>='18') AND (diametre<='20') AND (restriction='' OR restriction LIKE '%BMW%') AND (restriction='' OR restriction LIKE '%BMW%') AND (prix !='0') GROUP BY marque,modele,finition ORDER by prix_client LIMIT 0, 48