golf_course_datails.phpp->get_gc_data: SELECT LCT.Location_Name, LCT.location_name_th, LCT.Location_ID, thai_holiday('2024-04-29') as HOLIDAY_TH, get_tg_trans_cost(LCT.Location_ID) as TRANS_COST, GCD.* FROM golf_course_data GCD LEFT JOIN main_location LCT ON LCT.Location_ID = GCD.Golf_Course_main_location_ID WHERE (GCD.Golf_Course_ID = "62") may_like_course.php->may_like_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, SUBSTRING(GCD.tgolfers_desc_th, 1, 560) as tgolfers_desc_th, SUBSTRING(GCD.tgolfers_desc_en, 1, 280) as tgolfers_desc_en, GCD.Golf_Course_BestImg, GCD.tgolfers_name_th, GCD.tgolfers_hotdeal 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_course) AND (GCR.active) AND (GCR.valid_from <= '2024-04-29') AND ('2024-04-29' <= GCR.valid_to) AND (GCD.Golf_Course_main_location_ID IN (15,16)) ORDER BY RAND() LIMIT 4