Book Thailand Cheap Green Fees Online | Discount Tee Times
DB Connect Element->get_featured_course:
SELECT
get_pic_url(GCD.Golf_Course_Green,'small') as PIC_GREEN,
get_pic_url(GCD.Golf_Course_Fairway,'small') as PIC_FAIRWAY,
get_pic_url(GCD.Golf_Course_Clubhouse,'small') as PIC_CLUBHOUSE,
GCR.wd_contract_rate, GCR.we_contract_rate, GCR.we_walkin_rate, GCR.wd_walkin_rate, LCT.Location_Name,
GCD.Golf_Course_Name, GCD.Golf_Course_ID, GCD.tgolfers_adtn_rate, GCD.tgolfers_desc_th, GCD.tgolfers_desc_en,
GCD.Golf_Course_BestImg, GCD.tgolfers_name_th, GCD.tgolfers_hotdeal, GCD.not_less_than_walkin
FROM golf_course_data GCD
LEFT JOIN main_location LCT ON LCT.Location_ID = GCD.Golf_Course_main_location_ID
LEFT JOIN golf_course_rates GCR ON GCR.Golf_Course_ID = GCD.Golf_Course_ID
WHERE (GCD.tgolfers_featured) AND (GCD.tgolfers_course) AND (GCR.active)
AND (GCR.valid_from <= '2025-10-28') AND ('2025-10-28' <= GCR.valid_to)
ORDER BY GCD.tgolfers_hotdeal DESC
LIMIT 10