dbr.count always show 0 after filtering

(4 posts) (2 voices)

Tags:

No tags yet.

  1. jasmondluk, Member

    select 'dbr.export.options', 'orientation', 'landscape';
    select 'dbr.export.options', 'zoom_scale', 50;
    select 'dbr.export.options', 'autosize', 1;

    select 'DBR.text' as 'DBR.text', '大衆教室 (日出康城) Popular Learning Centre (LOHAS Park) - 2025 Feb - 2025 Feb' as 'concat(a.centername , \' - \',curmonth)';

    select 'dbr.tab', 'Per children';
    select 'dbr.tab', 'Per course enrollment';

    select 'dbr.css', '.nowrap {white-space:nowrap}';

    select 'dbr.resultclass', 'nowrap';

    select 'dbr.text', 'Enrolled student full list per children';

    select 'dbr.colstyle', 'O/S fee', '[color: red;]';

    select 'dbr.search', 1;
    select 'dbr.column.filter', 'First name', 'text';
    select 'dbr.column.filter', 'Last name', 'text';
    select 'dbr.column.filter', 'Course', 'text';
    select 'dbr.column.filter', 'Teacher', 'select';
    select 'dbr.column.filter', 'Grade', 'select';
    select 'dbr.column.filter', 'Contact', 'text';
    select 'dbr.column.filter', 'Language', 'text';
    select 'dbr.column.filter', 'Gender', 'select';
    select 'dbr.column.filter', 'Email', 'text';
    select 'dbr.column.filter', 'Remarks', 'text';
    select 'dbr.column.filter', 'ID', 'text';

    select 'dbr.colstyle', 'Class Day(s)', '[white-space:pre]';
    select 'dbr.colstyle', 'Remarks', '[white-space:pre-wrap;width: 300px;]';
    select 'dbr.colstyle', 'Course', '[white-space:pre-wrap;width: 50px;]';
    select 'dbr.colstyle', 'Sys Ref', '%d';

    select 'dbr.count', 'ID';

    select 'LOP250200033' as 'ID', 'Alison Hoiken' as 'First name', 'Kong' as 'Last name', '嘉諾撒聖心幼稚園' as 'School', 'C0001' as 'Course', 'K3' as 'Grade', 'Jessie Shek' as 'Teacher', '' as 'O/S fee', 'Mother:85265850085' as 'Contact', 'English' as 'Language', 'Female' as 'Gender', '2019-10-11' as 'Birthday', 'dbr.purehtml:bell_chung@hotmail.com' as 'Email', 'Flat LA, 50/F, Tower 1, The Capitol, Lohas Park' as 'Address', '
    ' as 'Remarks', 559649 as 'Sys Ref'
    union all
    select 'LOP250200046', 'Alyson', 'Lau', 'Victoria kindergarten ', 'C0001', 'K3', 'Jessie Shek', '', 'Mother:85267086227', 'English', 'Female', '2025-01-25', 'dbr.purehtml:tessiewong1127@gmail.com', '日出康城緻藍天5座3rb', '
    ', 561051
    union all
    select 'LOP250200056', 'Amos', 'Chan', '基督教宣道會宣基小學', 'C0102', 'P5', 'Jessie Shek', '-2095', 'Mother:85291326125', 'English', 'Male', '2024-02-25', 'dbr.purehtml:', '53/LD, Tower 1, The Capitol, LOHAS PARK ', '
    ', 563596
    union all
    select 'LOP250200027', 'Bo yi', 'Lau', '梁潔華小學', 'C0107
    M0108', 'P3', 'Jessie Shek/Priscilla Li', '', 'Mother:85262326322', 'English', 'Female', '2016-03-23', 'dbr.purehtml:', '康城峻瀅', '
    ', 559612
    union all
    select 'LOP250200038', 'Ching Man Emma', 'Shi', '仁愛堂田家炳小學', 'E0107', 'P5', 'Halley Ho', '', 'Mother:85261557852', 'English', 'Female', '2013-11-19', 'dbr.purehtml:ling_hui86@yahoo.com.hk', '首都3座30樓RD室', '
    ', 560861
    union all
    select 'LOP250200013', 'Ching Wah Mark', 'Ip', '北角官立小學', 'C0102', 'P4', 'Priscilla Li', '', 'Father:85292247752
    Mother:85292187343', 'English', 'Male', '2015-08-19', 'dbr.purehtml:dorisleehk@gmail.com', '日出康城', '
    ', 556889
    union all
    select 'LOP250200039', 'Ching Yan Evelyn', 'Ka', '景林天主教', 'C0107', 'P6', 'Jessie Shek', '', 'Mother:85296855477', 'English', 'Female', '2013-04-28', 'dbr.purehtml:', '首都5 座49LB', '
    ', 560879
    union all
    select 'LOP250200018', 'Ching Yin', 'So', '維多利亞國際幼稚園及幼兒園', 'C0001', 'K2', 'Halley Ho', '', 'Mother:85267764893', 'English', 'Male', '2020-02-18', 'dbr.purehtml:', '首都二座右翼39樓A室', '
    ', 557080
    union all
    select 'LOP250200051', 'Chloe Jing Nam', 'Ma', 'Evangel college', 'C0102', 'P2', 'Jessie Shek', '', 'Father:85297100861
    Mother:85292267226', 'Cantonese', 'Female', '2017-10-05', 'dbr.purehtml:kiddoolang@gmail.com', 'Flat RD, 18/F, The Capitol, Lohas Park', '
    ', 561094
    union all
    select 'LOP250200031', 'Chun Hei Edward', 'Luk', 'Shrewsbury International School Hong Kong', 'C0001', 'P1', 'Jessie Shek/Tommy Tsoi', '', 'Father:85295189701
    Mother:85293402139', 'English', 'Male', '2018-02-12', 'dbr.purehtml:kinki2130@gmail.com', 'Flat LA, 31/F, Tower 2, The Capitol, Lohas Park, Tseung Kwan O', '
    ', 559647
    union all
    select 'LOP250200014', 'Chun Yat', 'Lo', '香港南區官立小學', 'C0102
    E0110', 'P4', 'Jessie Shek/Priscilla Li', '666', 'Father:85265776420
    Mother:85269372338', 'English', 'Male', '2015-02-05', 'dbr.purehtml:', '日出康城首都', '
    ', 556890
    union all
    select 'LOP250200011', 'Hailey ', 'Cheng', 'Cannan Kindergarten ', 'C0001', 'K2', 'Jessie Shek', '', 'Mother:85291387011', 'English', 'Female', '2020-02-17', 'dbr.purehtml:', 'Tower 1A, 36B, Grand Montara, Lohas', '
    ', 556876
    union all
    select 'LOP250200003', 'Hardy', 'Lam', '仁愛堂田家炳小學', 'E0107', 'P2', 'Benny Leung/Jessie Shek', '', 'Mother:85295499936', 'Cantonese', 'Male', '2017-03-17', 'dbr.purehtml:', '日出康城首都1座46LD', '
    ', 556833
    union all
    select 'LOP250200002', 'Hayden', 'Lam', '仁愛堂田家炳小學', 'E0107', 'P3', 'Benny Leung/Kimmy Yau', '', 'Mother:85295499936', 'English', 'Male', '2016-01-23', 'dbr.purehtml:', '日出康城首都1座46LD', '
    ', 556830
    union all
    select 'LOP250200030', 'Hei Yan', 'Tsang', 'Spk', 'C0001', 'K1', 'Jessie Shek', '', 'Mother:85295554929', 'English', 'Female', '2020-05-15', 'dbr.purehtml:gube926@hotmail.com', 'Capital, Lohas park, tko ', '
    ', 559644
    union all
    select 'LOP250200019', 'Ho Ting, Ethan', 'Leung', '神召會德萃小學', 'C0102
    C0107', 'P4', 'Jessie Shek', '', 'Mother:85294937202', 'English', 'Male', '2015-12-14', 'dbr.purehtml:mm.auyeung@sjs.org.hk', '將軍澳日出康城首都五座43樓LA室', '
    ', 557082
    union all
    select 'LOP250200017', 'Hoi Ching', 'Chiu', '聖保羅男女中學附屬小學', 'E0110', 'P1', 'Kimmy Yau', '', 'Father:85292762104
    Mother:85298484819', 'English', 'Female', '2017-11-07', 'dbr.purehtml:tinoijcc@hotmail.com', 'Flat LA, 37/F, Block 8, Le Prime, Lohas Park, TKO, HK', '
    ', 557041
    union all
    select 'LOP250200028', 'Isabel Harper', 'Leung', 'Po Leung Kuk Camoes Tan Siu Lin Primary School ', 'C0107', 'P4', 'Zoe Leung', '', 'Mother:85294449794', 'English', 'Female', '2015-06-11', 'dbr.purehtml:neeekko@yahoo.com.hk', '日出康城首都', '
    ', 559628
    union all
    select 'LOP250200050', 'Jing Yan Megan', 'Ma', 'Evangel college', 'C0102', 'P3', 'Jessie Shek', '', 'Father:85297100861
    Mother:85292267226', 'English', 'Female', '2016-04-06', 'dbr.purehtml:kiddoolang@gmail.com', 'Flat RD, 18/F, The Capitol, Lohas Park', '
    ', 561086
    union all
    select 'LOP250200057', 'Lea', 'Wu', 'Diocesan Girls’ Junior School', 'C0102', 'P3', 'Jessie Shek', '-2428', 'Mother:85292378478
    Self:85255001820', 'English', 'Female', '2016-06-19', 'dbr.purehtml:davywu@hkbu.edu.hk', 'Flat D, 51/F, Tower 3A, Marini, Lohas Park', '
    ', 563690
    union all
    select 'LOP250200009', 'Man Ho Jayden', 'Cheng', 'Methodist School', 'C0107', 'P3', 'Jessie Shek', '', 'Mother:85291387011', 'English', 'Male', '2016-05-31', 'dbr.purehtml:', 'Tower 1A,36B, Grand Montara, LOHAS Park', '
    ', 556873
    union all
    select 'LOP250200021', 'Mason', 'Siu', 'Joystem', 'C0001', 'K1', 'Jessie Shek', '', 'Father:85293272496
    Mother:85261243318', 'English', 'Male', '2022-04-23', 'dbr.purehtml:alison.liu614@gmail.com', '日出康城首都2座69RD', '
    ', 557194
    union all
    select 'LOP250200049', 'Mia', 'Ou', 'Y.O.T Tin Ka Ping Primary School ', 'C0107
    M0108', 'P3', 'Priscilla Li', '', 'Mother:85295886346', 'English', 'Female', '2016-02-19', 'dbr.purehtml:', 'The Capitol of Lohas Park', '
    ', 561083
    union all
    select 'LOP250200005', 'Pak Kiu', 'Wong', '滬江小學', 'M0108', 'P4', 'Halley Ho/Tommy Tsoi', '', 'Mother:85293857021', 'English', 'Female', '2015-07-24', 'dbr.purehtml:leung_teresa@hotmail.com', 'Unit H, 16/F, Tower 3, The Beaumount, 8 Shek Kok Road, Tseung Kwan O', '
    ', 556856
    union all
    select 'LOP250200023', 'Sarah', 'Zhou', '香港培正小學', 'C0102
    C0107', 'P3', 'Jessie Shek/Jessie Shek/Zoe Leung', '', 'Mother:85296999226', 'English', 'Female', '2016-04-06', 'dbr.purehtml:emmalui0226@icloud.com', '將軍澳日出康城七期', '
    ', 557271
    union all
    select 'LOP250200024', 'Sharon ', 'Zhou', '香港培正小學', 'C0107', 'P1', 'Halley Ho/Jessie Shek', '', 'Mother:85296999226', 'English', 'Female', '2016-12-04', 'dbr.purehtml:emmalui0226@icloud.com', '將軍澳日出康城七期', '
    ', 557272
    union all
    select 'LOP250200059', 'Suet Ching', 'Tsang', 'St. Paul\'s Convent School (Primary Section)', 'C0107', 'P4', 'Zoe Leung', '-1945', 'Mother:85263506189', 'Cantonese', 'Female', '2025-02-20', 'dbr.purehtml:', '日出康城', '
    ', 563732
    union all
    select 'LOP250200058', 'Sunny', 'Yeung', '梁潔華小學', 'I0114', 'P3', 'Halley Ho/Jessie Shek/Kimmy Yau/Priscilla Li', '-2095', 'Mother:85291591068', 'Cantonese', 'Male', '2015-12-08', 'dbr.purehtml:', '日出康城首都3座59層LD', '
    ', 563701
    union all
    select 'LOP250200029', 'To Lam Luke', 'Ma', '學之園幼稚園', 'C0001', 'K3', 'Jessie Shek', '', 'Mother:85297033360', 'English', 'Male', '2019-05-28', 'dbr.purehtml:', '日出康城七期', '
    ', 559630
    union all
    select 'LOP250200026', 'Tsz Ching Tiana', 'Chan', 'Po Leung Kuk Camoes Tan Siu Lin Primary School ', 'C0107', 'P5', 'Jessie Shek/Zoe Leung', '', 'Mother:85293859382', 'English', 'Female', '2014-02-08', 'dbr.purehtml:', 'RA, 45/F, Tower 3, The Capitol, Lohas Park, TKO', '
    ', 559591
    union all
    select 'LOP250200037', 'Tsz Him ', 'Poon ', '香港培正小學', 'C0102
    C0107', 'P3', 'Jessie Shek/Jessie Shek/Priscilla Li', '-232', 'Mother:85293109231', 'English', 'Male', '2016-05-12', 'dbr.purehtml:jennifer_kkw@hotmail.com', 'Malibu ', '
    ', 560855
    union all
    select 'LOP250200052', 'Tsz Shun Truman', 'Chiu', 'Logos Academy (Primary)', 'C0102', 'P3', 'Jessie Shek', '', 'Father:85264157676
    Mother:85292487366', 'English', 'Male', '2015-12-19', 'dbr.purehtml:kammylf@gmail.com', 'Flat RA, 37/F, Tower 2, The Capitol of LOHAS Park, Tseung Kwan O, N.T. , HK', '
    ', 561104
    union all
    select 'LOP250200001', 'Tsz yuen Allie ', 'Tsang ', '香港真光中學幼稚園', 'C0001', 'K3', 'Jessie Shek', '', 'Father:85298442144
    Mother:85260775111', 'English', 'Female', '2019-03-04', 'dbr.purehtml:stepyklaw@yahoo.com.hk', 'Flat ra , 49/f, blk 2, the Capitol, Lohas Park ', '
    ', 554395
    union all
    select 'LOP250200055', 'Wah Hin', 'Wong', '基督教宣道會香港區豎聯會將軍澳宣道幼稚園', 'C0001', 'K3', 'Jessie Shek', '', 'Mother:85291310184', 'English', 'Male', '2019-07-02', 'dbr.purehtml:', '日出康城7期2B 座56樓F 室', '
    ', 563555
    union all
    select 'LOP250200042', 'Wai Jit', 'Suen ', '學之園幼稚園', 'C0001', 'K1', 'Jessie Shek', '', 'Mother:85292136945', 'English', 'Male', '2021-02-26', 'dbr.purehtml:keynatsang@gmail.com', '60A, Tower 1A, Grand Montara, Lohas Park, TKO', '
    ', 560934
    union all
    select 'LOP250200041', 'Wai Sze', 'Suen', '學之園幼稚園', 'C0001', 'K3', 'Halley Ho', '', 'Mother:85292136945', 'English', 'Female', '2019-01-30', 'dbr.purehtml:keynatsang@gmail.com', '60A, Tower 1A, Grand Montara, Lohas Park', '
    ', 560933
    union all
    select 'LOP250200015', 'Yan Shek Johnathan', 'Lau', '滬江小學', 'C0102
    E0107', 'P2', 'Jessie Shek/Jessie Shek/Zoe Leung', '308', 'Father:85262588774', 'English', 'Male', '2017-03-03', 'dbr.purehtml:', '日出康城首都6座26樓RA室', '
    ', 556893
    union all
    select 'LOP250200020', 'Yat Hei', 'Ma', '培正幼稚園', 'C0001', 'K1', 'Jessie Shek', '', 'Mother:85290866889', 'English', 'Male', '2020-09-26', 'dbr.purehtml:mayacheung107@yahoo.com.hk', '日出康城首都六座20樓RD室', '
    ', 557119
    union all
    select 'LOP250200004', 'Yuet Kiu Anjaylia', 'Chan', '聖保祿學校 (小學部)', 'C0107', 'P1', 'Halley Ho/Jessie Shek', '', 'Mother:85294954712', 'English', 'Female', '2018-02-15', 'dbr.purehtml:', '康城', '
    ', 556849
    union all
    select 'LOP250200045', 'Yui', 'Ng', 'Lam Tin Ling Liang kindergarten ', 'C0001', 'K2', 'Zoe Leung', '', 'Mother:85260365952', 'English', 'Female', '2020-04-02', 'dbr.purehtml:milkedith@gmail.com', 'Le prime. Lohas Park', '
    ', 561010
    union all
    select 'LOP250200048', '卓穎', '梁', '徳望幼稚園', 'C0001', 'K1', 'Jessie Shek', '-1638', 'Father:85298068416
    Mother:85261795042', 'English', 'Female', '2021-07-24', 'dbr.purehtml:teresa_ko_2005@hotmail.com', '康城', '
    ', 561060
    union all
    select 'LOP250200007', '博愷', '黃', '滬江維多利亞學校', 'C0102
    C0107', 'P1', 'Priscilla Li', '-1538', 'Mother:85260216912', 'English', 'Male', '2017-10-16', 'dbr.purehtml:kristalkeep@gmail.com', '日出康城', '
    ', 556866
    union all
    select 'LOP250200008', '博禹', '黃', '滬江維多利亞學校', 'C0102
    C0107', 'P4', 'Halley Ho/Priscilla Li', '-1538', 'Mother:85260216912', 'Cantonese', 'Male', '2015-04-26', 'dbr.purehtml:', '日出康城', '
    ', 556867
    union all
    select 'LOP250200036', '悅韻', '周', '觀塘浸信會彩明幼稚園', 'C0001', 'K1', 'Jessie Shek', '', 'Father:85263372363
    Mother:85261882992', 'English', 'Female', '2021-03-24', 'dbr.purehtml:daralamlam@gmail.com', '日出康城首都', '
    ', 560815
    union all
    select 'LOP250200034', '朗然', '盧', '保良局陸慶濤小學', 'C0102', 'P1', 'Jessie Shek', '', 'Mother:85295173049', 'English', 'Male', '2018-02-17', 'dbr.purehtml:', 'Lohas Park', '
    ', 560760
    union all
    select 'LOP250200016', '理鑫(Eddie)', '陳', 'Shrewsbury International School Hong Kong', 'E0110', 'P4', 'Kimmy Yau', '', 'Father:85296170208
    Mother:85296151006', 'English', 'Male', '2016-01-12', 'dbr.purehtml:xwjackiechen66@gmail.com', 'Flat RC 55/F Tower1 The Capitol Of Lohas Park', '
    ', 556900
    union all
    select 'LOP250200006', '藝愷', '程', '啟思小學', 'C0107', 'P1', 'Priscilla Li', '', 'Mother:85294809668', 'English', 'Male', '2018-03-14', 'dbr.purehtml:', 'Rm RA, Tower 3, Hemera, Lohas Park', '
    ', 556863
    union all
    select 'LOP250200035', '靖希', '盧', '保良局陸慶濤小學', 'C0102', 'P3', 'Kimmy Yau', '', 'Mother:85295173049', 'English', 'Female', '2016-07-04', 'dbr.purehtml:', 'Lohas Park', '
    ', 560763;

    select 'dbr.tab.next';

    select 'dbr.text', 'Per course enrollment';

    select 'dbr.colstyle', 'O/S fee', '[color: red;]';

    select 'dbr.search', 1;

    select 'dbr.subtitle', 'Enrolled Student List';

    select 'dbr.column.filter', 'Student', 'text';
    select 'dbr.column.filter', 'First name', 'text';
    select 'dbr.column.filter', 'Last name', 'text';
    select 'dbr.column.filter', 'Course', 'select';
    select 'dbr.column.filter', 'Schedule', 'select';
    select 'dbr.column.filter', 'Course name', 'text';
    select 'dbr.column.filter', 'Teacher', 'select';
    select 'dbr.column.filter', 'Level', 'select';
    select 'dbr.column.filter', 'Grade', 'select';
    select 'dbr.column.filter', 'Contact', 'text';
    select 'dbr.column.filter', 'Language', 'text';
    select 'dbr.column.filter', 'Gender', 'select';
    select 'dbr.column.filter', 'Email', 'text';
    select 'dbr.column.filter', 'Notes and remarks', 'text';
    select 'dbr.column.filter', 'ID', 'text';

    select 'dbr.colstyle', 'Class Day(s)', '[white-space:pre]';
    select 'dbr.colstyle', 'Notes and remarks', '[white-space:pre-line; width: 150px; max-width: 200px]';
    select 'dbr.colstyle', 'Contact', '[white-space:pre-line; max-width: 200px; ]';
    select 'dbr.colstyle', 'School', '[white-space:pre-line; min-width: 200px;]';

    select 'dbr.count', 'ID';

    select 'dbr.crosstab', '[Month]';

    select 'LOP250200003' as 'ID', 'Hardy Lam' as 'Student', 'Hardy' as 'First name', 'Lam(林昊傑)' as 'Last name', '2017-03-17' as 'dateofbirth', 'E0107' as 'Course', '樂思英文課程' as 'Course name', 'Weekly' as 'Schedule', '仁愛堂田家炳小學' as 'School', 'P2' as 'Grade', 'L1' as 'Level', '2025-02-08' as 'Enrolled on', '2025-02-15' as 'First class', '2025-03-08' as 'Final class', '' as 'O/S fee', 'Mother:85295499936' as 'Contact', 'Cantonese' as 'Language', 'Male' as 'Gender', 'dbr.purehtml:' as 'Email', '
    ' as 'Notes and remarks', '556833' as 'Sys Ref', 'Information for February (Latest schedule on top)' as '[Month]', 'Sat 10:00' as 'Class Day(s)', 'Benny Leung/Jessie Shek' as 'Teacher', '2' as 'Total Class', null as 'Makeup (From other month)', 1 as 'Attended', 615.0 as 'Standard fee', 665.0 as 'Net fee'
    union all
    select 'LOP250200002', 'Hayden Lam', 'Hayden', 'Lam(林昊然)', '2016-01-23', 'E0107', '樂思英文課程', 'Weekly', '仁愛堂田家炳小學', 'P3', 'L3', '2025-02-08', '2025-02-15', '2025-03-10', '', 'Mother:85295499936', 'English', 'Male', 'dbr.purehtml:', '
    ', '556830', 'Information for February (Latest schedule on top)', 'Mon 17:30
    Sat 14:30', 'Benny Leung/Kimmy Yau', '4', null, 1, 1230.0, 1280.0
    union all
    select 'LOP250200018', 'Ching Yin So', 'Ching Yin', 'So(蘇靖然)', '2020-02-18', 'C0001', '幼兒中文課程', 'Weekly', '維多利亞國際幼稚園及幼兒園', 'K2', 'L0', '2025-02-10', '2025-02-20', '2025-03-27', '', 'Mother:85267764893', 'English', 'Male', 'dbr.purehtml:', '
    ', '557080', 'Information for February (Latest schedule on top)', 'Thu 14:30', 'Halley Ho', '2', null, 1, 615.0, 648.33
    union all
    select 'LOP250200041', 'Wai Sze Suen', 'Wai Sze', 'Suen(孫蔚思)', '2019-01-30', 'C0001', '幼兒中文課程', 'Weekly', '學之園幼稚園', 'K3', 'L3', '2025-02-15', '2025-02-20', '2025-03-27', '', 'Mother:85292136945', 'English', 'Female', 'dbr.purehtml:keynatsang@gmail.com', '
    ', '560933', 'Information for February (Latest schedule on top)', 'Thu 10:00', 'Halley Ho', '2', null, 1, 615.0, 648.33
    union all
    select 'LOP250200008', '博禹 黃', '博禹', '黃(黃博禹)', '2015-04-26', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '滬江維多利亞學校', 'P4', 'L4', '2025-02-08', '2025-02-19', '2025-03-12', '', 'Mother:85260216912', 'Cantonese', 'Male', 'dbr.purehtml:', '
    ', '556867', 'Information for February (Latest schedule on top)', 'Wed 17:30', 'Halley Ho', '2', null, 1, 665.0, 715.0
    union all
    select 'LOP250200038', 'Ching Man Emma Shi', 'Ching Man Emma', 'Shi(施晴雯)', '2013-11-19', 'E0107', '樂思英文課程', 'Weekly', '仁愛堂田家炳小學', 'P5', 'L5', '2025-02-15', '2025-02-20', '2025-03-27', '', 'Mother:85261557852', 'English', 'Female', 'dbr.purehtml:ling_hui86@yahoo.com.hk', '
    ', '560861', 'Information for February (Latest schedule on top)', 'Thu 17:30', 'Halley Ho', '2', null, null, 615.0, 648.33
    union all
    select 'LOP250200004', 'Yuet Kiu Anjaylia Chan', 'Yuet Kiu Anjaylia', 'Chan(陳玥蕎)', '2018-02-15', 'C0107', '樂思中文課程', 'Weekly', '聖保祿學校 (小學部)', 'P1', 'L1', '2025-02-08', '2025-02-12', '2025-03-05', '', 'Mother:85294954712', 'English', 'Female', 'dbr.purehtml:', '
    ', '556849', 'Information for February (Latest schedule on top)', 'Wed 16:30', 'Halley Ho/Jessie Shek', '3', null, 2, 922.5, 997.5
    union all
    select 'LOP250200024', 'Sharon Zhou', 'Sharon ', 'Zhou(周卓盈)', '2016-12-04', 'C0107', '樂思中文課程', 'Weekly', '香港培正小學', 'P1', 'L1', '2025-02-12', '2025-02-12', '2025-03-26', '', 'Mother:85296999226', 'English', 'Female', 'dbr.purehtml:emmalui0226@icloud.com', '
    ', '557272', 'Information for February (Latest schedule on top)', 'Wed 16:30', 'Halley Ho/Jessie Shek', '3', null, 2, 922.71, 922.71
    union all
    select 'LOP250200058', 'Sunny Yeung', 'Sunny', 'Yeung(楊責聖)', '2015-12-08', 'I0114', '大考特訓班 (英作)', 'Weekly', '梁潔華小學', 'P3', 'L3', '2025-02-20', '2025-02-20', '2025-02-24', '-2095', 'Mother:85291591068', 'Cantonese', 'Male', 'dbr.purehtml:', '
    ', '563701', 'Information for February (Latest schedule on top)', 'Mon 15:30
    Mon 16:30
    Sun 10:30
    Sat 12:00
    Fri 16:00
    Thu 17:30', 'Halley Ho/Jessie Shek/Kimmy Yau/Priscilla Li', '6', null, null, 1995.0, 2095.0
    union all
    select 'LOP250200005', 'Pak Kiu Wong', 'Pak Kiu', 'Wong(黃柏翹)', '2015-07-24', 'M0108', '樂思數學課程(專科班)', 'Weekly', '滬江小學', 'P4', 'L4', '2025-02-08', '2025-02-13', '2025-03-27', '', 'Mother:85293857021', 'English', 'Female', 'dbr.purehtml:leung_teresa@hotmail.com', '
    ', '556856', 'Information for February (Latest schedule on top)', 'Thu 16:30', 'Halley Ho/Tommy Tsoi', '3', null, 2, 922.71, 965.57
    union all
    select 'LOP250200020', 'Yat Hei Ma', 'Yat Hei', 'Ma(馬一曦)', '2020-09-26', 'C0001', '幼兒中文課程', 'Weekly', '培正幼稚園', 'K1', 'L0', '2025-02-11', '2025-02-17', '2025-03-31', '', 'Mother:85290866889', 'English', 'Male', 'dbr.purehtml:mayacheung107@yahoo.com.hk', '
    ', '557119', 'Information for February (Latest schedule on top)', 'Mon 10:00', 'Jessie Shek', '2', null, 1, 615.14, 643.71
    union all
    select 'LOP250200021', 'Mason Siu', 'Mason', 'Siu(蕭子叡)', '2022-04-23', 'C0001', '幼兒中文課程', 'Weekly', 'Joystem', 'K1', 'L0', '2025-02-11', '2025-02-17', '2025-03-31', '', 'Father:85293272496
    Mother:85261243318', 'English', 'Male', 'dbr.purehtml:alison.liu614@gmail.com', '
    ', '557194', 'Information for February (Latest schedule on top)', 'Mon 16:30', 'Jessie Shek', '2', null, 1, 615.14, 643.71
    union all
    select 'LOP250200030', 'Hei Yan Tsang', 'Hei Yan', 'Tsang(曾晞茵)', '2020-05-15', 'C0001', '幼兒中文課程', 'Weekly', 'Spk', 'K1', 'L0', '2025-02-13', '2025-02-18', '2025-03-25', '', 'Mother:85295554929', 'English', 'Female', 'dbr.purehtml:gube926@hotmail.com', '
    ', '559644', 'Information for February (Latest schedule on top)', 'Tue 10:30', 'Jessie Shek', '2', null, 1, 615.0, 648.33
    union all
    select 'LOP250200036', '悅韻 周', '悅韻', '周(Jasmina)', '2021-03-24', 'C0001', '幼兒中文課程', 'Weekly', '觀塘浸信會彩明幼稚園', 'K1', 'L1', '2025-02-14', '2025-02-17', '2025-03-31', '', 'Father:85263372363
    Mother:85261882992', 'English', 'Female', 'dbr.purehtml:daralamlam@gmail.com', '
    ', '560815', 'Information for February (Latest schedule on top)', 'Fri 11:00
    Mon 16:30', 'Jessie Shek', '3', null, 1, 923.14, 643.71
    union all
    select 'LOP250200042', 'Wai Jit Suen ', 'Wai Jit', 'Suen (孫維哲)', '2021-02-26', 'C0001', '幼兒中文課程', 'Weekly', '學之園幼稚園', 'K1', 'L0', '2025-02-15', '2025-02-17', '2025-03-31', '', 'Mother:85292136945', 'English', 'Male', 'dbr.purehtml:keynatsang@gmail.com', '
    ', '560934', 'Information for February (Latest schedule on top)', 'Mon 10:00', 'Jessie Shek', '2', null, 1, 615.14, 643.71
    union all
    select 'LOP250200048', '卓穎 梁', '卓穎', '梁(Wing)', '2021-07-24', 'C0001', '幼兒中文課程', 'Weekly', '徳望幼稚園', 'K1', 'L1', '2025-02-17', '2025-02-24', '2025-03-26', '-1638', 'Father:85298068416
    Mother:85261795042', 'English', 'Female', 'dbr.purehtml:teresa_ko_2005@hotmail.com', '
    ', '561060', 'Information for February (Latest schedule on top)', 'Wed 10:00
    Mon 10:00', 'Jessie Shek', '2', null, null, 615.6, 327.6
    union all
    select 'LOP250200011', 'Hailey Cheng', 'Hailey ', 'Cheng(鄭心悅)', '2020-02-17', 'C0001', '幼兒中文課程', 'Weekly', 'Cannan Kindergarten ', 'K2', 'L1', '2025-02-08', '2025-02-11', '2025-03-25', '', 'Mother:85291387011', 'English', 'Female', 'dbr.purehtml:', '
    ', '556876', 'Information for February (Latest schedule on top)', 'Tue 15:30', 'Jessie Shek', '3', null, 2, 922.71, 922.71
    union all
    select 'LOP250200001', 'Tsz yuen Allie Tsang ', 'Tsz yuen Allie ', 'Tsang (曾子玹)', '2019-03-04', 'C0001', '幼兒中文課程', 'Weekly', '香港真光中學幼稚園', 'K3', 'L3', '2025-02-10', '2025-02-10', '2025-03-03', '', 'Father:85298442144
    Mother:85260775111', 'English', 'Female', 'dbr.purehtml:stepyklaw@yahoo.com.hk', '
    ', '554395', 'Information for February (Latest schedule on top)', 'Mon 14:30', 'Jessie Shek', '3', null, 2, 922.5, 997.5
    union all
    select 'LOP250200029', 'To Lam Luke Ma', 'To Lam Luke', 'Ma(馬道霖)', '2019-05-28', 'C0001', '幼兒中文課程', 'Weekly', '學之園幼稚園', 'K3', 'L3', '2025-02-13', '2025-02-21', '2025-03-28', '', 'Mother:85297033360', 'English', 'Male', 'dbr.purehtml:', '
    ', '559630', 'Information for February (Latest schedule on top)', 'Fri 15:30', 'Jessie Shek', '2', null, null, 615.0, 648.33
    union all
    select 'LOP250200033', 'Alison Hoiken Kong', 'Alison Hoiken', 'Kong( 江愷芹)', '2019-10-11', 'C0001', '幼兒中文課程', 'Weekly', '嘉諾撒聖心幼稚園', 'K3', 'L2', '2025-02-13', '2025-02-21', '2025-03-28', '', 'Mother:85265850085', 'English', 'Female', 'dbr.purehtml:bell_chung@hotmail.com', '
    ', '559649', 'Information for February (Latest schedule on top)', 'Fri 10:00', 'Jessie Shek', '2', null, null, 615.0, 615.0
    union all
    select 'LOP250200046', 'Alyson Lau', 'Alyson', 'Lau(劉稀雯)', '2025-01-25', 'C0001', '幼兒中文課程', 'Weekly', 'Victoria kindergarten ', 'K3', 'L3', '2025-02-19', '2025-02-26', '2025-03-26', '', 'Mother:85267086227', 'English', 'Female', 'dbr.purehtml:tessiewong1127@gmail.com', '
    ', '561051', 'Information for February (Latest schedule on top)', 'Wed 11:00', 'Jessie Shek', '1', null, null, 307.6, 327.6
    union all
    select 'LOP250200055', 'Wah Hin Wong', 'Wah Hin', 'Wong(王華軒)', '2019-07-02', 'C0001', '幼兒中文課程', 'Weekly', '基督教宣道會香港區豎聯會將軍澳宣道幼稚園', 'K3', 'L3', '2025-02-19', '2025-02-19', '2025-03-26', '', 'Mother:85291310184', 'English', 'Male', 'dbr.purehtml:', '
    ', '563555', 'Information for February (Latest schedule on top)', 'Wed 15:00', 'Jessie Shek', '2', null, 1, 615.0, 615.0
    union all
    select 'LOP250200034', '朗然 盧', '朗然', '盧', '2018-02-17', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '保良局陸慶濤小學', 'P1', 'L1', '2025-02-16', '2025-02-18', '2025-03-25', '', 'Mother:85295173049', 'English', 'Male', 'dbr.purehtml:', '
    ', '560760', 'Information for February (Latest schedule on top)', 'Tue 16:30', 'Jessie Shek', '2', null, 1, 665.0, 698.33
    union all
    select 'LOP250200051', 'Chloe Jing Nam Ma', 'Chloe Jing Nam', 'Ma(馬靖嵐)', '2017-10-05', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', 'Evangel college', 'P2', 'L2', '2025-02-17', '2025-02-18', '2025-03-25', '', 'Father:85297100861
    Mother:85292267226', 'Cantonese', 'Female', 'dbr.purehtml:kiddoolang@gmail.com', '
    ', '561094', 'Information for February (Latest schedule on top)', 'Tue 17:30', 'Jessie Shek', '2', null, 1, 665.0, 498.67
    union all
    select 'LOP250200050', 'Jing Yan Megan Ma', 'Jing Yan Megan', 'Ma(馬靖恩)', '2016-04-06', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', 'Evangel college', 'P3', 'L3', '2025-02-17', '2025-02-17', '2025-03-31', '', 'Father:85297100861
    Mother:85292267226', 'English', 'Female', 'dbr.purehtml:kiddoolang@gmail.com', '
    ', '561086', 'Information for February (Latest schedule on top)', 'Mon 17:30', 'Jessie Shek', '2', null, 1, 665.14, 494.29
    union all
    select 'LOP250200052', 'Tsz Shun Truman Chiu', 'Tsz Shun Truman', 'Chiu(趙釨愻)', '2015-12-19', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', 'Logos Academy (Primary)', 'P3', 'L3', '2025-02-17', '2025-02-22', '2025-03-31', '', 'Father:85264157676
    Mother:85292487366', 'English', 'Male', 'dbr.purehtml:kammylf@gmail.com', '
    ', '561104', 'Information for February (Latest schedule on top)', 'Mon 17:30', 'Jessie Shek', '2', null, null, 665.14, 693.71
    union all
    select 'LOP250200057', 'Lea Wu', 'Lea', 'Wu(胡清睿)', '2016-06-19', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', 'Diocesan Girls’ Junior School', 'P3', 'L3', '2025-02-20', '2025-02-22', '2025-03-31', '-2428', 'Mother:85292378478
    Self:85255001820', 'English', 'Female', 'dbr.purehtml:davywu@hkbu.edu.hk', '
    ', '563690', 'Information for February (Latest schedule on top)', 'Mon 17:30', 'Jessie Shek', '2', null, null, 665.14, 693.71
    union all
    select 'LOP250200019', 'Ho Ting, Ethan Leung', 'Ho Ting, Ethan', 'Leung(梁皓庭)', '2015-12-14', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '神召會德萃小學', 'P4', 'L3', '2025-02-10', '2025-02-21', '2025-03-28', '', 'Mother:85294937202', 'English', 'Male', 'dbr.purehtml:mm.auyeung@sjs.org.hk', '
    ', '557082', 'Information for February (Latest schedule on top)', 'Fri 17:30', 'Jessie Shek', '2', null, null, 665.0, 665.0
    union all
    select 'LOP250200056', 'Amos Chan', 'Amos', 'Chan(陳天貽)', '2024-02-25', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '基督教宣道會宣基小學', 'P5', 'L1', '2025-02-19', '2025-02-22', '2025-03-29', '-2095', 'Mother:85291326125', 'English', 'Male', 'dbr.purehtml:', '
    ', '563596', 'Information for February (Latest schedule on top)', 'Sat 15:30', 'Jessie Shek', '1', null, null, 332.5, 349.17
    union all
    select 'LOP250200009', 'Man Ho Jayden Cheng', 'Man Ho Jayden', 'Cheng(鄭文皓)', '2016-05-31', 'C0107', '樂思中文課程', 'Weekly', 'Methodist School', 'P3', 'L3', '2025-02-08', '2025-02-12', '2025-03-26', '', 'Mother:85291387011', 'English', 'Male', 'dbr.purehtml:', '
    ', '556873', 'Information for February (Latest schedule on top)', 'Wed 17:30', 'Jessie Shek', '3', null, 2, 922.71, 922.71
    union all
    select 'LOP250200023', 'Sarah Zhou', 'Sarah', 'Zhou(周倩瑜)', '2016-04-06', 'C0107', '樂思中文課程', 'Weekly', '香港培正小學', 'P3', 'L3', '2025-02-12', '2025-02-12', '2025-03-26', '', 'Mother:85296999226', 'English', 'Female', 'dbr.purehtml:emmalui0226@icloud.com', '
    ', '557271', 'Information for February (Latest schedule on top)', 'Wed 17:30', 'Jessie Shek', '3', null, 2, 922.71, 922.71
    union all
    select 'LOP250200027', 'Bo yi Lau', 'Bo yi', 'Lau(劉寶兒)', '2016-03-23', 'C0107', '樂思中文課程', 'Weekly', '梁潔華小學', 'P3', 'L1', '2025-02-12', '2025-02-22', '2025-03-29', '', 'Mother:85262326322', 'English', 'Female', 'dbr.purehtml:', '
    ', '559612', 'Information for February (Latest schedule on top)', 'Sat 14:30', 'Jessie Shek', '1', null, null, 307.5, 307.5
    union all
    select 'LOP250200037', 'Tsz Him Poon ', 'Tsz Him ', 'Poon (潘子謙)', '2016-05-12', 'C0107', '樂思中文課程', 'Weekly', '香港培正小學', 'P3', 'L3', '2025-02-15', '2025-02-22', '2025-03-15', '-1230', 'Mother:85293109231', 'English', 'Male', 'dbr.purehtml:jennifer_kkw@hotmail.com', '
    ', '560855', 'Information for February (Latest schedule on top)', 'Sat 12:00', 'Jessie Shek', '1', null, null, 307.5, 307.5
    union all
    select 'LOP250200019', 'Ho Ting, Ethan Leung', 'Ho Ting, Ethan', 'Leung(梁皓庭)', '2015-12-14', 'C0107', '樂思中文課程', 'Weekly', '神召會德萃小學', 'P4', 'L3', '2025-02-10', '2025-02-12', '2025-03-26', '', 'Mother:85294937202', 'English', 'Male', 'dbr.purehtml:mm.auyeung@sjs.org.hk', '
    ', '557082', 'Information for February (Latest schedule on top)', 'Wed 17:30', 'Jessie Shek', '3', null, 2, 922.71, 965.57
    union all
    select 'LOP250200039', 'Ching Yan Evelyn Ka', 'Ching Yan Evelyn', 'Ka(賈瀞銦)', '2013-04-28', 'C0107', '樂思中文課程', 'Weekly', '景林天主教', 'P6', 'L6', '2025-02-15', '2025-02-22', '2025-03-29', '', 'Mother:85296855477', 'English', 'Female', 'dbr.purehtml:', '
    ', '560879', 'Information for February (Latest schedule on top)', 'Sat 16:30', 'Jessie Shek', '1', null, null, 307.5, 307.5
    union all
    select 'LOP250200015', 'Yan Shek Johnathan Lau', 'Yan Shek Johnathan', 'Lau(劉恩碩)', '2017-03-03', 'E0107', '樂思英文課程', 'Weekly', '滬江小學', 'P2', 'L2', '2025-02-08', '2025-02-17', '2025-03-31', '308', 'Father:85262588774', 'English', 'Male', 'dbr.purehtml:', '
    ', '556893', 'Information for February (Latest schedule on top)', 'Mon 17:30', 'Jessie Shek', '2', null, 1, 615.5, 307.5
    union all
    select 'LOP250200014', 'Chun Yat Lo', 'Chun Yat', 'Lo(盧駿逸)', '2015-02-05', 'E0110', 'New English Writing', 'Weekly', '香港南區官立小學', 'P4', 'L4', '2025-02-08', '2025-02-22', '2025-03-29', '333', 'Father:85265776420
    Mother:85269372338', 'English', 'Male', 'dbr.purehtml:', '
    ', '556890', 'Information for February (Latest schedule on top)', 'Sat 15:30', 'Jessie Shek', '1', null, null, 332.5, 332.5
    union all
    select 'LOP250200037', 'Tsz Him Poon ', 'Tsz Him ', 'Poon (潘子謙)', '2016-05-12', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '香港培正小學', 'P3', 'L3', '2025-02-15', '2025-02-15', '2025-03-08', '998', 'Mother:85293109231', 'English', 'Male', 'dbr.purehtml:jennifer_kkw@hotmail.com', '
    ', '560855', 'Information for February (Latest schedule on top)', 'Sat 11:00', 'Jessie Shek/Priscilla Li', '2', null, 1, 665.0, 715.0
    union all
    select 'LOP250200031', 'Chun Hei Edward Luk', 'Chun Hei Edward', 'Luk(陸晉熙)', '2018-02-12', 'C0001', '幼兒中文課程', 'Weekly', 'Shrewsbury International School Hong Kong', 'P1', 'L2', '2025-02-13', '2025-02-15', '2025-03-29', '', 'Father:85295189701
    Mother:85293402139', 'English', 'Male', 'dbr.purehtml:kinki2130@gmail.com', '
    ', '559647', 'Information for February (Latest schedule on top)', 'Sat 09:00', 'Jessie Shek/Tommy Tsoi', '2', null, 1, 615.14, 643.71
    union all
    select 'LOP250200015', 'Yan Shek Johnathan Lau', 'Yan Shek Johnathan', 'Lau(劉恩碩)', '2017-03-03', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '滬江小學', 'P2', 'L2', '2025-02-08', '2025-02-13', '2025-03-27', '', 'Father:85262588774', 'English', 'Male', 'dbr.purehtml:', '
    ', '556893', 'Information for February (Latest schedule on top)', 'Thu 16:30', 'Jessie Shek/Zoe Leung', '3', null, 2, 997.71, 1040.57
    union all
    select 'LOP250200023', 'Sarah Zhou', 'Sarah', 'Zhou(周倩瑜)', '2016-04-06', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '香港培正小學', 'P3', 'L3', '2025-02-12', '2025-02-20', '2025-03-26', '', 'Mother:85296999226', 'English', 'Female', 'dbr.purehtml:emmalui0226@icloud.com', '
    ', '557271', 'Information for February (Latest schedule on top)', 'Wed 16:30', 'Jessie Shek/Zoe Leung', '2', null, 1, 665.0, 665.0
    union all
    select 'LOP250200026', 'Tsz Ching Tiana Chan', 'Tsz Ching Tiana', 'Chan(陳紫晴)', '2014-02-08', 'C0107', '樂思中文課程', 'Weekly', 'Po Leung Kuk Camoes Tan Siu Lin Primary School ', 'P5', 'L5', '2025-02-12', '2025-02-14', '2025-03-07', '', 'Mother:85293859382', 'English', 'Female', 'dbr.purehtml:', '
    ', '559591', 'Information for February (Latest schedule on top)', 'Fri 16:30
    Fri 17:00', 'Jessie Shek/Zoe Leung', '3', null, 1, 922.5, 922.5
    union all
    select 'LOP250200035', '靖希 盧', '靖希', '盧', '2016-07-04', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '保良局陸慶濤小學', 'P3', 'L3', '2025-02-16', '2025-02-18', '2025-03-25', '', 'Mother:85295173049', 'English', 'Female', 'dbr.purehtml:', '
    ', '560763', 'Information for February (Latest schedule on top)', 'Tue 16:30', 'Kimmy Yau', '2', null, 1, 665.0, 698.33
    union all
    select 'LOP250200017', 'Hoi Ching Chiu', 'Hoi Ching', 'Chiu(趙凱晴)', '2017-11-07', 'E0110', 'New English Writing', 'Weekly', '聖保羅男女中學附屬小學', 'P1', 'L3', '2025-02-10', '2025-02-21', '2025-03-28', '', 'Father:85292762104
    Mother:85298484819', 'English', 'Female', 'dbr.purehtml:tinoijcc@hotmail.com', '
    ', '557041', 'Information for February (Latest schedule on top)', 'Fri 16:30', 'Kimmy Yau', '2', null, null, 665.0, 698.33
    union all
    select 'LOP250200016', '理鑫(Eddie) 陳', '理鑫(Eddie)', '陳', '2016-01-12', 'E0110', 'New English Writing', 'Weekly', 'Shrewsbury International School Hong Kong', 'P4', 'L5', '2025-02-08', '2025-02-18', '2025-03-25', '', 'Father:85296170208
    Mother:85296151006', 'English', 'Male', 'dbr.purehtml:xwjackiechen66@gmail.com', '
    ', '556900', 'Information for February (Latest schedule on top)', 'Tue 17:30', 'Kimmy Yau', '2', null, 1, 665.0, 698.33
    union all
    select 'LOP250200007', '博愷 黃', '博愷', '黃', '2017-10-16', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '滬江維多利亞學校', 'P1', 'L1', '2025-02-08', '2025-02-15', '2025-03-08', '', 'Mother:85260216912', 'English', 'Male', 'dbr.purehtml:kristalkeep@gmail.com', '
    ', '556866', 'Information for February (Latest schedule on top)', 'Sat 10:00', 'Priscilla Li', '2', null, 1, 665.0, 715.0
    union all
    select 'LOP250200013', 'Ching Wah Mark Ip', 'Ching Wah Mark', 'Ip(葉青樺)', '2015-08-19', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '北角官立小學', 'P4', 'L4', '2025-02-08', '2025-02-15', '2025-03-08', '', 'Father:85292247752
    Mother:85292187343', 'English', 'Male', 'dbr.purehtml:dorisleehk@gmail.com', '
    ', '556889', 'Information for February (Latest schedule on top)', 'Sat 14:30', 'Priscilla Li', '2', null, 1, 665.0, 715.0
    union all
    select 'LOP250200014', 'Chun Yat Lo', 'Chun Yat', 'Lo(盧駿逸)', '2015-02-05', 'C0102', '小學中文閱讀策略及寫作技巧課程', 'Weekly', '香港南區官立小學', 'P4', 'L4', '2025-02-08', '2025-02-22', '2025-03-29', '333', 'Father:85265776420
    Mother:85269372338', 'English', 'Male', 'dbr.purehtml:', '
    ', '556890', 'Information for February (Latest schedule on top)', 'Sat 14:30', 'Priscilla Li', '1', null, null, 332.5, 349.17
    union all
    select 'LOP250200006', '藝愷 程', '藝愷', '程', '2018-03-14', 'C0107', '樂思中文課程', 'Weekly', '啟思小學', 'P1', 'L1', '2025-02-08', '2025-02-15', '2025-03-08', '', 'Mother:85294809668', 'English', 'Male', 'dbr.purehtml:', '
    ', '556863', 'Information for February (Latest schedule on top)', 'Sat 14:30', 'Priscilla Li', '2', null, 1, 615.0, 665.0
    union all
    select 'LOP250200007', '博愷 黃', '博愷', '黃', '2017-10-16', 'C0107', '樂思中文課程', 'Weekly', '滬江維多利亞學校', 'P1', 'L1', '2025-02-08', '2025-02-15', '2025-03-29', '-1538', 'Mother:85260216912', 'English', 'Male', 'dbr.purehtml:kristalkeep@gmail.com', '
    ', '556866', 'Information for February (Latest schedule on top)', 'Sat 11:00', 'Priscilla Li', '1', null, 1, 308.0, 0.0
    union all
    select 'LOP250200049', 'Mia Ou', 'Mia', 'Ou(歐蔚嵐)', '2016-02-19', 'C0107', '樂思中文課程', 'Weekly', 'Y.O.T Tin Ka Ping Primary School ', 'P3', 'L2', '2025-02-17', '2025-02-22', '2025-03-29', '', 'Mother:85295886346', 'English', 'Female', 'dbr.purehtml:', '
    ', '561083', 'Information for February (Latest schedule on top)', 'Sat 11:00', 'Priscilla Li', '1', null, null, 307.5, 307.5
    union all
    select 'LOP250200008', '博禹 黃', '博禹', '黃(黃博禹)', '2015-04-26', 'C0107', '樂思中文課程', 'Weekly', '滬江維多利亞學校', 'P4', 'L4', '2025-02-08', '2025-02-15', '2025-03-29', '-1538', 'Mother:85260216912', 'Cantonese', 'Male', 'dbr.purehtml:', '
    ', '556867', 'Information for February (Latest schedule on top)', 'Sat 15:30', 'Priscilla Li', '1', null, 1, 308.0, 0.0
    union all
    select 'LOP250200027', 'Bo yi Lau', 'Bo yi', 'Lau(劉寶兒)', '2016-03-23', 'M0108', '樂思數學課程(專科班)', 'Weekly', '梁潔華小學', 'P3', 'L3', '2025-02-13', '2025-02-22', '2025-03-29', '', 'Mother:85262326322', 'English', 'Female', 'dbr.purehtml:', '
    ', '559612', 'Information for February (Latest schedule on top)', 'Sat 16:30', 'Priscilla Li', '1', null, null, 307.5, 324.17
    union all
    select 'LOP250200049', 'Mia Ou', 'Mia', 'Ou(歐蔚嵐)', '2016-02-19', 'M0108', '樂思數學課程(專科班)', 'Weekly', 'Y.O.T Tin Ka Ping Primary School ', 'P3', 'L3', '2025-02-17', '2025-02-22', '2025-03-29', '', 'Mother:85295886346', 'English', 'Female', 'dbr.purehtml:', '
    ', '561083', 'Information for February (Latest schedule on top)', 'Sat 16:30', 'Priscilla Li', '1', null, null, 307.5, 324.17
    union all
    select 'LOP250200045', 'Yui Ng', 'Yui', 'Ng(吳睿)', '2020-04-02', 'C0001', '幼兒中文課程', 'Weekly', 'Lam Tin Ling Liang kindergarten ', 'K2', 'L2', '2025-02-16', '2025-02-20', '2025-03-27', '', 'Mother:85260365952', 'English', 'Female', 'dbr.purehtml:milkedith@gmail.com', '
    ', '561010', 'Information for February (Latest schedule on top)', 'Thu 15:30', 'Zoe Leung', '2', null, 1, 615.0, 648.33
    union all
    select 'LOP250200028', 'Isabel Harper Leung', 'Isabel Harper', 'Leung(梁以錞)', '2015-06-11', 'C0107', '樂思中文課程', 'Weekly', 'Po Leung Kuk Camoes Tan Siu Lin Primary School ', 'P4', 'L4', '2025-02-12', '2025-02-20', '2025-03-27', '', 'Mother:85294449794', 'English', 'Female', 'dbr.purehtml:neeekko@yahoo.com.hk', '
    ', '559628', 'Information for February (Latest schedule on top)', 'Thu 17:30', 'Zoe Leung', '2', null, null, 615.0, 648.33
    union all
    select 'LOP250200059', 'Suet Ching Tsang', 'Suet Ching', 'Tsang(曾雪晴)', '2025-02-20', 'C0107', '樂思中文課程', 'Weekly', 'St. Paul\'s Convent School (Primary Section)', 'P4', 'L4', '2025-02-20', '2025-02-20', '2025-03-27', '-1945', 'Mother:85263506189', 'Cantonese', 'Female', 'dbr.purehtml:', '
    ', '563732', 'Information for February (Latest schedule on top)', 'Thu 17:30', 'Zoe Leung', '2', null, null, 615.0, 648.33;

    select 'dbr.tab.next';

  2. myDBR Team, Key Master

    Hi,
    The issue is now fixed in the latest build. Thank you for pointing this out.

    When you have code attachments, it's better to to use support email where you can attach the code. Forum is better suited for textual questions.

    --
    myDBR Team

  3. jasmondluk, Member

    What is the support email address we should send?

  4. myDBR Team, Key Master

    See https://mydbr.com/about/

    --
    myDBR Team


Reply

You must log in to post.