init.sql

DROP DATABASE IF EXISTS iswa;
CREATE DATABASE iswa;
CREATE USER IF NOT EXISTS 'iswa_dbuser'@'localhost' IDENTIFIED BY 'Greamthiaw-29-Anwerosk';
GRANT ALL PRIVILEGES ON iswa.* TO 'iswa_dbuser'@'localhost';
FLUSH PRIVILEGES;
use iswa;

CREATE TABLE IF NOT EXISTS users (
  userid VARCHAR(64) NOT NULL UNIQUE,
  password VARCHAR(64) NOT NULL,
  email VARCHAR(255) NOT NULL UNIQUE,
  firstname VARCHAR(255) NOT NULL,
  lastname VARCHAR(255) NOT NULL,
  address VARCHAR(255) NOT NULL,
  postcode VARCHAR(64),
  phone VARCHAR(255) NOT NULL,
  PRIMARY KEY(userid)
);

CREATE TABLE IF NOT EXISTS messages (
  messageid INT AUTO_INCREMENT,
  userid VARCHAR(64) NOT NULL,
  sender TEXT NOT NULL,
  subject TEXT NOT NULL,
  content TEXT NOT NULL,
  sent DATE NOT NULL,
  PRIMARY KEY(messageid)
);

INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000108','e10adc3949ba59abbe56e057f20f883e','OwenDettmann@teleworm.us','Owen','Dettmann','46 Point Walter Road','6167','0437 221 874');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000101','0571749e2ac330a7455809c6b0e7af90','CaitlinJennings@dayrep.com','Caitlin','Jennings','2/30 Woerdens Road','2329','0454 141 873');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000103','40be4e59b9a2a2b5dffb918c0e86b3d7','SamuelWylde@jourrapide.com','Samuel','Wylde','38 High Street','5573','(08) 8396 8681');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000106','29aabd42991bb21cfb9e5d2f78fec4b7','xiao2831zzz@gmail.com','Xiao','Chen','142 Edgecliff Road','2017','0467 870 081');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000109','59961734d116461fc81bdfc941100732','BChelmsford@armyspy.com','Brett','Chelmsford','27/13-15 Cassinia Street','2721','0455 983 215');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000111','161ebd7d45089b3446ee4e0d86dbcf92','sghanim@somecompany.com','Suhayla','Ghanim','50A Daly Terrace','6044','(08) 9217 6139');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000114','9417787ed17a5851453850ae6ebead18','AdamEade@rhyta.com','Adam','Eade','69 Old Gayndah Road','4650','(07) 3652 9859');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000118','c6d4326ff054f935e5a6a0e70bd4b16e','yydaisy70@yahoo.com','Ulrike','Kruger','245/15-17 Hay Point Road','4131','(07) 4940 2286');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000121','b46308ac513bf934264ca4d0f2afbc58','CalebHenslowe@jourrapide.com','Caleb','Henslowe','30 Kintyre Street','4151','0429 821 387');
INSERT INTO users(userid,password,email,firstname,lastname,address,postcode,phone) VALUES ('1000125','b5ea8985533defbf1d08d5ed2ac8fe9b','asabbatini_2324@hotmail.com','Alma','Udinesi','1244/59-61 Thyme Avenue','4014','0422 871 119');

INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','Member Administration','Changes to Your Details Notification','Dear Owen Dettmann,<p>For your records, the email attached to your account was changed to OwenDettmann@teleworm.us on 12/04/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('12/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','Member Administration','Changes to Your Details Notification','Dear Owen Dettmann,<p>For your records, the phone attached to your account was changed to 0437 221 874 on 06/09/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('06/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','Member Administration','Changes to Your Details Notification','Dear Owen Dettmann,<p>For your records, the address attached to your account was changed to 46 Point Walter Road 6167 on 11/04/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('11/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','Member Administration','Changes to Your Details Notification','Dear Caitlin Jennings,<p>For your records, the email attached to your account was changed to CaitlinJennings@dayrep.com on 07/01/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('07/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','Member Administration','Changes to Your Details Notification','Dear Caitlin Jennings,<p>For your records, the phone attached to your account was changed to 0454 141 873 on 07/04/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('07/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','Member Administration','Changes to Your Details Notification','Dear Caitlin Jennings,<p>For your records, the address attached to your account was changed to 2/30 Woerdens Road 2329 on 23/02/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('23/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','Member Administration','Changes to Your Details Notification','Dear Samuel Wylde,<p>For your records, the email attached to your account was changed to SamuelWylde@jourrapide.com on 07/04/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('07/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','Member Administration','Changes to Your Details Notification','Dear Samuel Wylde,<p>For your records, the phone attached to your account was changed to (08) 8396 8681 on 17/07/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('17/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','Member Administration','Changes to Your Details Notification','Dear Samuel Wylde,<p>For your records, the address attached to your account was changed to 38 High Street 5573 on 12/03/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('12/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000106','Member Administration','Changes to Your Details Notification','Dear Xiao Chen,<p>For your records, the email attached to your account was changed to xiao2831zzz@gmail.com on 27/05/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('27/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000106','Member Administration','Changes to Your Details Notification','Dear Xiao Chen,<p>For your records, the phone attached to your account was changed to 0467 870 081 on 04/08/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('04/08/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','Member Administration','Changes to Your Details Notification','Dear Brett Chelmsford,<p>For your records, the email attached to your account was changed to BChelmsford@armyspy.com on 13/06/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('13/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','Member Administration','Changes to Your Details Notification','Dear Brett Chelmsford,<p>For your records, the phone attached to your account was changed to 0455 983 215 on 03/03/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('03/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','Member Administration','Changes to Your Details Notification','Dear Brett Chelmsford,<p>For your records, the address attached to your account was changed to 27/13-15 Cassinia Street 2721 on 25/02/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('25/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','Member Administration','Changes to Your Details Notification','Dear Suhayla Ghanim,<p>For your records, the email attached to your account was changed to sghanim@somecompany.com on 26/06/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('26/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','Member Administration','Changes to Your Details Notification','Dear Adam Eade,<p>For your records, the email attached to your account was changed to AdamEade@rhyta.com on 04/06/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('04/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','Member Administration','Changes to Your Details Notification','Dear Adam Eade,<p>For your records, the phone attached to your account was changed to (07) 3652 9859 on 20/09/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('20/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','Member Administration','Changes to Your Details Notification','Dear Adam Eade,<p>For your records, the address attached to your account was changed to 69 Old Gayndah Road 4650 on 16/07/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('16/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','Member Administration','Changes to Your Details Notification','Dear Ulrike Kruger,<p>For your records, the email attached to your account was changed to yydaisy70@yahoo.com on 06/02/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('06/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','Member Administration','Changes to Your Details Notification','Dear Ulrike Kruger,<p>For your records, the phone attached to your account was changed to (07) 4940 2286 on 11/09/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('11/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','Member Administration','Changes to Your Details Notification','Dear Caleb Henslowe,<p>For your records, the email attached to your account was changed to CalebHenslowe@jourrapide.com on 28/04/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('28/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','Member Administration','Changes to Your Details Notification','Dear Caleb Henslowe,<p>For your records, the phone attached to your account was changed to 0429 821 387 on 03/05/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('03/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','Member Administration','Changes to Your Details Notification','Dear Caleb Henslowe,<p>For your records, the address attached to your account was changed to 30 Kintyre Street 4151 on 13/07/2019.<p>If you did not make these changes to your details please contact Customer Support on 15 12 44.', STR_TO_DATE('13/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Quarterly Statement','Dear Owen Dettmann,<p>Your quarterly fund statement is shown below, as recorded on 03/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Regional Small Companies Fund</td><td>9765</td><td>6.467</td><td>63150.84</td><td>-2.413</td></tr><tr><td>3K Global Infrastructure</td><td>9710</td><td>4.017</td><td>39001.67</td><td>4.204</td></tr></table>', STR_TO_DATE('03/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Quarterly Statement','Dear Caitlin Jennings,<p>Your quarterly fund statement is shown below, as recorded on 04/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>3K Global Infrastructure</td><td>7346</td><td>4.017</td><td>29506.31</td><td>4.204</td></tr></table>', STR_TO_DATE('04/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Quarterly Statement','Dear Samuel Wylde,<p>Your quarterly fund statement is shown below, as recorded on 04/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Link Capital Global</td><td>11241</td><td>5.856</td><td>65826.87</td><td>-0.274</td></tr></table>', STR_TO_DATE('04/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000106','InvestSecure','Your Quarterly Statement','Dear Xiao Chen,<p>Your quarterly fund statement is shown below, as recorded on 02/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>ELX Companies Wholesale</td><td>2938</td><td>5.763</td><td>16931.25</td><td>-4.498</td></tr><tr><td>Crown Global Growth</td><td>294</td><td>4.025</td><td>1183.43</td><td>0.882</td></tr></table>', STR_TO_DATE('02/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Quarterly Statement','Dear Brett Chelmsford,<p>Your quarterly fund statement is shown below, as recorded on 03/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>13540</td><td>10.605</td><td>143595.30</td><td>0.185</td></tr><tr><td>Birmingham Real Income</td><td>12296</td><td>9.830</td><td>120866.39</td><td>-3.479</td></tr><tr><td>ELX Companies Wholesale</td><td>13902</td><td>5.763</td><td>80115.15</td><td>-4.498</td></tr></table>', STR_TO_DATE('03/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Quarterly Statement','Dear Suhayla Ghanim,<p>Your quarterly fund statement is shown below, as recorded on 02/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>5900</td><td>10.605</td><td>62571.07</td><td>0.185</td></tr><tr><td>Smith Index Australian Property</td><td>17356</td><td>3.377</td><td>58613.67</td><td>0.679</td></tr><tr><td>Anson Property Securities</td><td>5957</td><td>1.146</td><td>6827.86</td><td>-0.808</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>8498</td><td>5.180</td><td>44023.69</td><td>4.238</td></tr></table>', STR_TO_DATE('02/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Quarterly Statement','Dear Adam Eade,<p>Your quarterly fund statement is shown below, as recorded on 02/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>ELX Companies Wholesale</td><td>2526</td><td>5.763</td><td>14556.96</td><td>-4.498</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>14780</td><td>5.180</td><td>76567.45</td><td>4.238</td></tr><tr><td>Crown Global Growth</td><td>5061</td><td>4.025</td><td>20371.85</td><td>0.882</td></tr></table>', STR_TO_DATE('02/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Quarterly Statement','Dear Ulrike Kruger,<p>Your quarterly fund statement is shown below, as recorded on 02/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>18409</td><td>10.605</td><td>195232.34</td><td>0.185</td></tr><tr><td>Regional Small Companies Fund</td><td>18240</td><td>6.467</td><td>117959.18</td><td>-2.413</td></tr><tr><td>Smith Index Australian Property</td><td>9324</td><td>3.377</td><td>31488.47</td><td>0.679</td></tr><tr><td>Anson Property Securities</td><td>9321</td><td>1.146</td><td>10683.64</td><td>-0.808</td></tr><tr><td>Link Capital Global</td><td>12511</td><td>5.856</td><td>73263.94</td><td>-0.274</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>1182</td><td>5.180</td><td>6123.32</td><td>4.238</td></tr><tr><td>WQU Future Companies Wholesale</td><td>1526</td><td>6.323</td><td>9648.68</td><td>4.942</td></tr></table>', STR_TO_DATE('02/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Quarterly Statement','Dear Caleb Henslowe,<p>Your quarterly fund statement is shown below, as recorded on 03/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Regional Small Companies Fund</td><td>4265</td><td>6.467</td><td>27582.01</td><td>-2.413</td></tr><tr><td>Link Capital Global</td><td>16585</td><td>5.856</td><td>97121.13</td><td>-0.274</td></tr></table>', STR_TO_DATE('03/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Quarterly Statement','Dear Alma Udinesi,<p>Your quarterly fund statement is shown below, as recorded on 03/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Anson Property Securities</td><td>2656</td><td>1.146</td><td>3044.28</td><td>-0.808</td></tr><tr><td>Birmingham Real Income</td><td>7195</td><td>9.830</td><td>70724.92</td><td>-3.479</td></tr><tr><td>Link Capital Global</td><td>18979</td><td>5.856</td><td>111140.30</td><td>-0.274</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>17053</td><td>5.180</td><td>88342.67</td><td>4.238</td></tr><tr><td>WQU Future Companies Wholesale</td><td>18403</td><td>6.323</td><td>116359.57</td><td>4.942</td></tr><tr><td>Crown Global Growth</td><td>3106</td><td>4.025</td><td>12502.46</td><td>0.882</td></tr></table>', STR_TO_DATE('03/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Request Has Been Processed','Dear Caitlin Jennings,<p>We confirm that your request has been processed, as recorded on 16/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>582</td><td>3.939</td><td>2292.48</td></tr></table>', STR_TO_DATE('16/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 19/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>-562</td><td>6.317</td><td>-3549.97</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Samuel Wylde<br>BSB: 749548<br>Account Number: 0536151', STR_TO_DATE('19/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 14/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>ELX Companies Wholesale</td><td>1198</td><td>5.284</td><td>6329.70</td></tr></table>', STR_TO_DATE('14/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 13/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Market Gold Leaders ETF</td><td>-363</td><td>12.039</td><td>-4370.28</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Suhayla Ghanim<br>BSB: 593784<br>Account Number: 1722451', STR_TO_DATE('13/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 18/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>FirstChoice Real Estate Trust</td><td>86</td><td>4.749</td><td>408.45</td></tr></table>', STR_TO_DATE('18/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Request Has Been Processed','Dear Caleb Henslowe,<p>We confirm that your request has been processed, as recorded on 16/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>267</td><td>6.409</td><td>1711.07</td></tr></table>', STR_TO_DATE('16/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 16/01/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Crown Global Growth</td><td>292</td><td>4.458</td><td>1301.80</td></tr></table>', STR_TO_DATE('16/01/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Request Has Been Processed','Dear Owen Dettmann,<p>We confirm that your request has been processed, as recorded on 10/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>683</td><td>3.792</td><td>2589.91</td></tr></table>', STR_TO_DATE('10/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Request Has Been Processed','Dear Caitlin Jennings,<p>We confirm that your request has been processed, as recorded on 08/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>-549</td><td>3.726</td><td>-2045.72</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Caitlin Jennings<br>BSB: 259654<br>Account Number: 44425', STR_TO_DATE('08/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 11/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>596</td><td>6.648</td><td>3962.37</td></tr></table>', STR_TO_DATE('11/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 11/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Smith Index Australian Property</td><td>-1601</td><td>3.414</td><td>-5465.50</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Suhayla Ghanim<br>BSB: 593784<br>Account Number: 1722451', STR_TO_DATE('11/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Request Has Been Processed','Dear Adam Eade,<p>We confirm that your request has been processed, as recorded on 06/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>FirstChoice Real Estate Trust</td><td>1345</td><td>5.261</td><td>7075.50</td></tr></table>', STR_TO_DATE('06/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 09/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Anson Property Securities</td><td>631</td><td>1.149</td><td>724.91</td></tr></table>', STR_TO_DATE('09/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Request Has Been Processed','Dear Caleb Henslowe,<p>We confirm that your request has been processed, as recorded on 10/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>343</td><td>6.218</td><td>2132.82</td></tr></table>', STR_TO_DATE('10/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 08/02/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Anson Property Securities</td><td>-135</td><td>1.280</td><td>-172.85</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Alma Udinesi<br>BSB: 200385<br>Account Number: 17416', STR_TO_DATE('08/02/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 11/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>-1070</td><td>6.361</td><td>-6805.83</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Samuel Wylde<br>BSB: 749548<br>Account Number: 0536151', STR_TO_DATE('11/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 09/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Market Gold Leaders ETF</td><td>-1133</td><td>10.479</td><td>-11872.99</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Brett Chelmsford<br>BSB: 166154<br>Account Number: 56582', STR_TO_DATE('09/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 11/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Anson Property Securities</td><td>374</td><td>1.107</td><td>414.03</td></tr></table>', STR_TO_DATE('11/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Request Has Been Processed','Dear Adam Eade,<p>We confirm that your request has been processed, as recorded on 14/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>ELX Companies Wholesale</td><td>204</td><td>6.390</td><td>1303.50</td></tr></table>', STR_TO_DATE('14/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 12/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Market Gold Leaders ETF</td><td>-1352</td><td>11.913</td><td>-16106.77</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Ulrike Kruger<br>BSB: 630680<br>Account Number: 59324', STR_TO_DATE('12/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 12/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Crown Global Growth</td><td>183</td><td>4.094</td><td>749.29</td></tr></table>', STR_TO_DATE('12/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Request Has Been Processed','Dear Owen Dettmann,<p>We confirm that your request has been processed, as recorded on 28/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>577</td><td>7.013</td><td>4046.41</td></tr></table>', STR_TO_DATE('28/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Request Has Been Processed','Dear Caitlin Jennings,<p>We confirm that your request has been processed, as recorded on 29/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>539</td><td>4.383</td><td>2362.29</td></tr></table>', STR_TO_DATE('29/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 27/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>626</td><td>6.052</td><td>3788.47</td></tr></table>', STR_TO_DATE('27/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 29/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>ELX Companies Wholesale</td><td>1344</td><td>6.254</td><td>8404.97</td></tr></table>', STR_TO_DATE('29/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 25/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Smith Index Australian Property</td><td>1268</td><td>3.321</td><td>4211.19</td></tr></table>', STR_TO_DATE('25/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 23/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>WQU Future Companies Wholesale</td><td>-113</td><td>6.787</td><td>-766.98</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Ulrike Kruger<br>BSB: 630680<br>Account Number: 59324', STR_TO_DATE('23/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Request Has Been Processed','Dear Caleb Henslowe,<p>We confirm that your request has been processed, as recorded on 25/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>316</td><td>5.971</td><td>1886.81</td></tr></table>', STR_TO_DATE('25/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 24/03/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>1807</td><td>5.805</td><td>10489.29</td></tr></table>', STR_TO_DATE('24/03/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Quarterly Statement','Dear Owen Dettmann,<p>Your quarterly fund statement is shown below, as recorded on 03/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Regional Small Companies Fund</td><td>10342</td><td>6.883</td><td>71181.09</td><td>6.427</td></tr><tr><td>3K Global Infrastructure</td><td>10393</td><td>4.580</td><td>47596.54</td><td>14.017</td></tr></table>', STR_TO_DATE('03/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Quarterly Statement','Dear Caitlin Jennings,<p>Your quarterly fund statement is shown below, as recorded on 04/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>3K Global Infrastructure</td><td>7918</td><td>4.580</td><td>36261.85</td><td>14.017</td></tr></table>', STR_TO_DATE('04/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Quarterly Statement','Dear Samuel Wylde,<p>Your quarterly fund statement is shown below, as recorded on 03/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Link Capital Global</td><td>10831</td><td>5.849</td><td>63347.90</td><td>-0.123</td></tr></table>', STR_TO_DATE('03/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000106','InvestSecure','Your Quarterly Statement','Dear Xiao Chen,<p>Your quarterly fund statement is shown below, as recorded on 03/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>ELX Companies Wholesale</td><td>2938</td><td>5.289</td><td>15538.84</td><td>-8.224</td></tr><tr><td>Crown Global Growth</td><td>294</td><td>3.936</td><td>1157.22</td><td>-2.214</td></tr></table>', STR_TO_DATE('03/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Quarterly Statement','Dear Brett Chelmsford,<p>Your quarterly fund statement is shown below, as recorded on 02/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>12407</td><td>9.879</td><td>122570.45</td><td>-6.847</td></tr><tr><td>Birmingham Real Income</td><td>12296</td><td>11.196</td><td>137660.44</td><td>13.895</td></tr><tr><td>ELX Companies Wholesale</td><td>16444</td><td>5.289</td><td>86970.94</td><td>-8.224</td></tr></table>', STR_TO_DATE('02/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Quarterly Statement','Dear Suhayla Ghanim,<p>Your quarterly fund statement is shown below, as recorded on 02/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>5537</td><td>9.879</td><td>54700.78</td><td>-6.847</td></tr><tr><td>Smith Index Australian Property</td><td>17023</td><td>3.552</td><td>60463.11</td><td>5.173</td></tr><tr><td>Anson Property Securities</td><td>6331</td><td>1.112</td><td>7037.60</td><td>-3.017</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>8498</td><td>4.993</td><td>42431.35</td><td>-3.617</td></tr></table>', STR_TO_DATE('02/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Quarterly Statement','Dear Adam Eade,<p>Your quarterly fund statement is shown below, as recorded on 03/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>ELX Companies Wholesale</td><td>2730</td><td>5.289</td><td>14438.74</td><td>-8.224</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>16125</td><td>4.993</td><td>80513.72</td><td>-3.617</td></tr><tr><td>Crown Global Growth</td><td>5061</td><td>3.936</td><td>19920.77</td><td>-2.214</td></tr></table>', STR_TO_DATE('03/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Quarterly Statement','Dear Ulrike Kruger,<p>Your quarterly fund statement is shown below, as recorded on 04/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>17057</td><td>9.879</td><td>168508.43</td><td>-6.847</td></tr><tr><td>Regional Small Companies Fund</td><td>18240</td><td>6.883</td><td>125540.82</td><td>6.427</td></tr><tr><td>Smith Index Australian Property</td><td>9324</td><td>3.552</td><td>33117.43</td><td>5.173</td></tr><tr><td>Anson Property Securities</td><td>9952</td><td>1.112</td><td>11062.74</td><td>-3.017</td></tr><tr><td>Link Capital Global</td><td>12511</td><td>5.849</td><td>73173.82</td><td>-0.123</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>1268</td><td>4.993</td><td>6331.25</td><td>-3.617</td></tr><tr><td>WQU Future Companies Wholesale</td><td>1413</td><td>7.057</td><td>9971.34</td><td>11.609</td></tr></table>', STR_TO_DATE('04/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Quarterly Statement','Dear Caleb Henslowe,<p>Your quarterly fund statement is shown below, as recorded on 04/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Regional Small Companies Fund</td><td>5191</td><td>6.883</td><td>35728.20</td><td>6.427</td></tr><tr><td>Link Capital Global</td><td>16585</td><td>5.849</td><td>97001.66</td><td>-0.123</td></tr></table>', STR_TO_DATE('04/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Quarterly Statement','Dear Alma Udinesi,<p>Your quarterly fund statement is shown below, as recorded on 02/04/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Anson Property Securities</td><td>2521</td><td>1.112</td><td>2802.37</td><td>-3.017</td></tr><tr><td>Birmingham Real Income</td><td>7195</td><td>11.196</td><td>80551.96</td><td>13.895</td></tr><tr><td>Link Capital Global</td><td>20786</td><td>5.849</td><td>121572.30</td><td>-0.123</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>17053</td><td>4.993</td><td>85147.31</td><td>-3.617</td></tr><tr><td>WQU Future Companies Wholesale</td><td>18403</td><td>7.057</td><td>129867.38</td><td>11.609</td></tr><tr><td>Crown Global Growth</td><td>3581</td><td>3.936</td><td>14095.29</td><td>-2.214</td></tr></table>', STR_TO_DATE('02/04/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Request Has Been Processed','Dear Owen Dettmann,<p>We confirm that your request has been processed, as recorded on 13/05/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>737</td><td>4.532</td><td>3339.90</td></tr></table>', STR_TO_DATE('13/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Request Has Been Processed','Dear Caitlin Jennings,<p>We confirm that your request has been processed, as recorded on 13/05/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>592</td><td>5.249</td><td>3107.37</td></tr></table>', STR_TO_DATE('13/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 11/05/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>835</td><td>6.352</td><td>5303.95</td></tr></table>', STR_TO_DATE('11/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 09/05/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Birmingham Real Income</td><td>1052</td><td>11.463</td><td>12058.75</td></tr></table>', STR_TO_DATE('09/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 13/05/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Anson Property Securities</td><td>515</td><td>1.213</td><td>624.49</td></tr></table>', STR_TO_DATE('13/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 12/05/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>FirstChoice Real Estate Trust</td><td>82</td><td>5.162</td><td>423.29</td></tr></table>', STR_TO_DATE('12/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 12/05/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Birmingham Real Income</td><td>578</td><td>12.469</td><td>7207.33</td></tr></table>', STR_TO_DATE('12/05/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Request Has Been Processed','Dear Caitlin Jennings,<p>We confirm that your request has been processed, as recorded on 12/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>695</td><td>4.721</td><td>3281.21</td></tr></table>', STR_TO_DATE('12/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 07/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Anson Property Securities</td><td>580</td><td>1.071</td><td>621.23</td></tr></table>', STR_TO_DATE('07/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Request Has Been Processed','Dear Adam Eade,<p>We confirm that your request has been processed, as recorded on 11/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>FirstChoice Real Estate Trust</td><td>-844</td><td>5.620</td><td>-4743.20</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Adam Eade<br>BSB: 176732<br>Account Number: 966759', STR_TO_DATE('11/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 08/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Smith Index Australian Property</td><td>-517</td><td>4.029</td><td>-2082.89</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Ulrike Kruger<br>BSB: 630680<br>Account Number: 59324', STR_TO_DATE('08/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 09/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>WQU Future Companies Wholesale</td><td>-1132</td><td>7.734</td><td>-8755.33</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Alma Udinesi<br>BSB: 200385<br>Account Number: 17416', STR_TO_DATE('09/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Request Has Been Processed','Dear Owen Dettmann,<p>We confirm that your request has been processed, as recorded on 23/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>604</td><td>7.452</td><td>4501.12</td></tr></table>', STR_TO_DATE('23/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 21/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Birmingham Real Income</td><td>-1068</td><td>12.220</td><td>-13051.38</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Brett Chelmsford<br>BSB: 166154<br>Account Number: 56582', STR_TO_DATE('21/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 18/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Smith Index Australian Property</td><td>866</td><td>3.571</td><td>3092.65</td></tr></table>', STR_TO_DATE('18/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 20/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Smith Index Australian Property</td><td>611</td><td>3.778</td><td>2308.62</td></tr></table>', STR_TO_DATE('20/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Request Has Been Processed','Dear Caleb Henslowe,<p>We confirm that your request has been processed, as recorded on 19/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>1351</td><td>6.151</td><td>8310.38</td></tr></table>', STR_TO_DATE('19/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 21/06/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Crown Global Growth</td><td>-230</td><td>3.740</td><td>-860.19</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Alma Udinesi<br>BSB: 200385<br>Account Number: 17416', STR_TO_DATE('21/06/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Quarterly Statement','Dear Owen Dettmann,<p>Your quarterly fund statement is shown below, as recorded on 02/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Regional Small Companies Fund</td><td>10946</td><td>7.142</td><td>78174.31</td><td>3.764</td></tr><tr><td>3K Global Infrastructure</td><td>11130</td><td>5.026</td><td>55943.21</td><td>9.753</td></tr></table>', STR_TO_DATE('02/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Quarterly Statement','Dear Caitlin Jennings,<p>Your quarterly fund statement is shown below, as recorded on 02/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>3K Global Infrastructure</td><td>9205</td><td>5.026</td><td>46267.50</td><td>9.753</td></tr></table>', STR_TO_DATE('02/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Quarterly Statement','Dear Samuel Wylde,<p>Your quarterly fund statement is shown below, as recorded on 04/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Link Capital Global</td><td>11666</td><td>5.624</td><td>65612.81</td><td>-3.838</td></tr></table>', STR_TO_DATE('04/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000106','InvestSecure','Your Quarterly Statement','Dear Xiao Chen,<p>Your quarterly fund statement is shown below, as recorded on 02/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>ELX Companies Wholesale</td><td>2938</td><td>5.692</td><td>16724.49</td><td>7.630</td></tr><tr><td>Crown Global Growth</td><td>294</td><td>4.409</td><td>1296.37</td><td>12.024</td></tr></table>', STR_TO_DATE('02/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Quarterly Statement','Dear Brett Chelmsford,<p>Your quarterly fund statement is shown below, as recorded on 02/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>12407</td><td>9.105</td><td>112963.64</td><td>-7.838</td></tr><tr><td>Birmingham Real Income</td><td>12280</td><td>10.234</td><td>125678.07</td><td>-8.585</td></tr><tr><td>ELX Companies Wholesale</td><td>16444</td><td>5.692</td><td>93607.07</td><td>7.630</td></tr></table>', STR_TO_DATE('02/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Quarterly Statement','Dear Suhayla Ghanim,<p>Your quarterly fund statement is shown below, as recorded on 04/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>5537</td><td>9.105</td><td>50413.45</td><td>-7.838</td></tr><tr><td>Smith Index Australian Property</td><td>17889</td><td>3.491</td><td>62457.69</td><td>-1.702</td></tr><tr><td>Anson Property Securities</td><td>7426</td><td>1.204</td><td>8941.39</td><td>8.317</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>8498</td><td>4.836</td><td>41095.05</td><td>-3.149</td></tr></table>', STR_TO_DATE('04/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Quarterly Statement','Dear Adam Eade,<p>Your quarterly fund statement is shown below, as recorded on 04/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>ELX Companies Wholesale</td><td>2730</td><td>5.692</td><td>15540.46</td><td>7.630</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>15281</td><td>4.836</td><td>73896.62</td><td>-3.149</td></tr><tr><td>Crown Global Growth</td><td>5061</td><td>4.409</td><td>22316.06</td><td>12.024</td></tr></table>', STR_TO_DATE('04/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Quarterly Statement','Dear Ulrike Kruger,<p>Your quarterly fund statement is shown below, as recorded on 03/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Market Gold Leaders ETF</td><td>17057</td><td>9.105</td><td>155301.10</td><td>-7.838</td></tr><tr><td>Regional Small Companies Fund</td><td>18240</td><td>7.142</td><td>130266.71</td><td>3.764</td></tr><tr><td>Smith Index Australian Property</td><td>9418</td><td>3.491</td><td>32882.03</td><td>-1.702</td></tr><tr><td>Anson Property Securities</td><td>9952</td><td>1.204</td><td>11982.86</td><td>8.317</td></tr><tr><td>Link Capital Global</td><td>12511</td><td>5.624</td><td>70365.32</td><td>-3.838</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>1350</td><td>4.836</td><td>6528.40</td><td>-3.149</td></tr><tr><td>WQU Future Companies Wholesale</td><td>1413</td><td>6.849</td><td>9677.07</td><td>-2.951</td></tr></table>', STR_TO_DATE('03/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Quarterly Statement','Dear Caleb Henslowe,<p>Your quarterly fund statement is shown below, as recorded on 02/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Regional Small Companies Fund</td><td>5191</td><td>7.142</td><td>37073.16</td><td>3.764</td></tr><tr><td>Link Capital Global</td><td>17936</td><td>5.624</td><td>100877.02</td><td>-3.838</td></tr></table>', STR_TO_DATE('02/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Quarterly Statement','Dear Alma Udinesi,<p>Your quarterly fund statement is shown below, as recorded on 04/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><table width=100%><tr><th>Fund Name</th><th>Units</th><th>Current Unit Price</th><th>Total Value</th><th>Change Last Quarter</th></tr><tr><td>Anson Property Securities</td><td>2521</td><td>1.204</td><td>3035.45</td><td>8.317</td></tr><tr><td>Birmingham Real Income</td><td>7773</td><td>10.234</td><td>79551.76</td><td>-8.585</td></tr><tr><td>Link Capital Global</td><td>20786</td><td>5.624</td><td>116906.21</td><td>-3.838</td></tr><tr><td>FirstChoice Real Estate Trust</td><td>17053</td><td>4.836</td><td>82465.74</td><td>-3.149</td></tr><tr><td>WQU Future Companies Wholesale</td><td>17271</td><td>6.849</td><td>118282.13</td><td>-2.951</td></tr><tr><td>Crown Global Growth</td><td>3351</td><td>4.409</td><td>14775.96</td><td>12.024</td></tr></table>', STR_TO_DATE('04/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000108','InvestSecure','Your Request Has Been Processed','Dear Owen Dettmann,<p>We confirm that your request has been processed, as recorded on 21/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>1035</td><td>7.348</td><td>7604.93</td></tr></table>', STR_TO_DATE('21/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Request Has Been Processed','Dear Caitlin Jennings,<p>We confirm that your request has been processed, as recorded on 25/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>701</td><td>4.663</td><td>3268.85</td></tr></table>', STR_TO_DATE('25/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 25/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>854</td><td>5.878</td><td>5019.50</td></tr></table>', STR_TO_DATE('25/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000106','InvestSecure','Your Request Has Been Processed','Dear Xiao Chen,<p>We confirm that your request has been processed, as recorded on 25/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Crown Global Growth</td><td>25</td><td>4.689</td><td>117.23</td></tr></table>', STR_TO_DATE('25/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 22/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Market Gold Leaders ETF</td><td>681</td><td>8.995</td><td>6125.68</td></tr></table>', STR_TO_DATE('22/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 26/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Smith Index Australian Property</td><td>1140</td><td>3.534</td><td>4028.35</td></tr></table>', STR_TO_DATE('26/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Request Has Been Processed','Dear Adam Eade,<p>We confirm that your request has been processed, as recorded on 23/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>ELX Companies Wholesale</td><td>179</td><td>5.874</td><td>1051.39</td></tr></table>', STR_TO_DATE('23/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Request Has Been Processed','Dear Caleb Henslowe,<p>We confirm that your request has been processed, as recorded on 26/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>-349</td><td>7.916</td><td>-2762.82</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Caleb Henslowe<br>BSB: 794764<br>Account Number: 410008', STR_TO_DATE('26/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 26/07/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Anson Property Securities</td><td>-175</td><td>1.165</td><td>-203.94</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Alma Udinesi<br>BSB: 200385<br>Account Number: 17416', STR_TO_DATE('26/07/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 04/08/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>-1062</td><td>5.550</td><td>-5894.43</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Samuel Wylde<br>BSB: 749548<br>Account Number: 0536151', STR_TO_DATE('04/08/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 07/08/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Market Gold Leaders ETF</td><td>716</td><td>8.352</td><td>5979.87</td></tr></table>', STR_TO_DATE('07/08/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 06/08/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>FirstChoice Real Estate Trust</td><td>645</td><td>4.402</td><td>2839.05</td></tr></table>', STR_TO_DATE('06/08/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 05/08/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Smith Index Australian Property</td><td>482</td><td>3.402</td><td>1639.77</td></tr></table>', STR_TO_DATE('05/08/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Request Has Been Processed','Dear Caleb Henslowe,<p>We confirm that your request has been processed, as recorded on 03/08/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Regional Small Companies Fund</td><td>450</td><td>6.496</td><td>2923.22</td></tr></table>', STR_TO_DATE('03/08/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000101','InvestSecure','Your Request Has Been Processed','Dear Caitlin Jennings,<p>We confirm that your request has been processed, as recorded on 18/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>3K Global Infrastructure</td><td>776</td><td>4.811</td><td>3733.71</td></tr></table>', STR_TO_DATE('18/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000103','InvestSecure','Your Request Has Been Processed','Dear Samuel Wylde,<p>We confirm that your request has been processed, as recorded on 15/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>984</td><td>6.402</td><td>6299.48</td></tr></table>', STR_TO_DATE('15/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000109','InvestSecure','Your Request Has Been Processed','Dear Brett Chelmsford,<p>We confirm that your request has been processed, as recorded on 15/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Birmingham Real Income</td><td>856</td><td>11.173</td><td>9563.99</td></tr></table>', STR_TO_DATE('15/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000111','InvestSecure','Your Request Has Been Processed','Dear Suhayla Ghanim,<p>We confirm that your request has been processed, as recorded on 14/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Market Gold Leaders ETF</td><td>308</td><td>9.428</td><td>2903.72</td></tr></table>', STR_TO_DATE('14/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000114','InvestSecure','Your Request Has Been Processed','Dear Adam Eade,<p>We confirm that your request has been processed, as recorded on 16/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>FirstChoice Real Estate Trust</td><td>-1095</td><td>5.053</td><td>-5533.32</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Adam Eade<br>BSB: 176732<br>Account Number: 966759', STR_TO_DATE('16/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000118','InvestSecure','Your Request Has Been Processed','Dear Ulrike Kruger,<p>We confirm that your request has been processed, as recorded on 14/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Market Gold Leaders ETF</td><td>1060</td><td>10.382</td><td>11004.56</td></tr></table>', STR_TO_DATE('14/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000121','InvestSecure','Your Request Has Been Processed','Dear Caleb Henslowe,<p>We confirm that your request has been processed, as recorded on 12/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Withdrawal</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>Link Capital Global</td><td>-957</td><td>6.051</td><td>-5790.85</td></tr></table><p>The funds have been deposited into your nominated bank account<br>Account Name: Caleb Henslowe<br>BSB: 794764<br>Account Number: 410008', STR_TO_DATE('12/09/2019', '%d/%m/%Y'));
INSERT INTO messages(userid,sender,subject,content,sent) VALUES ('1000125','InvestSecure','Your Request Has Been Processed','Dear Alma Udinesi,<p>We confirm that your request has been processed, as recorded on 16/09/2019.<p>Please ensure you check the information below and contact Customer Support on 15 12 44 to report any discrepancies immediately.<p><h3>Deposit</h3><p><table width=100%><tr><th>Fund Name</th><th>No. of Units</th><th>At Unit Price</th><th>Total Transaction Value</th></tr><tr><td>WQU Future Companies Wholesale</td><td>1546</td><td>7.768</td><td>12009.21</td></tr></table>', STR_TO_DATE('16/09/2019', '%d/%m/%Y'));