SELECT * FROM `tbl_apply` left join `tbl_activitie` on `tbl_apply`.`activitie_id` = `tbl_activitie`.`id` where `mid` = '113' AND `tbl_apply`.`id` = '493'
Array ( [0] => 809 [id] => 809 [1] => 113 [mid] => 113 [2] => 0 [cid] => 0 [3] => [type] => [4] => 6 [rank] => 6 [5] => 1 [status] => 1 [6] => [temp_post] => [7] => Diamond Presentation & Jewellery Workshop (20 Oct 2018) [name_hk] => Diamond Presentation & Jewellery Workshop (20 Oct 2018) [8] => Diamond Presentation & Jewellery Workshop (20 Oct 2018) [name_cn] => Diamond Presentation & Jewellery Workshop (20 Oct 2018) [9] => Diamond Presentation & Jewellery Workshop (20 Oct 2018) [name_en] => Diamond Presentation & Jewellery Workshop (20 Oct 2018) [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] =>

Registrations are made on a first-come, first-served basis and
priority shall be given to SCAA Members and Affiliates. Successful applicants would receive an email confirmation shortly.

[content_hk] =>

Registrations are made on a first-come, first-served basis and
priority shall be given to SCAA Members and Affiliates. Successful applicants would receive an email confirmation shortly.

[17] =>

Registrations are made on a first-come, first-served basis and
priority shall be given to SCAA Members and Affiliates. Successful applicants would receive an email confirmation shortly.

[content_cn] =>

Registrations are made on a first-come, first-served basis and
priority shall be given to SCAA Members and Affiliates. Successful applicants would receive an email confirmation shortly.

[18] =>

Registrations are made on a first-come, first-served basis and
priority shall be given to SCAA Members and Affiliates. Successful applicants would receive an email confirmation shortly.

[content_en] =>

Registrations are made on a first-come, first-served basis and
priority shall be given to SCAA Members and Affiliates. Successful applicants would receive an email confirmation shortly.

[19] => 0 [pub_fm] => 0 [20] => 0 [pub_to] => 0 [21] => 2018-10-03 10:10:35 [date_crt] => 2018-10-03 10:10:35 [22] => 0 [date_crt_active] => 0 [23] => 2018-12-03 16:20:39 [date_mod] => 2018-12-03 16:20:39 [24] => 2018-10-20 00:00:00 [date_act] => 2018-10-20 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] => all,login,1,2,4,5,3,6,7 [membership_id] => all,login,1,2,4,5,3,6,7 [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 )
聯誼活動
Diamond Presentation & Jewellery Workshop (20 Oct 2018)

Registrations are made on a first-come, first-served basis and
priority shall be given to SCAA Members and Affiliates. Successful applicants would receive an email confirmation shortly.