| Check In | 10:00 pm |
|---|---|
| Check Out | 6:00 pm |
WordPress database error: [Unknown column '10km' in 'having clause']
SELECT wpmd_posts.*,( 6371 * acos( cos( radians(22.653096) ) * cos( radians( mt1.meta_value ) ) *
cos( radians( mt2.meta_value ) - radians(92.196774) ) + sin( radians(22.653096) ) *
sin( radians( mt1.meta_value ) ) ) ) AS distance
FROM wpmd_posts , wpmd_postmeta as mt1,wpmd_postmeta as mt2
WHERE (1=1) and wpmd_posts.ID = mt1.post_id
and wpmd_posts.ID=mt2.post_id
AND mt1.meta_key = 'map_lat'
and mt2.meta_key = 'map_lng'
and wpmd_posts.ID !=13586
AND wpmd_posts.post_status = 'publish'
AND wpmd_posts.post_type = 'st_hotel'
AND wpmd_posts.post_date < NOW()
GROUP BY wpmd_posts.ID HAVING distance<10km
ORDER BY distance ASC
LIMIT 0,4
