The query you were trying to run failed, the server gave the following reason:

Unknown column 'destination_id' in 'from clause'

SELECT hotels.hotel_id, hotels.title, CONCAT('http://www.hotels.tv/', destinations.url, '/', hotels.url, '/') AS url, hotels.stars, hotels.short_description, destinations.title AS destination FROM hotels LEFT JOIN destinations USING (destination_id) WHERE (hotels.active > 0) AND (hotels.agent_id = 1023) ORDER BY hotels.title ASC