Información General error1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group by p.nombre order by m.orden asc' at line 4 sql= select p.*, m.*, p.maps from modelos m join pais p join ciudad c on (m.idciudad = c.id or m.idpais = p.id ) and m.id_prod = group by p.nombre order by m.orden asc