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 = 1603)
ORDER BY
hotels.title ASC