SELECT 
	hor_resort.resort_1 AS RESORT,	
	hor_city.city_1 AS CITY,
	hor_state.state_1 AS STATE,
	hor_tipove_pansion.pans_name_1 AS PANSION_NAME,
  hor_hotel.id,
  hor_hotel.hotel_1,
	hor_hotel.hotel_stars,
	hor_hotel.razpolojenie_1,	
	hor_hotel.date_added
FROM
  hor_hotel
	LEFT OUTER JOIN hor_city ON (hor_hotel.id_city = hor_city.id )
  LEFT OUTER JOIN hor_resort ON (hor_hotel.id_resort = hor_resort.id)
  LEFT OUTER JOIN hor_state ON (hor_resort.id_state = hor_state.id)
  LEFT OUTER JOIN hor_tipove_pansion ON (hor_hotel.id_tipove_pansion = hor_tipove_pansion.id)
ORDER BY hor_hotel.id DESC
LIMIT 20