Res:1
SELECT DISTINCT p.* FROM wp_posts AS p WHERE p.ID IN ( SELECT post_id FROM wp_postmeta WHERE (meta_key = 'featured' AND meta_value = 'Yes') GROUP BY post_id HAVING count(*) = 1) AND p.post_status = 'publish' AND post_type = 'post' ORDER BY RAND() LIMIT 1
Tested & Approved
Mandalai Hotel / Koh Phangan, Thailand
The value of the hotel definitely lies in it’s location. The hotel is situated in a very quiet fishermen village. Having breakfast overlooking the ocean comes close to paradise.
La Maison Pujol / Carcassonne, France
Ace Hotel / Palm Springs, USA
Citizen M / Glasgow, Scotland
At Pingnakorn / Chiang Mai, Thailand
Hotel Cocoon / Salvador Bahia, Brasil
Veranda High Resort/ Chiang Mai, Thailand
Daddy Long Legs / Cape Town, South-Africa
Luxx XL / Bangkok, Thailand
Pantone Hotel / Brussels, Belgium
Pod Up North / Wisconsin, USA
Bab Hotel / Marrakesh, Morocco
Room Mate Carlos / Buenos Aires, Argentina
Hotel Amano / Berlin, Germany
Lamai Wanta / Koh Samui, Thailand