SELECT p.id , m.nombre as marca, CONCAT( mo.nombre,CONCAT(' ', p.version)) as modelo, p.precio, p.anio, p.km, pi.combustible, ip.idimg FROM mc_productos p INNER JOIN mc_productosxidioma pi ON (p.id = pi.id_producto) INNER JOIN mc_imagenxproducto ip ON (p.id = ip.idprod) INNER JOIN mc_marcas m on (m.id = p.id_marca)  INNER JOIN mc_modelos mo on (mo.id = p.id_modelo)  WHERE pi.idioma = 'fr' AND p.destacado=1 GROUP BY p.id ORDER BY rand() LIMIT 0,2