--SELECT `fidId`,`fidTot`,`fidCurDate`,`fidComment` FROM `fidelity` where fidId > 124 order by `fidId` DESC limit 20 INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-05-18',1308676,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-09-02',271367,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-09-17',1262000,0,0,0,'Old Totals max value'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-10-05',1287611,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-10-17',1301583,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-10-30',1310857,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-11-12',1312267,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-11-29',1329765,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2017-12-23',1337701,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-01-11',1368977,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-01-22',1389267,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-01-23',1394258,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-02-12',1949435,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-03-08',1987473,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-03-09',2007006.11,0,0,0,'Old Totals only Max'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-03-12',2011044.71,0,0,0,'Old Totals only Max'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-03-12',2011044.71,352736.88,729448.66,787278.49,'max total'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-03-23',1934874.04,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-03-28',1942919.30,0,0,0,'Old Totals only'); INSERT INTO fidelity(fidCurDate, fidTot, fidIndiv,fidPer,fidProMan, fidComment) VALUES ('2018-02-18',1946000,0,0,0,'Old $636 beach sale'); --SELECT `fidId`,`fidTot`,`fidCurDate`,`fidComment`,`fidIndiv`,`fidPer`,`fidProMan`,`fidSep` FROM `fidelity` where fidId > 124 order by `fidCurDate` DESC limit 20`;