SELECT l.*,c.*,h.* FROM tbl_hotels_location AS l, tbl_hotels_country AS c,tbl_hotels AS h WHERE c.count_id=l.count_id AND l.hl_id=h.hl_id AND c.count_id=1 AND l.hl_id=1 AND h.banner <> '' ORDER BY h.ordered_by
Few countries in the world offer the kind of fascinating intrigue that Cambodia does. The country is emerging into an international tourist destination, the number and quality of hotels is increasing rapidly. Rural home stays, beach side bungalows and small boutique hotels offer a nice change from the traditional hotels which dominate the accommodation scene. If you are seeking a true 4 or 5 star resorts, Siem Reap, Phnom Penh and Sihanouville are great destinations.