\$query = "SELECT h.hid, h.title, h.lid, h.seotitle AS seohot, l.seotitle AS seoloc FROM #__res_hotels h"\."\n LEFT JOIN #__res_locations l ON l.lid=h.lid"."\n WHERE h.hid='".$elid."' AND h.published = '1'";$hotel = $database->loadRow();
$database->setQuery($query, '#__', 1, 0);