Error Conexion:
SELECT * FROM tour_hoteles, hoteles WHERE tour_hoteles.idempresa = 38 AND tour_hoteles.idtour = 248 AND tour_hoteles.idhotel = hoteles.idhotel ORDER BY hoteles.nombrehotel;