SELECT DISTINCT p.id_movil, min(p.precio) AS precio, p.disponible, img.img AS img, img.descripcion AS texto_alt, mv.web_movil, mv.id_movil,
CONCAT( mc.nombre, ' ', mv.nombre) AS nombre_movil,
GROUP_CONCAT( DISTINCT IFNULL( com.nombre, 'Libre' ) ) AS compania,
GROUP_CONCAT( DISTINCT CAST( CONCAT( i.id_icono, '*', i.nombre ) AS CHAR ) SEPARATOR '|' ) AS iconos
FROM productos p
LEFT JOIN moviles mv ON p.id_movil = mv.id_movil
LEFT JOIN marcas mc ON mv.id_marca = mc.id_marca
LEFT JOIN moviles_imagenes img ON (mv.id_movil = img.id_movil AND img.peque='s')
LEFT JOIN companias com ON p.id_compania = com.id_compania
LEFT JOIN moviles_iconos mi ON mi.id_movil = mv.id_movil
LEFT JOIN iconos i ON mi.id_icono = i.id_icono
LEFT JOIN modalidades moda ON p.id_modalidad=moda.id_modalidad
WHERE p.id_movil <>0
AND p.borrado='n'
AND activo = 's'
GROUP BY p.id_movil ORDER BY precio Array
(
[comprarunmovil] => Array
(
[dominio] => www
)
[filtros] => Array
(
[orden] => precio
[mostrar] => 10
)
)
Bluetooth
Cámara VGA
Reproductor Mp3
Graba vídeo
Cuatribanda
Tarjeta de memoria
3G
Radio
