Custom SQL query

Appointed_Third_Parties

Period, MLR_No, Licensee_Name_Eng, Licensee_Name_Chi, Hotline, Third_Party_Eng, Third_Party_Chi, Third_Party_Addr_Eng, Third_Party_Addr_Chi...

Many rows

companies

crno, companynames, timestamp, _type, 公司編號:, 公司名稱:, 公司類別:, 成立日期:, 公司現況:...

Many rows

companiesnames

crno, effectivedate, name, namelang

Many rows

conviction_record

Month_Year, Comp_Name_Eng, Comp_Name_Chi, Breach_Type, Fine

256 rows

convictioncodes

breachcode, breachdescription

11 rows

crhkraw

crno, companynames, timestamp, _type, 公司編號:, 公司名稱:, 公司類別:, 成立日期:, 公司現況:...

Many rows

licensees

Licence No.(牌照編號), Name of TCSP Licensee in English(持牌人的英文姓名/名稱), Name of TCSP Licensee in Chinese(持牌人的中文姓名/名稱), Business Address(營業地址), Remarks in English(英文備註), Remarks in Chinese(中文備註)

7,210 rows

ml_licensees

MLR_No, ML_Lic_No, Period, Name_Eng, Name_Chi, Expiry_Date, Remarks

2,450 rows

ml_list1

MLR_No, Period, Name_Eng, Name_Chi

160 rows

ml_list2

MLR_No, Period, Name_Eng, Name_Chi, Expiry_Date, Eng_Remarks, Chi_Remarks

2,904 rows

ml_list3

MLR_No, Period, Name_Eng, Name_Chi, Remarks

592 rows

msos

Name of Licensee (English), Name of Licensee (Chinese), Branch Name (English), Branch Name (Chinese), Address (English only), Address Type (English), Address Type (Chinese), As at (Date)

Many rows

replace_name

Seq, CR_No, Comp_Name_Eng, Comp_Name_Chi, Replaced_Name_Eng, Replaced_Name_Chi, Replaced_Eff_date

Many rows

stat_name

Seq, Comp_Name_Eng, Comp_Name_Chi, CR_No, Direction_Issue_Date

25 rows

... and 10 hidden tables

Views