"SELECT id, ship, modelo, c.caracteristicas AS caracteristicas FROM barcos AS bLEFT JOIN barcos_caracteristicas AS c ON b.id = c.idWHERE b.ship LIKE '$variable'";