SELECT * FROM `tbl_apply` left join `tbl_activitie` on `tbl_apply`.`activitie_id` = `tbl_activitie`.`id` where `mid` = '100' AND `tbl_apply`.`id` = ''
Array ( [0] => 294 [id] => 294 [1] => 100 [mid] => 100 [2] => 0 [cid] => 0 [3] => [type] => [4] => 10 [rank] => 10 [5] => 1 [status] => 1 [6] => [temp_post] => [7] => General Meeting (30 Sep 2016) [name_hk] => General Meeting (30 Sep 2016) [8] => General Meeting (30 Sep 2016) [name_cn] => General Meeting (30 Sep 2016) [9] => General Meeting (30 Sep 2016) [name_en] => General Meeting (30 Sep 2016) [10] => [go_url_hk] => [11] => [go_url_cn] => [12] => [go_url_en] => [13] => [url_input_hk] => [14] => [url_input_cn] => [15] => [url_input_en] => [16] => [content_hk] => [17] => [content_cn] => [18] => [content_en] => [19] => 0 [pub_fm] => 0 [20] => 0 [pub_to] => 0 [21] => 2016-10-20 19:46:20 [date_crt] => 2016-10-20 19:46:20 [22] => 0 [date_crt_active] => 0 [23] => 2017-11-22 16:49:29 [date_mod] => 2017-11-22 16:49:29 [24] => 2016-09-30 00:00:00 [date_act] => 2016-09-30 00:00:00 [25] => 5 [create_by] => 5 [26] => 5 [mod_by] => 5 [27] => 0 [mod_version] => 0 [28] => 0 [mod_lock] => 0 [29] => 0 [mod_lock_exp] => 0 [30] => 0 [access] => 0 [31] => no [share] => no [32] => 0 [hits] => 0 [33] => t2c [wordc_hk] => t2c [34] => t2c [wordc_cn] => t2c [35] => [wordc_en] => [36] => [url_hk] => [37] => [url_cn] => [38] => [url_en] => [39] => 0 [url_pop] => 0 [40] => [thumb_hk] => [41] => [thumb_cn] => [42] => [thumb_en] => [43] => 0 [sphoto] => 0 [44] => 0 [sattach] => 0 [45] => 1,4,5 [membership_id] => 1,4,5 [46] => [time] => [47] => 0 [fee] => 0 [48] => 0 [places] => 0 [49] => [address_hk] => [50] => [address_cn] => [51] => [address_en] => [52] => 1 [sns_share] => 1 [53] => 0 [youth_share] => 0 [54] => 0 [look] => 0 [55] => 0 [file_id] => 0 [56] => [repeat_date] => [57] => 1 [banner_display_nr] => 1 )
會員大會
2016-12-16 2016 Annual General Meeting - Reservation
2016-12-16 2016 Annual General Meeting Dinner - Reservation
2016-12-16 2016 會員大會 (只供境外會員閱覽)
2016-12-14 SCAA Council Election 2016 – Ballot Paper
2016-11-24 2016 Annual General Meeting - Notice
2016-10-20 2016 Annual General Meeting and Nomination to Council Election