SELECT SQL_CALC_FOUND_ROWS wp37_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp37_postmeta price_meta2 WHERE price_meta2.post_id=wp37_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-03-18:2027-03-18' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp37_postmeta price_meta3 WHERE price_meta3.post_id=wp37_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp37_posts
WHERE 1=1 AND wp37_posts.post_type = 'accommodation' AND ((wp37_posts.post_status = 'publish'))
GROUP BY wp37_posts.ID HAVING 1=1
ORDER BY RAND()
LIMIT 0, 4
All peaks below 6500m are free of climbing permit, just you need to buy trekking permit. Trek and climb any peak below 6500m including Mitre Peak 6010m, Kharut Peak 6444m, Pastore Peak 6209m, Liala Peak 6009m, Trango Tower and many in Hushe Valley and Nangma Valley.
