Berlin General Log 2018.08.03

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld, Version: 5.5.60 (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: MySQL
Time                 Id Command    Argument
180803 18:57:12	    2 Query	set global log_slow_queries = 1
		    2 Query	SHOW WARNINGS
180803 18:57:36	    2 Query	show variables like '%log%'
180803 18:58:41	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 18:58:57	    2 Query	select count(distinct(ca.childid)) enrolment,
           extract(month from ca.date) as month,
           extract(year from ca.date) as year
           from childattendance ca, groups r
           where r.id = ca.groupid
           and r.companyid = 1414
           and extract(month from ca.date) = 1
           and extract(year from ca.date) = 2018
           group by month,year
           order by year,month
LIMIT 0, 1000
180803 18:59:02	    2 Query	select count(distinct(childid)) enrolment
            from childattendance
            where companyid = 1414
            and date between '2018-01-01' and '2018-01-31'
LIMIT 0, 1000
180803 18:59:07	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:04:48	    3 Connect	root@localhost on timesavr_dev
		    3 Query	mysqlcheck -c timesavr_dev -u root -p
Houst0n!
180803 19:05:06	    3 Query	mysqlcheck -c timesavr_dev -u root -P
Houst0n
180803 19:05:08	    3 Quit
180803 19:05:24	    4 Connect	root@localhost on
		    4 Init DB	timesavr_dev
		    4 Query	SHOW /*!50002 FULL*/ TABLES
		    4 Query	CHECK TABLE `accounts`
		    4 Query	CHECK TABLE `agegroups`
		    4 Query	CHECK TABLE `agreements`
		    4 Query	CHECK TABLE `areas`
		    4 Query	CHECK TABLE `blocks`
		    4 Query	CHECK TABLE `certifications`
		    4 Query	CHECK TABLE `chargeitems`
		    4 Query	CHECK TABLE `checklistitems`
		    4 Query	CHECK TABLE `checklistvalues`
180803 19:05:25	    4 Query	CHECK TABLE `childattendance`
180803 19:08:47	    4 Query	CHECK TABLE `childattendancemonthly`
		    4 Query	CHECK TABLE `childdailyschedule`
180803 19:08:51	    4 Query	CHECK TABLE `childmedicalinfo`
		    4 Query	CHECK TABLE `children`
180803 19:08:53	    4 Query	CHECK TABLE `childrengroups`
		    4 Query	CHECK TABLE `childrengroupsauto`
		    4 Query	CHECK TABLE `companies`
		    4 Query	CHECK TABLE `companies_serenity`
		    4 Query	CHECK TABLE `companies_solomon`
		    4 Query	CHECK TABLE `contacts`
180803 19:08:54	    4 Query	CHECK TABLE `coupons`
		    4 Query	CHECK TABLE `customfieldassignments`
		    4 Query	CHECK TABLE `customfieldoptions`
		    4 Query	CHECK TABLE `customfields`
		    4 Query	CHECK TABLE `customfieldsecurity`
		    4 Query	CHECK TABLE `customfieldvalues`
180803 19:08:55	    4 Query	CHECK TABLE `dayhomeratios`
		    4 Query	CHECK TABLE `dayhomevisits`
		    4 Query	CHECK TABLE `dependencies`
		    4 Query	CHECK TABLE `depositrefunds`
		    4 Query	CHECK TABLE `deposits`
		    4 Query	CHECK TABLE `distribution`
		    4 Query	CHECK TABLE `eftfileitems`
		    4 Query	CHECK TABLE `eftfiles`
		    4 Query	CHECK TABLE `exporthistory`
		    4 Query	CHECK TABLE `families`
180803 19:08:56	    4 Query	CHECK TABLE `familyagreements`
		    4 Query	CHECK TABLE `fathers`
		    4 Query	CHECK TABLE `feetypes`
		    4 Query	CHECK TABLE `financialaid`
		    4 Query	CHECK TABLE `groups`
		    4 Query	CHECK TABLE `helpquestions`
		    4 Query	CHECK TABLE `helpresponses`
		    4 Query	CHECK TABLE `helptutorials`
		    4 Query	CHECK TABLE `helptutorialsteps`
		    4 Query	CHECK TABLE `history_charges`
180803 19:08:57	    4 Query	CHECK TABLE `history_deletes`
180803 19:08:58	    4 Query	CHECK TABLE `history_emails`
		    4 Query	CHECK TABLE `history_logins`
180803 19:08:59	    4 Query	CHECK TABLE `hoursofoperation`
		    4 Query	CHECK TABLE `intakeemails`
		    4 Query	CHECK TABLE `intakesurvey`
		    4 Query	CHECK TABLE `log`
		    4 Query	CHECK TABLE `messages`
		    4 Query	CHECK TABLE `mobilesettings`
		    4 Query	CHECK TABLE `months`
		    4 Query	CHECK TABLE `mothers`
		    4 Query	CHECK TABLE `notes`
180803 19:09:00	    4 Query	CHECK TABLE `notesecurity`
180803 19:09:01	    4 Query	CHECK TABLE `notifications`
		    4 Query	CHECK TABLE `paymentinformation`
		    4 Query	CHECK TABLE `payrollitems`
		    4 Query	CHECK TABLE `preferences`
		    4 Query	CHECK TABLE `prioritization`
		    4 Query	CHECK TABLE `programtypes`
		    4 Query	CHECK TABLE `providerchildren`
		    4 Query	CHECK TABLE `providercontracts`
		    4 Query	CHECK TABLE `providerhours`
		    4 Query	CHECK TABLE `providers`
180803 19:09:02	    4 Query	CHECK TABLE `providertransactions`
180803 19:09:03	    4 Query	CHECK TABLE `providerunavailable`
		    4 Query	CHECK TABLE `provincecodes`
		    4 Query	CHECK TABLE `ratiocombinedgroups`
		    4 Query	CHECK TABLE `ratiooptions`
		    4 Query	CHECK TABLE `ratios`
		    4 Query	CHECK TABLE `registrationform`
		    4 Query	CHECK TABLE `registrationprograms`
		    4 Query	CHECK TABLE `reportcounter`
		    4 Query	CHECK TABLE `reports`
		    4 Query	CHECK TABLE `requiredfields`
		    4 Query	CHECK TABLE `schedules`
		    4 Query	CHECK TABLE `securityprofiles`
		    4 Query	CHECK TABLE `sessions`
		    4 Query	CHECK TABLE `staff`
		    4 Query	CHECK TABLE `staffattendance`
180803 19:09:35	    4 Query	CHECK TABLE `staffeducation`
		    4 Query	CHECK TABLE `staffrecords`
180803 19:09:36	    4 Query	CHECK TABLE `stafftasks`
		    4 Query	CHECK TABLE `stafftimeoff`
		    4 Query	CHECK TABLE `subscriptions`
		    4 Query	CHECK TABLE `subscriptiontransactions`
		    4 Query	CHECK TABLE `subsidy`
		    4 Query	CHECK TABLE `subsidyclaims`
180803 19:09:37	    4 Query	CHECK TABLE `tags`
		    4 Query	CHECK TABLE `tasks`
		    4 Query	CHECK TABLE `tasktypes`
		    4 Query	CHECK TABLE `timeoff`
		    4 Query	CHECK TABLE `timetrackingmethods`
		    4 Query	CHECK TABLE `transactions`
180803 19:09:44	    4 Query	CHECK TABLE `typicaltime`
		    4 Query	CHECK TABLE `usercompanies`
		    4 Query	CHECK TABLE `userreports`
		    4 Query	CHECK TABLE `users`
		    4 Query	CHECK TABLE `wagetopups`
		    4 Quit
180803 19:20:37	    5 Connect	root@122.114.46.138 on mysql
		    5 Connect	Access denied for user 'root'@'122.114.46.138' (using password: NO)
180803 19:20:42	    6 Connect	root@122.114.46.138 on mysql
		    6 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
		    7 Connect	root@122.114.46.138 on mysql
		    7 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:20:43	    8 Connect	root@122.114.46.138 on mysql
		    8 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:20:44	    9 Connect	root@122.114.46.138 on mysql
		    9 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:20:54	   10 Connect	root@122.114.46.138 on mysql
		   10 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:20:58	   11 Connect	root@122.114.46.138 on mysql
		   11 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
		   12 Connect	root@122.114.46.138 on mysql
		   12 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:20:59	   13 Connect	root@122.114.46.138 on mysql
		   13 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:00	   14 Connect	root@122.114.46.138 on mysql
		   14 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:01	   15 Connect	root@122.114.46.138 on mysql
		   15 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:11	   16 Connect	root@122.114.46.138 on mysql
		   16 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:12	   17 Connect	root@122.114.46.138 on mysql
		   17 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
		   18 Connect	root@122.114.46.138 on mysql
		   18 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:13	   19 Connect	root@122.114.46.138 on mysql
		   19 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:14	   20 Connect	root@122.114.46.138 on mysql
		   20 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:15	   21 Connect	root@122.114.46.138 on mysql
		   21 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:16	   22 Connect	root@122.114.46.138 on mysql
		   22 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
		   23 Connect	root@122.114.46.138 on mysql
		   23 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:17	   24 Connect	root@122.114.46.138 on mysql
		   24 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:18	   25 Connect	root@122.114.46.138 on mysql
		   25 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:19	   26 Connect	root@122.114.46.138 on mysql
		   26 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:21:20	   27 Connect	root@122.114.46.138 on mysql
		   27 Connect	Access denied for user 'root'@'122.114.46.138' (using password: YES)
180803 19:27:52	   28 Connect	root@114.80.100.91 on mysql
		   28 Connect	Access denied for user 'root'@'114.80.100.91' (using password: YES)
180803 19:27:58	   29 Connect	root@114.80.100.91 on mysql
		   29 Connect	Access denied for user 'root'@'114.80.100.91' (using password: YES)
180803 19:28:04	   30 Connect	root@114.80.100.91 on mysql
		   30 Connect	Access denied for user 'root'@'114.80.100.91' (using password: YES)
180803 19:28:11	   31 Connect	root@114.80.100.91 on mysql
		   31 Connect	Access denied for user 'root'@'114.80.100.91' (using password: YES)
180803 19:28:17	   32 Connect	mysql@114.80.100.91 on mysql
		   32 Connect	Access denied for user 'mysql'@'114.80.100.91' (using password: YES)
180803 19:28:20	   33 Connect	mysql@114.80.100.91 on mysql
		   33 Connect	Access denied for user 'mysql'@'114.80.100.91' (using password: YES)
180803 19:28:24	   34 Connect	mysql@114.80.100.91 on mysql
		   34 Connect	Access denied for user 'mysql'@'114.80.100.91' (using password: YES)
180803 19:28:26	   35 Connect	mysql@114.80.100.91 on mysql
		   35 Connect	Access denied for user 'mysql'@'114.80.100.91' (using password: YES)
180803 19:38:59	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:39:30	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:39:43	    2 Query	select count(distinct(childid)) enrolment
            from childattendance
            where companyid = 1414
            and date between '2018-01-01' and '2018-01-31'
LIMIT 0, 1000
180803 19:39:55	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:40:02	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:40:04	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:40:05	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:40:07	    2 Query	select count(distinct(childid)) enrolment
            from childattendance
            where companyid = 1414
            and date between '2018-01-01' and '2018-01-31'
LIMIT 0, 1000
180803 19:41:44	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:41:50	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:43:28	    2 Query	select count(distinct(childid)) enrolment
            from childattendance
            where companyid = 1414
            and date between '2018-01-01' and '2018-01-31'
LIMIT 0, 1000
180803 19:43:32	    2 Query	select count(distinct(ca.childid)) enrolment,
           extract(month from ca.date) as month,
           extract(year from ca.date) as year
           from childattendance ca, groups r
           where r.id = ca.groupid
           and r.companyid = 1414
           and extract(month from ca.date) = 1
           and extract(year from ca.date) = 2018
           group by month,year
           order by year,month
LIMIT 0, 1000
180803 19:43:39	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:43:42	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:43:45	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:46:29	   36 Connect	root@localhost on
		   36 Init DB	timesavr_dev
		   36 Query	SHOW /*!50002 FULL*/ TABLES
		   36 Query	OPTIMIZE TABLE `accounts`
		   36 Query	OPTIMIZE TABLE `agegroups`
		   36 Query	OPTIMIZE TABLE `agreements`
		   36 Query	OPTIMIZE TABLE `areas`
		   36 Query	OPTIMIZE TABLE `blocks`
		   36 Query	OPTIMIZE TABLE `certifications`
		   36 Query	OPTIMIZE TABLE `chargeitems`
		   36 Query	OPTIMIZE TABLE `checklistitems`
		   36 Query	OPTIMIZE TABLE `checklistvalues`
180803 19:46:31	   36 Query	OPTIMIZE TABLE `childattendance`
180803 19:53:04	    2 Query	select count(distinct(ca.childid)) enrolment,
           extract(month from ca.date) as month,
           extract(year from ca.date) as year
           from childattendance ca, groups r
           where r.id = ca.groupid
           and r.companyid = 1414
           and extract(month from ca.date) = 1
           and extract(year from ca.date) = 2018
           group by month,year
           order by year,month
LIMIT 0, 1000
180803 19:53:10	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:53:17	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 19:53:20	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:05:34	   37 Connect	timesavr_dev@localhost on
		   37 Init DB	timesavr_dev
		   38 Connect	timesavr_dev@localhost on timesavr_dev
		   37 Query	select timezone from preferences where companyid = 1414
		   37 Query	select companies.name companyname,
                       companies.email,
                       companies.id,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users,usercompanies uc, securityprofiles sp
                 where sp.id = users.securityprofile
                   and uc.userid = users.id
                   and uc.companyid = companies.id
                   and users.id = 2661 and uc.primarycompany = 'Y'
180803 20:05:38	   37 Query	select companies.name companyname,
                       companies.contactperson,
                       companies.email,
                       companies.phone,
                       companies.id,
                       companies.city,
                       companies.province,
                       companies.activescheduleid,
                       companies.initialsetupcomplete,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users, securityprofiles sp
                 where sp.id = users.securityprofile
                   and companies.id = 1414
		   37 Query	select hideinactivestaff,
               hideinactiveusers,
               hideinactivetasks,
               hideinactivetasktypes,
               hideinactivetimeoff,
               hideinactivegroups,
               hideinactivemessages,
               hidearchivedchildren,
               hidezerobalancefamilies,
               hideinactiveitems,
               hideinactivecertifications,
               hideinactiveareas,
               hideinactivewagetopups,
               hideinactivesurveyoptions,
               hideinactiveaccounts,
               hideinactiveagreements,
               hideinactivepriorities,
               hideinactiverecords,
               hideinactiveproviderchildren,
               hideeftfilestest,
               hideeftfilesinvalid,
               businessstarttime,
               businessendtime,
               childtimerounding,
               stafftimerounding,
               payrollrounding,
               payrollroundingtype,
               roundpayrollhours,
               roundclaimformhours,
               autofilltransactioncomment,
               autofeecalculationcomment,
               autoupdateschedule,
               hideweekendschedules,
               showpendingonschedule,
               showdropinsonbulkcharge,
               defaultfamilylist,
               enablestaffquickswitch,
               showemergencycontactoption,
               startpage,
               startpageparams,
               lastnamefirstchild,
               lastnamefirststaff,
               lastnamefirstprovider,
               hideweekendschildreports,
               useaccountnumbers,
               useitemnumbers,
               showchildabsentoption,
               transactionsperpage,
               showfulladdressonprofile,
               showworkaddressonprofile,
               confirmchildabsent,
               childprofiletitlealign,
               childprofiletitlesize,
               childprofiletitlecolormale,
               childprofiletitlecolorfemale,
               childprofileshowprogram,
               childprofileshowpicture,
               staffprofiletitlealign,
               staffprofiletitlesize,
               staffprofiletitlecolormale,
               staffprofiletitlecolorfemale,
               ignorezerocharges,
               stafftimelockdate,
               wagetopupmaxhours,
               wagetopupdefaultmonth,
               earningsdefaultmonth,
               infantcareincentivedefaultmonth,
               efttransactiondatecollections,
               efttransactiondatestaff,
               efttransactiondateproviders,
               shownoteschildattendance,
               splitinfantcareincentive,
               emailforonlineregistration,
               sortdayhomeadjustments,
               recordsperpagewaiting,
               recordsperpageunconfirmed,
               recordsperpageterminated,
               promptforpickuppersondaycare,
               promptforpickuppersonosc,
               promptforpickuppersondayhome,
               promptforpickuppersongrouphome,
               promptforpickuppersonpreschool,
               promptforpickuppersonecs,
               promptforpickuppersonother,
               calculatemultipliertype,
               grouptype,
               claimchargeitem,
               claimchargecomment,
               primarycolour,
               secondarycolour,
               tertiarycolour,
               quaternarycolour,
               quinarycolour,
               senarycolour,
               primarytextcolour,
               secondarytextcolour,
               tertiarytextcolour,
               quaternarytextcolour,
               quinarytextcolour,
               senarytextcolour,
               editabletextcolour,
               showselectordaycare,
               showselectorosc,
               showselectorpreschool,
               showselectordayhome,
               showselectorgrouphome,
               showselectorecs,
               showselectorother,
               lockbackupattendance,
               showsubsidyonattendance,
               showtimestamponattendance,
               centrenameonreports,
               newinvoiceopen,
               allchildrenactivethismonth,
               emailinvoicesto,
               emailreceiptsto,
               invoicemessage,
               showmedicalconcerns,
               showdietrestrictions,
               showallergies,
               showimmunizationquestions,
               showmedicationquestions
               from preferences where companyid = 1414
		   37 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   37 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   37 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   37 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   37 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   37 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   37 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   37 Query	select id, title, body from messages where companyid = 1414 and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:05'))
		   37 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid = 1414
		   37 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid = 1414
		   37 Query	select server from distribution where companyid = 1414
		   37 Query	select name from companies where id = 1414
		   37 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and (type = 'I' or type = 'BA') order by type,name
		   37 Query	select id, itemname from chargeitems where companyid = 1414 and active = 'Y' order by itemname
		   37 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = '' order by name
		   37 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = '' order by name
		   37 Query	select id from programtypes where companyid = 1414 and code = ''
		   37 Query	select id, code, label, alias from programtypes where companyid = 1414 and active = 'Y' and code not in ('dayhome') order by field(code,'daycare','osc','dayhome','preschool','grouphome','ecs','other')
		   37 Query	select id, itemname, amount from chargeitems where companyid = 1414 and (active = 'Y' or id = 0) order by itemname
		   37 Query	select itemname from chargeitems where id = 4508
		   37 Query	select itemname from chargeitems where id = 7795
		   37 Query	select itemname from chargeitems where id = 6833
		   37 Query	select itemname from chargeitems where id = 6201
		   37 Query	select itemname from chargeitems where id = 6202
		   37 Query	select itemname from chargeitems where id = 5976
		   37 Query	select itemname from chargeitems where id = 6533
		   37 Query	select itemname from chargeitems where id = 4507
		   37 Query	select itemname from chargeitems where id = 7289
		   37 Query	select itemname from chargeitems where id = 4506
		   37 Query	select itemname from chargeitems where id = 4505
		   37 Query	select itemname from chargeitems where id = 8082
		   37 Query	select itemname from chargeitems where id = 4504
		   37 Query	select itemname from chargeitems where id = 5975
		   37 Query	select itemname from chargeitems where id = 4503
		   37 Query	select itemname from chargeitems where id = 5973
		   37 Query	select itemname from chargeitems where id = 7651
		   37 Query	select itemname from chargeitems where id = 5977
		   37 Query	select itemname from chargeitems where id = 7302
		   37 Query	select itemname from chargeitems where id = 4509
		   37 Query	select itemname from chargeitems where id = 7913
		   37 Query	select itemname from chargeitems where id = 4501
		   37 Query	select itemname from chargeitems where id = 4500
		   37 Query	select itemname from chargeitems where id = 4499
		   37 Query	select itemname from chargeitems where id = 4502
		   37 Query	select itemname from chargeitems where id = 7186
		   37 Query	select itemname from chargeitems where id = 5974
		   37 Query	select id,code,label from feetypes
180803 20:05:39	   37 Query	select id from programtypes where companyid = 1414 and code = ''
		   37 Query	select id from programtypes where companyid = 1414 and code = ''
		   37 Query	select id, name, description from certifications where companyid = 1414 order by name
		   37 Query	select id,code,label from feetypes
		   37 Query	select id, name, parentaccountid from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = 'E' order by name
		   37 Query	select id, name from securityprofiles where companyid in (0,1414)
		   37 Query	select id, name from securityprofiles where companyid in (0,1414)
		   37 Query	select eftclientiddebits,eftclientidcredits,eftoriginatorshortname,eftcurrencyindicator from companies where id = 1414
		   37 Query	select id, name from families where companyid = 1414 and status = 'A' order by name
		   38 Quit
		   37 Quit
180803 20:05:41	   39 Connect	timesavr_dev@localhost on
		   39 Init DB	timesavr_dev
		   40 Connect	timesavr_dev@localhost on timesavr_dev
		   39 Query	select timezone from preferences where companyid =
		   39 Query	select active from programtypes where companyid =  and code = 'daycare'
		   39 Query	select active from programtypes where companyid =  and code = 'osc'
		   39 Query	select active from programtypes where companyid =  and code = 'preschool'
		   39 Query	select active from programtypes where companyid =  and code = 'ecs'
		   39 Query	select active from programtypes where companyid =  and code = 'grouphome'
		   39 Query	select active from programtypes where companyid =  and code = 'dayhome'
		   39 Query	select active from programtypes where companyid =  and code = 'other'
180803 20:05:42	   39 Query	select id, title, body from messages where companyid =  and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:05'))
		   39 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid =
		   39 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid =
		   39 Query	select server from distribution where companyid =
		   39 Query	select name from companies_serenity where id =
		   39 Init DB	timesavr_dev
		   41 Connect	timesavr_dev@localhost on timesavr_dev
		   39 Query	select password from users where username = 'earlylearning'
		   41 Quit
		   39 Init DB	timesavr_dev
		   42 Connect	timesavr_dev@localhost on timesavr_dev
		   39 Query	select id from users where username = 'earlylearning'
		   42 Quit
		   39 Query	select companyid from usercompanies where userid = 2661 and primarycompany = 'Y'
		   39 Query	select termsofservice from users where id = 2661
		   39 Query	select c.initialsetupcomplete, c.status from companies c, usercompanies uc where uc.companyid = c.id and uc.userid = 2661
		   39 Query	select startpage,startpageparams from preferences where companyid = 1414
		   39 Query	select securityprofile from users where id = 2661
		   39 Query	select dashboard access from securityprofiles where id = 1
		   39 Query	select code from programtypes where companyid = 1414 limit 1
		   39 Init DB	timesavr_dev
		   43 Connect	timesavr_dev@localhost on timesavr_dev
		   39 Query	select id from users where username = 'earlylearning'
		   43 Quit
		   39 Query	select status from companies where id = 1414
		   39 Query	insert into history_logins
                 (timestamp,companyid,accountstatus,userid,username,startpage,params,authenticated,errormessage,ipaddress,hostname)
                   values
                 ('2018-08-03 18:05:41','1414','A','2661','earlylearning','dashboard.php','','Y','','50.65.122.49','S0106a0ab1b97ced7.ed.shawcable.net')
		   40 Quit
		   39 Quit
		   44 Connect	timesavr_dev@localhost on
		   44 Init DB	timesavr_dev
		   45 Connect	timesavr_dev@localhost on timesavr_dev
		   44 Query	select timezone from preferences where companyid = 1414
		   44 Query	select companies.name companyname,
                       companies.email,
                       companies.id,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users,usercompanies uc, securityprofiles sp
                 where sp.id = users.securityprofile
                   and uc.userid = users.id
                   and uc.companyid = companies.id
                   and users.id = 2661 and uc.primarycompany = 'Y'
		   44 Query	select companies.name companyname,
                       companies.contactperson,
                       companies.email,
                       companies.phone,
                       companies.id,
                       companies.city,
                       companies.province,
                       companies.activescheduleid,
                       companies.initialsetupcomplete,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users, securityprofiles sp
                 where sp.id = users.securityprofile
                   and companies.id = 1414
		   44 Query	select hideinactivestaff,
               hideinactiveusers,
               hideinactivetasks,
               hideinactivetasktypes,
               hideinactivetimeoff,
               hideinactivegroups,
               hideinactivemessages,
               hidearchivedchildren,
               hidezerobalancefamilies,
               hideinactiveitems,
               hideinactivecertifications,
               hideinactiveareas,
               hideinactivewagetopups,
               hideinactivesurveyoptions,
               hideinactiveaccounts,
               hideinactiveagreements,
               hideinactivepriorities,
               hideinactiverecords,
               hideinactiveproviderchildren,
               hideeftfilestest,
               hideeftfilesinvalid,
               businessstarttime,
               businessendtime,
               childtimerounding,
               stafftimerounding,
               payrollrounding,
               payrollroundingtype,
               roundpayrollhours,
               roundclaimformhours,
               autofilltransactioncomment,
               autofeecalculationcomment,
               autoupdateschedule,
               hideweekendschedules,
               showpendingonschedule,
               showdropinsonbulkcharge,
               defaultfamilylist,
               enablestaffquickswitch,
               showemergencycontactoption,
               startpage,
               startpageparams,
               lastnamefirstchild,
               lastnamefirststaff,
               lastnamefirstprovider,
               hideweekendschildreports,
               useaccountnumbers,
               useitemnumbers,
               showchildabsentoption,
               transactionsperpage,
               showfulladdressonprofile,
               showworkaddressonprofile,
               confirmchildabsent,
               childprofiletitlealign,
               childprofiletitlesize,
               childprofiletitlecolormale,
               childprofiletitlecolorfemale,
               childprofileshowprogram,
               childprofileshowpicture,
               staffprofiletitlealign,
               staffprofiletitlesize,
               staffprofiletitlecolormale,
               staffprofiletitlecolorfemale,
               ignorezerocharges,
               stafftimelockdate,
               wagetopupmaxhours,
               wagetopupdefaultmonth,
               earningsdefaultmonth,
               infantcareincentivedefaultmonth,
               efttransactiondatecollections,
               efttransactiondatestaff,
               efttransactiondateproviders,
               shownoteschildattendance,
               splitinfantcareincentive,
               emailforonlineregistration,
               sortdayhomeadjustments,
               recordsperpagewaiting,
               recordsperpageunconfirmed,
               recordsperpageterminated,
               promptforpickuppersondaycare,
               promptforpickuppersonosc,
               promptforpickuppersondayhome,
               promptforpickuppersongrouphome,
               promptforpickuppersonpreschool,
               promptforpickuppersonecs,
               promptforpickuppersonother,
               calculatemultipliertype,
               grouptype,
               claimchargeitem,
               claimchargecomment,
               primarycolour,
               secondarycolour,
               tertiarycolour,
               quaternarycolour,
               quinarycolour,
               senarycolour,
               primarytextcolour,
               secondarytextcolour,
               tertiarytextcolour,
               quaternarytextcolour,
               quinarytextcolour,
               senarytextcolour,
               editabletextcolour,
               showselectordaycare,
               showselectorosc,
               showselectorpreschool,
               showselectordayhome,
               showselectorgrouphome,
               showselectorecs,
               showselectorother,
               lockbackupattendance,
               showsubsidyonattendance,
               showtimestamponattendance,
               centrenameonreports,
               newinvoiceopen,
               allchildrenactivethismonth,
               emailinvoicesto,
               emailreceiptsto,
               invoicemessage,
               showmedicalconcerns,
               showdietrestrictions,
               showallergies,
               showimmunizationquestions,
               showmedicationquestions
               from preferences where companyid = 1414
		   44 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   44 Query	select id, title, body from messages where companyid = 1414 and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:05'))
		   44 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid = 1414
		   44 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid = 1414
		   44 Query	select server from distribution where companyid = 1414
		   44 Query	select name from companies where id = 1414
		   44 Query	select killdate from companies where id = 1414
		   44 Query	select status from companies where id = 1414
		   44 Query	select killdate from companies where id = 1414
		   44 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and (type = 'I' or type = 'BA') order by type,name
		   44 Query	select id, itemname from chargeitems where companyid = 1414 and active = 'Y' order by itemname
		   44 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = '' order by name
		   44 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = '' order by name
		   44 Query	select id from programtypes where companyid = 1414 and code = ''
		   44 Query	select id, code, label, alias from programtypes where companyid = 1414 and active = 'Y' and code not in ('dayhome') order by field(code,'daycare','osc','dayhome','preschool','grouphome','ecs','other')
		   44 Query	select id, itemname, amount from chargeitems where companyid = 1414 and (active = 'Y' or id = 0) order by itemname
		   44 Query	select itemname from chargeitems where id = 4508
		   44 Query	select itemname from chargeitems where id = 7795
		   44 Query	select itemname from chargeitems where id = 6833
		   44 Query	select itemname from chargeitems where id = 6201
		   44 Query	select itemname from chargeitems where id = 6202
		   44 Query	select itemname from chargeitems where id = 5976
		   44 Query	select itemname from chargeitems where id = 6533
		   44 Query	select itemname from chargeitems where id = 4507
		   44 Query	select itemname from chargeitems where id = 7289
		   44 Query	select itemname from chargeitems where id = 4506
		   44 Query	select itemname from chargeitems where id = 4505
		   44 Query	select itemname from chargeitems where id = 8082
		   44 Query	select itemname from chargeitems where id = 4504
		   44 Query	select itemname from chargeitems where id = 5975
		   44 Query	select itemname from chargeitems where id = 4503
		   44 Query	select itemname from chargeitems where id = 5973
		   44 Query	select itemname from chargeitems where id = 7651
		   44 Query	select itemname from chargeitems where id = 5977
		   44 Query	select itemname from chargeitems where id = 7302
		   44 Query	select itemname from chargeitems where id = 4509
		   44 Query	select itemname from chargeitems where id = 7913
		   44 Query	select itemname from chargeitems where id = 4501
		   44 Query	select itemname from chargeitems where id = 4500
		   44 Query	select itemname from chargeitems where id = 4499
		   44 Query	select itemname from chargeitems where id = 4502
		   44 Query	select itemname from chargeitems where id = 7186
		   44 Query	select itemname from chargeitems where id = 5974
		   44 Query	select id,code,label from feetypes
		   44 Query	select id from programtypes where companyid = 1414 and code = ''
		   44 Query	select id from programtypes where companyid = 1414 and code = ''
		   44 Query	select id, name, description from certifications where companyid = 1414 order by name
		   44 Query	select id,code,label from feetypes
		   44 Query	select id, name, parentaccountid from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = 'E' order by name
		   44 Query	select id, name from securityprofiles where companyid in (0,1414)
		   44 Query	select id, name from securityprofiles where companyid in (0,1414)
		   44 Query	select eftclientiddebits,eftclientidcredits,eftoriginatorshortname,eftcurrencyindicator from companies where id = 1414
		   44 Query	select id, name from families where companyid = 1414 and status = 'A' order by name
		   44 Query	update companies set refreshneeded = 'N' where id = 1414
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dashboard access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafftab access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familiestab access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycareprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select oscprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select preschoolprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select ecsprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select grouphomeprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomeprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select otherprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select reportstab access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintab access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminfinance access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select financemenu access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyrevenue access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomefinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select settings access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafflist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintools access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select newstaff access from securityprofiles where id = 1
		   44 Query	SELECT id typeid FROM programtypes where companyid = 1414 and active = 'Y'
		   44 Query	select code from programtypes where id = 2411 and companyid = 1414
		   44 Query	select alias from programtypes where code = 'daycare' and companyid = 1414
		   44 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select count(*) newcount
      from children c
      where c.onlineregistration = 'Y'
      and c.onlineregistrationaccept = 'N'
      and c.registrationconfirmed = 'N'
      and c.companyid = 1414
      and (c.enddate is null or c.enddate > '2018-08-03' or c.enddate = '0000-00-00')
      and c.program = 'daycare'
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycareprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomeagency access from securityprofiles where id = 1
		   44 Query	select attend.id, attend.date, staff.firstname, attend.date, staff.id staffid
                       from staffattendance attend, staff
                      where attend.staffid = staff.id
                        and attend.needsattention = 1
                        and attend.date <> '2018-08-03'
                        and staff.companyid = 1414
180803 20:05:44	   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafflist access from securityprofiles where id = 1
		   44 Query	select firstname, lastname from users where id = 2661
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select id, firstname, lastname, title, primaryphone, alternatephone, emailaddress, active from staff where companyid = 1414 and active = 'Y' order by firstname,lastname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintab access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select newstaff access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select newstaff access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintools access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafflist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafflist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12157 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10234 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11791 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
180803 20:05:45	   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11704 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10769 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10639 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9506 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 8891 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11768 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11579 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9006 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11712 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11002 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9977 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12018 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11424 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9232 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9219 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11427 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11578 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9231 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9719 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10382 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9218 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7033 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffattendanceview access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7130 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafflist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafflist access from securityprofiles where id = 1
		   44 Query	select count(id) count from families where companyid = 1414 and status = 'A'
		   44 Query	select count(id) count from families where companyid = 1414 and status = 'I'
		   44 Query	select f.id,if(f.name='','No Name',f.name) name,f.balance,group_concat(c.firstname SEPARATOR ', ') children from families f left join children c on c.familyid = f.id where f.companyid = 1414 and f.status = 'A' group by f.id order by f.name
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select newfamily access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintools access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select activelist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyfinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select activelist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select activelist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select inactivelist access from securityprofiles where id = 1
		   44 Query	select r.id,r.label,r.sortorder, t.alias
                from groups r,
                     programtypes t
               where r.companyid = 1414
                 and r.type = t.id
                 and r.active = 'Y'
                 and t.code = 'daycare'
               order by r.sortorder, r.label
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycarenew access from securityprofiles where id = 1
		   44 Query	select alias from programtypes where code = 'daycare' and companyid = 1414
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycarenew access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycarenew access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycareratios access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycareactive access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycarewaiting access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycareunconfirmed access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycareterminated access from securityprofiles where id = 1
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and registrationconfirmed = 'N' and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00') and providerisparent = 'N' order by providerisparent desc, startdate asc
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and (registrationconfirmed = 'Y') and (startdate is null or startdate = '0000-00-00') and (enddate > '2018-08-03' or enddate = '0000-00-00' or enddate is null) and providerisparent = 'N' order by waitingsince asc
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and enddate < '2018-08-03' and enddate <> '0000-00-00' and enddate is not null order by enddate desc
		   44 Query	select count(*) newcount
      from children c
      where c.onlineregistration = 'Y'
      and c.onlineregistrationaccept = 'N'
      and c.registrationconfirmed = 'N'
      and c.companyid = 1414
      and (c.enddate is null or c.enddate > '2018-08-03' or c.enddate = '0000-00-00')
      and c.program = 'daycare'
180803 20:05:46	   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycareattendance access from securityprofiles where id = 1
		   44 Query	select timetrackingcode code
          from programtypes
          where companyid = 1414
            and code = 'daycare'
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select daycarelist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select enrolmentreports access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Enrolment' order by categorygroup, reportname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyreports access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Families' order by categorygroup, reportname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select childrenreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitprovider access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Children' order by categorygroup, reportname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Staff' order by categorygroup, reportname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Payroll' order by categorygroup, reportname
		   44 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select providerreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select subsidyreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Subsidy' order by categorygroup, reportname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select moneyreports access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Money' order by categorygroup, reportname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select toolsreports access from securityprofiles where id = 1
		   44 Query	select id, reportname, filename, categorygroup from reports where category = 'Tools' order by categorygroup, reportname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select centreprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select subscription access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminprogram access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminintake access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintools access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminstaff access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminsystemsetup access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminfinance access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminsecurity access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select cleanup access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomeworkload access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomesearch access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomeunconfirmedattendance access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomefinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomeadjustments access from securityprofiles where id = 1
		   44 Query	select id from providers where active = 'Y' and companyid = 1414 order by firstname,lastname limit 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminfinance access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select familyrevenue access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select dayhomefinancials access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select bulkcharge access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select moneyreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select bulkpayments access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select bulkpayments access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select moneyreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select subsidytracker access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select transactionsbin access from securityprofiles where id = 1
		   44 Query	select start,months,renewalfee from subscriptions where companyid = 1414 order by start desc limit 1
		   44 Query	SELECT c.expirydate FROM staffrecords c, staff s where s.id = c.entityid   and c.entitytype = 'staff'  and s.companyid = 1414  and s.active = 'Y' and c.active = 'Y'
		   44 Query	SELECT c.expirydate FROM staffrecords c, providers s where s.id = c.entityid   and c.entitytype = 'provider'  and s.companyid = 1414  and s.active = 'Y' and c.active = 'Y'
		   44 Query	select attend.id, attend.date, staff.firstname, attend.date, staff.id staffid
                       from staffattendance attend, staff
                      where attend.staffid = staff.id
                        and attend.needsattention = 1
                        and attend.date <> '2018-08-03'
                        and staff.companyid = 1414
180803 20:05:47	   44 Query	select id from childattendance
           where date < date('2018-08-03')
             and companyid = 1414
             and needsattention = 1
180803 20:05:48	   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffrecords access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintab access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select admintab access from securityprofiles where id = 1
		   44 Query	select id,firstname,lastname,email,emailupdates,securityprofile,username,password,active,primaryuser from users where id = 2661
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select userprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select changepassword access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select search access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select centreprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select centreprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select subscription access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminsecurity access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select centreswitch access from securityprofiles where id = 1
		   44 Query	select uc.companyid from usercompanies uc where uc.primarycompany = 'N' and uc.userid = 2661
		   44 Query	select id from usercompanies where userid = 3027 and primarycompany = 'N' and companyid = 1414
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminsecurity access from securityprofiles where id = 1
		   44 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   44 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   45 Prepare	select id, firstname, lastname, title, birthdate, active from staff where companyid = ? and active = 'Y' and payrollcode in ('S','H') order by firstname,lastname
		   45 Execute	select id, firstname, lastname, title, birthdate, active from staff where companyid = '1414' and active = 'Y' and payrollcode in ('S','H') order by firstname,lastname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select stafftab access from securityprofiles where id = 1
		   44 Query	select firstname, lastname from staff where id = 12157
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12157 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 10234
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10234 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11791
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11791 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11704
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11704 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 10769
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10769 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 10639
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10639 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9506
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9506 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 8891
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 8891 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11768
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11768 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11579
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11579 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9006
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9006 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11712
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11712 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11002
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11002 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9977
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9977 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 12018
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12018 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11424
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11424 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9232
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9232 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9219
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9219 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11427
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11427 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 11578
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11578 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9231
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9231 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9719
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9719 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 10382
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10382 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 9218
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9218 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 7033
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7033 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select firstname, lastname from staff where id = 7130
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select staffprofile access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select limitstaff access from securityprofiles where id = 1
		   44 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7130 and a.date = '2018-08-03' and a.starttime <= '18:05' and (a.endtime is null or a.endtime > '18:05')
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select newstaff access from securityprofiles where id = 1
		   44 Query	select id, firstname, lastname, title, active from staff where companyid = 1414 and active = 'Y' and payrollcode in ('V') order by firstname,lastname
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select enrolmentreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select moneyreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select moneyreports access from securityprofiles where id = 1
		   44 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '8' and year(t.date) = '2018' and t.transactiontype = 'C'
180803 20:05:49	   44 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '7' and year(t.date) = '2018' and t.transactiontype = 'C'
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select moneyreports access from securityprofiles where id = 1
		   44 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '8' and year(t.date) = '2018' and t.transactiontype = 'P'
		   44 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '7' and year(t.date) = '2018' and t.transactiontype = 'P'
		   44 Query	select sum(balance) balance
                            from families
                           where companyid = 1414 and status = 'A' and balance > 0
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select subsidyreports access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select subsidytracker access from securityprofiles where id = 1
		   44 Query	select programtype,year,month,count(id) claimcount, sum(expected) totalexpected, sum(received) totalreceived, (sum(expected) - sum(received)) balance
                        from subsidyclaims
                       where companyid = 1414
                         and resolved = 'N'
                       group by year,month order by year desc,month desc
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select activelist access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select inactivelist access from securityprofiles where id = 1
		   44 Query	select count(*) count from families where companyid = 1414 and status = 'A'
		   44 Query	select count(*) count from families where companyid = 1414 and status = 'I'
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select newfamily access from securityprofiles where id = 1
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select enrolmentreports access from securityprofiles where id = 1
		   44 Query	select count(id) totalactivecount
            from children
           where companyid = 1414
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   44 Query	select count(id) fulltimecount
            from children
           where companyid = 1414
             and (fullpart = 'F' or fullpart = '')
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   44 Query	select count(id) parttimecount
            from children
           where companyid = 1414
             and fullpart = 'P'
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   44 Query	select count(id) dropincount
            from children
           where companyid = 1414
             and fullpart = 'D'
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   44 Query	select r.id,r.label,r.description,r.parentfee,r.type,t.code,t.alias,r.active,r.providerid
                from groups r, programtypes t
               where r.type = t.id
                 and r.companyid = 1414
                 and t.active = 'Y'
                 and r.active = 'Y'
                 and t.code <> 'dayhome' order by r.type,r.sortorder,r.label
		   44 Query	select id from children where groupid = 3445
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   44 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3445
180803 20:05:50	   44 Query	select id from children where groupid = 3448
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   44 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3448
		   44 Query	select id from children where groupid = 3446
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   44 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3446
		   44 Query	select id from children where groupid = 3447
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   44 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   44 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   44 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3447
		   44 Query	select securityprofile from users where id = 2661
		   44 Query	select adminprogram access from securityprofiles where id = 1
		   44 Query	select starttime,id
          from childattendance
         where endtime is null
           and starttime > ''
           and date < date('2018-08-03')
           and companyid = 1414
		   45 Close stmt
		   45 Quit
		   44 Quit
180803 20:05:53	   47 Connect	timesavr_dev@localhost on
		   47 Init DB	timesavr_dev
		   48 Connect	timesavr_dev@localhost on timesavr_dev
		   46 Connect	timesavr_dev@localhost on
		   46 Init DB	timesavr_dev
		   47 Query	select timezone from preferences where companyid = 1414
		   49 Connect	timesavr_dev@localhost on timesavr_dev
		   47 Query	select companies.name companyname,
                       companies.email,
                       companies.id,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users,usercompanies uc, securityprofiles sp
                 where sp.id = users.securityprofile
                   and uc.userid = users.id
                   and uc.companyid = companies.id
                   and users.id = 2661 and uc.primarycompany = 'Y'
		   47 Query	select companies.name companyname,
                       companies.contactperson,
                       companies.email,
                       companies.phone,
                       companies.id,
                       companies.city,
                       companies.province,
                       companies.activescheduleid,
                       companies.initialsetupcomplete,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users, securityprofiles sp
                 where sp.id = users.securityprofile
                   and companies.id = 1414
		   47 Query	select hideinactivestaff,
               hideinactiveusers,
               hideinactivetasks,
               hideinactivetasktypes,
               hideinactivetimeoff,
               hideinactivegroups,
               hideinactivemessages,
               hidearchivedchildren,
               hidezerobalancefamilies,
               hideinactiveitems,
               hideinactivecertifications,
               hideinactiveareas,
               hideinactivewagetopups,
               hideinactivesurveyoptions,
               hideinactiveaccounts,
               hideinactiveagreements,
               hideinactivepriorities,
               hideinactiverecords,
               hideinactiveproviderchildren,
               hideeftfilestest,
               hideeftfilesinvalid,
               businessstarttime,
               businessendtime,
               childtimerounding,
               stafftimerounding,
               payrollrounding,
               payrollroundingtype,
               roundpayrollhours,
               roundclaimformhours,
               autofilltransactioncomment,
               autofeecalculationcomment,
               autoupdateschedule,
               hideweekendschedules,
               showpendingonschedule,
               showdropinsonbulkcharge,
               defaultfamilylist,
               enablestaffquickswitch,
               showemergencycontactoption,
               startpage,
               startpageparams,
               lastnamefirstchild,
               lastnamefirststaff,
               lastnamefirstprovider,
               hideweekendschildreports,
               useaccountnumbers,
               useitemnumbers,
               showchildabsentoption,
               transactionsperpage,
               showfulladdressonprofile,
               showworkaddressonprofile,
               confirmchildabsent,
               childprofiletitlealign,
               childprofiletitlesize,
               childprofiletitlecolormale,
               childprofiletitlecolorfemale,
               childprofileshowprogram,
               childprofileshowpicture,
               staffprofiletitlealign,
               staffprofiletitlesize,
               staffprofiletitlecolormale,
               staffprofiletitlecolorfemale,
               ignorezerocharges,
               stafftimelockdate,
               wagetopupmaxhours,
               wagetopupdefaultmonth,
               earningsdefaultmonth,
               infantcareincentivedefaultmonth,
               efttransactiondatecollections,
               efttransactiondatestaff,
               efttransactiondateproviders,
               shownoteschildattendance,
               splitinfantcareincentive,
               emailforonlineregistration,
               sortdayhomeadjustments,
               recordsperpagewaiting,
               recordsperpageunconfirmed,
               recordsperpageterminated,
               promptforpickuppersondaycare,
               promptforpickuppersonosc,
               promptforpickuppersondayhome,
               promptforpickuppersongrouphome,
               promptforpickuppersonpreschool,
               promptforpickuppersonecs,
               promptforpickuppersonother,
               calculatemultipliertype,
               grouptype,
               claimchargeitem,
               claimchargecomment,
               primarycolour,
               secondarycolour,
               tertiarycolour,
               quaternarycolour,
               quinarycolour,
               senarycolour,
               primarytextcolour,
               secondarytextcolour,
               tertiarytextcolour,
               quaternarytextcolour,
               quinarytextcolour,
               senarytextcolour,
               editabletextcolour,
               showselectordaycare,
               showselectorosc,
               showselectorpreschool,
               showselectordayhome,
               showselectorgrouphome,
               showselectorecs,
               showselectorother,
               lockbackupattendance,
               showsubsidyonattendance,
               showtimestamponattendance,
               centrenameonreports,
               newinvoiceopen,
               allchildrenactivethismonth,
               emailinvoicesto,
               emailreceiptsto,
               invoicemessage,
               showmedicalconcerns,
               showdietrestrictions,
               showallergies,
               showimmunizationquestions,
               showmedicationquestions
               from preferences where companyid = 1414
		   47 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   47 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   47 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   47 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   47 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   47 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   47 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   47 Query	select id, title, body from messages where companyid = 1414 and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:05'))
		   47 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid = 1414
		   47 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid = 1414
		   47 Query	select server from distribution where companyid = 1414
		   47 Query	select name from companies where id = 1414
		   47 Query	select count(c.id) count from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and curdate() >= s.startdate and date_add(date_format(curdate() ,'%Y-%m-01'),interval 1 month) <= s.enddate and c.subsidynotrequired = 'N'
		   47 Query	select count(*) count from (select c.id,max(s.enddate) maxenddate from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and c.registrationconfirmed = 'Y' and (c.startdate is not null and c.startdate <> '0000-00-00')  and c.subsidynotrequired = 'N' group by c.id having curdate() > maxenddate order by c.id,s.enddate) results
		   47 Query	select count(*) count from (select c.id,max(s.startdate),s.enddate from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and curdate() <= s.enddate and date_add(date_format(curdate() ,'%Y-%m-01'),interval 1 month) > s.enddate and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and c.registrationconfirmed = 'Y' and (c.startdate is not null and c.startdate <> '0000-00-00') and c.subsidynotrequired = 'N' group by c.id order by c.id,s.startdate) results
		   47 Query	select count(c.id) count from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and c.subsidynotrequired = 'Y'
		   48 Quit
		   47 Quit
		   46 Query	select timezone from preferences where companyid = 1414
		   46 Query	select companies.name companyname,
                       companies.email,
                       companies.id,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users,usercompanies uc, securityprofiles sp
                 where sp.id = users.securityprofile
                   and uc.userid = users.id
                   and uc.companyid = companies.id
                   and users.id = 2661 and uc.primarycompany = 'Y'
		   46 Query	select companies.name companyname,
                       companies.contactperson,
                       companies.email,
                       companies.phone,
                       companies.id,
                       companies.city,
                       companies.province,
                       companies.activescheduleid,
                       companies.initialsetupcomplete,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users, securityprofiles sp
                 where sp.id = users.securityprofile
                   and companies.id = 1414
		   46 Query	select hideinactivestaff,
               hideinactiveusers,
               hideinactivetasks,
               hideinactivetasktypes,
               hideinactivetimeoff,
               hideinactivegroups,
               hideinactivemessages,
               hidearchivedchildren,
               hidezerobalancefamilies,
               hideinactiveitems,
               hideinactivecertifications,
               hideinactiveareas,
               hideinactivewagetopups,
               hideinactivesurveyoptions,
               hideinactiveaccounts,
               hideinactiveagreements,
               hideinactivepriorities,
               hideinactiverecords,
               hideinactiveproviderchildren,
               hideeftfilestest,
               hideeftfilesinvalid,
               businessstarttime,
               businessendtime,
               childtimerounding,
               stafftimerounding,
               payrollrounding,
               payrollroundingtype,
               roundpayrollhours,
               roundclaimformhours,
               autofilltransactioncomment,
               autofeecalculationcomment,
               autoupdateschedule,
               hideweekendschedules,
               showpendingonschedule,
               showdropinsonbulkcharge,
               defaultfamilylist,
               enablestaffquickswitch,
               showemergencycontactoption,
               startpage,
               startpageparams,
               lastnamefirstchild,
               lastnamefirststaff,
               lastnamefirstprovider,
               hideweekendschildreports,
               useaccountnumbers,
               useitemnumbers,
               showchildabsentoption,
               transactionsperpage,
               showfulladdressonprofile,
               showworkaddressonprofile,
               confirmchildabsent,
               childprofiletitlealign,
               childprofiletitlesize,
               childprofiletitlecolormale,
               childprofiletitlecolorfemale,
               childprofileshowprogram,
               childprofileshowpicture,
               staffprofiletitlealign,
               staffprofiletitlesize,
               staffprofiletitlecolormale,
               staffprofiletitlecolorfemale,
               ignorezerocharges,
               stafftimelockdate,
               wagetopupmaxhours,
               wagetopupdefaultmonth,
               earningsdefaultmonth,
               infantcareincentivedefaultmonth,
               efttransactiondatecollections,
               efttransactiondatestaff,
               efttransactiondateproviders,
               shownoteschildattendance,
               splitinfantcareincentive,
               emailforonlineregistration,
               sortdayhomeadjustments,
               recordsperpagewaiting,
               recordsperpageunconfirmed,
               recordsperpageterminated,
               promptforpickuppersondaycare,
               promptforpickuppersonosc,
               promptforpickuppersondayhome,
               promptforpickuppersongrouphome,
               promptforpickuppersonpreschool,
               promptforpickuppersonecs,
               promptforpickuppersonother,
               calculatemultipliertype,
               grouptype,
               claimchargeitem,
               claimchargecomment,
               primarycolour,
               secondarycolour,
               tertiarycolour,
               quaternarycolour,
               quinarycolour,
               senarycolour,
               primarytextcolour,
               secondarytextcolour,
               tertiarytextcolour,
               quaternarytextcolour,
               quinarytextcolour,
               senarytextcolour,
               editabletextcolour,
               showselectordaycare,
               showselectorosc,
               showselectorpreschool,
               showselectordayhome,
               showselectorgrouphome,
               showselectorecs,
               showselectorother,
               lockbackupattendance,
               showsubsidyonattendance,
               showtimestamponattendance,
               centrenameonreports,
               newinvoiceopen,
               allchildrenactivethismonth,
               emailinvoicesto,
               emailreceiptsto,
               invoicemessage,
               showmedicalconcerns,
               showdietrestrictions,
               showallergies,
               showimmunizationquestions,
               showmedicationquestions
               from preferences where companyid = 1414
		   46 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   46 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   46 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   46 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   46 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   46 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   46 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   46 Query	select id, title, body from messages where companyid = 1414 and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:05'))
		   46 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid = 1414
		   46 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid = 1414
		   46 Query	select server from distribution where companyid = 1414
		   46 Query	select name from companies where id = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-1-01' and '2018-1-31' and companyid = 1414
180803 20:05:54	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-1-01' and '2017-1-31' and companyid = 1414
180803 20:05:55	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-2-01' and '2018-2-28' and companyid = 1414
180803 20:05:56	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-2-01' and '2017-2-28' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-3-01' and '2018-3-31' and companyid = 1414
180803 20:05:57	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-3-01' and '2017-3-31' and companyid = 1414
180803 20:05:58	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-4-01' and '2018-4-30' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-4-01' and '2017-4-30' and companyid = 1414
180803 20:05:59	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-5-01' and '2018-5-31' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-5-01' and '2017-5-31' and companyid = 1414
180803 20:06:00	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-6-01' and '2018-6-30' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-6-01' and '2017-6-30' and companyid = 1414
180803 20:06:01	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-7-01' and '2018-7-31' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-7-01' and '2017-7-31' and companyid = 1414
180803 20:06:02	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-8-01' and '2018-8-31' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-8-01' and '2017-8-31' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-9-01' and '2018-9-30' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-9-01' and '2017-9-30' and companyid = 1414
180803 20:06:03	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-10-01' and '2018-10-31' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-10-01' and '2017-10-31' and companyid = 1414
180803 20:06:05	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-11-01' and '2018-11-30' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-11-01' and '2017-11-30' and companyid = 1414
180803 20:06:06	   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-12-01' and '2018-12-31' and companyid = 1414
		   46 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-12-01' and '2017-12-31' and companyid = 1414
180803 20:06:07	   49 Quit
		   46 Quit
180803 20:06:55	   50 Connect	timesavr_dev@localhost on
		   50 Init DB	timesavr_dev
		   51 Connect	timesavr_dev@localhost on timesavr_dev
		   50 Query	select timezone from preferences where companyid = 1414
		   50 Query	select companies.name companyname,
                       companies.email,
                       companies.id,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users,usercompanies uc, securityprofiles sp
                 where sp.id = users.securityprofile
                   and uc.userid = users.id
                   and uc.companyid = companies.id
                   and users.id = 2661 and uc.primarycompany = 'Y'
		   50 Query	select companies.name companyname,
                       companies.contactperson,
                       companies.email,
                       companies.phone,
                       companies.id,
                       companies.city,
                       companies.province,
                       companies.activescheduleid,
                       companies.initialsetupcomplete,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users, securityprofiles sp
                 where sp.id = users.securityprofile
                   and companies.id = 1414
		   50 Query	select hideinactivestaff,
               hideinactiveusers,
               hideinactivetasks,
               hideinactivetasktypes,
               hideinactivetimeoff,
               hideinactivegroups,
               hideinactivemessages,
               hidearchivedchildren,
               hidezerobalancefamilies,
               hideinactiveitems,
               hideinactivecertifications,
               hideinactiveareas,
               hideinactivewagetopups,
               hideinactivesurveyoptions,
               hideinactiveaccounts,
               hideinactiveagreements,
               hideinactivepriorities,
               hideinactiverecords,
               hideinactiveproviderchildren,
               hideeftfilestest,
               hideeftfilesinvalid,
               businessstarttime,
               businessendtime,
               childtimerounding,
               stafftimerounding,
               payrollrounding,
               payrollroundingtype,
               roundpayrollhours,
               roundclaimformhours,
               autofilltransactioncomment,
               autofeecalculationcomment,
               autoupdateschedule,
               hideweekendschedules,
               showpendingonschedule,
               showdropinsonbulkcharge,
               defaultfamilylist,
               enablestaffquickswitch,
               showemergencycontactoption,
               startpage,
               startpageparams,
               lastnamefirstchild,
               lastnamefirststaff,
               lastnamefirstprovider,
               hideweekendschildreports,
               useaccountnumbers,
               useitemnumbers,
               showchildabsentoption,
               transactionsperpage,
               showfulladdressonprofile,
               showworkaddressonprofile,
               confirmchildabsent,
               childprofiletitlealign,
               childprofiletitlesize,
               childprofiletitlecolormale,
               childprofiletitlecolorfemale,
               childprofileshowprogram,
               childprofileshowpicture,
               staffprofiletitlealign,
               staffprofiletitlesize,
               staffprofiletitlecolormale,
               staffprofiletitlecolorfemale,
               ignorezerocharges,
               stafftimelockdate,
               wagetopupmaxhours,
               wagetopupdefaultmonth,
               earningsdefaultmonth,
               infantcareincentivedefaultmonth,
               efttransactiondatecollections,
               efttransactiondatestaff,
               efttransactiondateproviders,
               shownoteschildattendance,
               splitinfantcareincentive,
               emailforonlineregistration,
               sortdayhomeadjustments,
               recordsperpagewaiting,
               recordsperpageunconfirmed,
               recordsperpageterminated,
               promptforpickuppersondaycare,
               promptforpickuppersonosc,
               promptforpickuppersondayhome,
               promptforpickuppersongrouphome,
               promptforpickuppersonpreschool,
               promptforpickuppersonecs,
               promptforpickuppersonother,
               calculatemultipliertype,
               grouptype,
               claimchargeitem,
               claimchargecomment,
               primarycolour,
               secondarycolour,
               tertiarycolour,
               quaternarycolour,
               quinarycolour,
               senarycolour,
               primarytextcolour,
               secondarytextcolour,
               tertiarytextcolour,
               quaternarytextcolour,
               quinarytextcolour,
               senarytextcolour,
               editabletextcolour,
               showselectordaycare,
               showselectorosc,
               showselectorpreschool,
               showselectordayhome,
               showselectorgrouphome,
               showselectorecs,
               showselectorother,
               lockbackupattendance,
               showsubsidyonattendance,
               showtimestamponattendance,
               centrenameonreports,
               newinvoiceopen,
               allchildrenactivethismonth,
               emailinvoicesto,
               emailreceiptsto,
               invoicemessage,
               showmedicalconcerns,
               showdietrestrictions,
               showallergies,
               showimmunizationquestions,
               showmedicationquestions
               from preferences where companyid = 1414
		   50 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   50 Query	select id, title, body from messages where companyid = 1414 and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:06'))
		   50 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid = 1414
		   50 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid = 1414
		   50 Query	select server from distribution where companyid = 1414
		   50 Query	select name from companies where id = 1414
		   50 Query	select killdate from companies where id = 1414
		   50 Query	select status from companies where id = 1414
		   50 Query	select killdate from companies where id = 1414
		   50 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and (type = 'I' or type = 'BA') order by type,name
		   50 Query	select id, itemname from chargeitems where companyid = 1414 and active = 'Y' order by itemname
		   50 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = '' order by name
		   50 Query	select id, name from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = '' order by name
		   50 Query	select id from programtypes where companyid = 1414 and code = ''
		   50 Query	select id, code, label, alias from programtypes where companyid = 1414 and active = 'Y' and code not in ('dayhome') order by field(code,'daycare','osc','dayhome','preschool','grouphome','ecs','other')
		   50 Query	select id, itemname, amount from chargeitems where companyid = 1414 and (active = 'Y' or id = 0) order by itemname
		   50 Query	select itemname from chargeitems where id = 4508
		   50 Query	select itemname from chargeitems where id = 7795
		   50 Query	select itemname from chargeitems where id = 6833
		   50 Query	select itemname from chargeitems where id = 6201
		   50 Query	select itemname from chargeitems where id = 6202
		   50 Query	select itemname from chargeitems where id = 5976
		   50 Query	select itemname from chargeitems where id = 6533
		   50 Query	select itemname from chargeitems where id = 4507
		   50 Query	select itemname from chargeitems where id = 7289
		   50 Query	select itemname from chargeitems where id = 4506
		   50 Query	select itemname from chargeitems where id = 4505
		   50 Query	select itemname from chargeitems where id = 8082
		   50 Query	select itemname from chargeitems where id = 4504
		   50 Query	select itemname from chargeitems where id = 5975
		   50 Query	select itemname from chargeitems where id = 4503
		   50 Query	select itemname from chargeitems where id = 5973
		   50 Query	select itemname from chargeitems where id = 7651
		   50 Query	select itemname from chargeitems where id = 5977
		   50 Query	select itemname from chargeitems where id = 7302
		   50 Query	select itemname from chargeitems where id = 4509
		   50 Query	select itemname from chargeitems where id = 7913
		   50 Query	select itemname from chargeitems where id = 4501
		   50 Query	select itemname from chargeitems where id = 4500
		   50 Query	select itemname from chargeitems where id = 4499
		   50 Query	select itemname from chargeitems where id = 4502
		   50 Query	select itemname from chargeitems where id = 7186
		   50 Query	select itemname from chargeitems where id = 5974
		   50 Query	select id,code,label from feetypes
		   50 Query	select id from programtypes where companyid = 1414 and code = ''
		   50 Query	select id from programtypes where companyid = 1414 and code = ''
		   50 Query	select id, name, description from certifications where companyid = 1414 order by name
		   50 Query	select id,code,label from feetypes
		   50 Query	select id, name, parentaccountid from accounts where companyid = 1414 and active = 'Y' and type <> 'AP' and type = 'E' order by name
		   50 Query	select id, name from securityprofiles where companyid in (0,1414)
		   50 Query	select id, name from securityprofiles where companyid in (0,1414)
		   50 Query	select eftclientiddebits,eftclientidcredits,eftoriginatorshortname,eftcurrencyindicator from companies where id = 1414
		   50 Query	select id, name from families where companyid = 1414 and status = 'A' order by name
		   50 Query	update companies set refreshneeded = 'N' where id = 1414
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dashboard access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafftab access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familiestab access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycareprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select oscprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select preschoolprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select ecsprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select grouphomeprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomeprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select otherprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select reportstab access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintab access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminfinance access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select financemenu access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyrevenue access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomefinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select settings access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafflist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintools access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select newstaff access from securityprofiles where id = 1
		   50 Query	SELECT id typeid FROM programtypes where companyid = 1414 and active = 'Y'
		   50 Query	select code from programtypes where id = 2411 and companyid = 1414
		   50 Query	select alias from programtypes where code = 'daycare' and companyid = 1414
		   50 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select count(*) newcount
      from children c
      where c.onlineregistration = 'Y'
      and c.onlineregistrationaccept = 'N'
      and c.registrationconfirmed = 'N'
      and c.companyid = 1414
      and (c.enddate is null or c.enddate > '2018-08-03' or c.enddate = '0000-00-00')
      and c.program = 'daycare'
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycareprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomeagency access from securityprofiles where id = 1
		   50 Query	select attend.id, attend.date, staff.firstname, attend.date, staff.id staffid
                       from staffattendance attend, staff
                      where attend.staffid = staff.id
                        and attend.needsattention = 1
                        and attend.date <> '2018-08-03'
                        and staff.companyid = 1414
180803 20:06:57	   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafflist access from securityprofiles where id = 1
		   50 Query	select firstname, lastname from users where id = 2661
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select id, firstname, lastname, title, primaryphone, alternatephone, emailaddress, active from staff where companyid = 1414 and active = 'Y' order by firstname,lastname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintab access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select newstaff access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select newstaff access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintools access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafflist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafflist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12157 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10234 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11791 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11704 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10769 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10639 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9506 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 8891 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11768 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11579 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9006 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11712 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11002 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9977 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12018 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11424 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9232 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9219 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11427 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11578 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9231 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9719 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
180803 20:06:58	   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10382 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9218 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7033 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffattendanceview access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7130 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafflist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafflist access from securityprofiles where id = 1
		   50 Query	select count(id) count from families where companyid = 1414 and status = 'A'
		   50 Query	select count(id) count from families where companyid = 1414 and status = 'I'
		   50 Query	select f.id,if(f.name='','No Name',f.name) name,f.balance,group_concat(c.firstname SEPARATOR ', ') children from families f left join children c on c.familyid = f.id where f.companyid = 1414 and f.status = 'A' group by f.id order by f.name
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select newfamily access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintools access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select activelist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyfinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select activelist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select activelist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select inactivelist access from securityprofiles where id = 1
		   50 Query	select r.id,r.label,r.sortorder, t.alias
                from groups r,
                     programtypes t
               where r.companyid = 1414
                 and r.type = t.id
                 and r.active = 'Y'
                 and t.code = 'daycare'
               order by r.sortorder, r.label
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycarenew access from securityprofiles where id = 1
		   50 Query	select alias from programtypes where code = 'daycare' and companyid = 1414
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycarenew access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycarenew access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycareratios access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycareactive access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycarewaiting access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycareunconfirmed access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycareterminated access from securityprofiles where id = 1
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and registrationconfirmed = 'N' and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00') and providerisparent = 'N' order by providerisparent desc, startdate asc
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and (registrationconfirmed = 'Y') and (startdate is null or startdate = '0000-00-00') and (enddate > '2018-08-03' or enddate = '0000-00-00' or enddate is null) and providerisparent = 'N' order by waitingsince asc
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and enddate < '2018-08-03' and enddate <> '0000-00-00' and enddate is not null order by enddate desc
		   50 Query	select count(*) newcount
      from children c
      where c.onlineregistration = 'Y'
      and c.onlineregistrationaccept = 'N'
      and c.registrationconfirmed = 'N'
      and c.companyid = 1414
      and (c.enddate is null or c.enddate > '2018-08-03' or c.enddate = '0000-00-00')
      and c.program = 'daycare'
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycareattendance access from securityprofiles where id = 1
		   50 Query	select timetrackingcode code
          from programtypes
          where companyid = 1414
            and code = 'daycare'
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select daycarelist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select enrolmentreports access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Enrolment' order by categorygroup, reportname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyreports access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Families' order by categorygroup, reportname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select childrenreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitprovider access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Children' order by categorygroup, reportname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Staff' order by categorygroup, reportname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Payroll' order by categorygroup, reportname
		   50 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select providerreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select subsidyreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Subsidy' order by categorygroup, reportname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select moneyreports access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Money' order by categorygroup, reportname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select toolsreports access from securityprofiles where id = 1
		   50 Query	select id, reportname, filename, categorygroup from reports where category = 'Tools' order by categorygroup, reportname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select centreprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select subscription access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminprogram access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminintake access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintools access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminstaff access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminsystemsetup access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminfinance access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminsecurity access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select cleanup access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomeworkload access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomesearch access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomeunconfirmedattendance access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomefinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomeadjustments access from securityprofiles where id = 1
		   50 Query	select id from providers where active = 'Y' and companyid = 1414 order by firstname,lastname limit 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminfinance access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select familyrevenue access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select dayhomefinancials access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select bulkcharge access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select moneyreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select bulkpayments access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select bulkpayments access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select moneyreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select subsidytracker access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select transactionsbin access from securityprofiles where id = 1
		   50 Query	select start,months,renewalfee from subscriptions where companyid = 1414 order by start desc limit 1
		   50 Query	SELECT c.expirydate FROM staffrecords c, staff s where s.id = c.entityid   and c.entitytype = 'staff'  and s.companyid = 1414  and s.active = 'Y' and c.active = 'Y'
		   50 Query	SELECT c.expirydate FROM staffrecords c, providers s where s.id = c.entityid   and c.entitytype = 'provider'  and s.companyid = 1414  and s.active = 'Y' and c.active = 'Y'
		   50 Query	select attend.id, attend.date, staff.firstname, attend.date, staff.id staffid
                       from staffattendance attend, staff
                      where attend.staffid = staff.id
                        and attend.needsattention = 1
                        and attend.date <> '2018-08-03'
                        and staff.companyid = 1414
180803 20:07:00	   50 Query	select id from childattendance
           where date < date('2018-08-03')
             and companyid = 1414
             and needsattention = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffrecords access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintab access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select admintab access from securityprofiles where id = 1
		   50 Query	select id,firstname,lastname,email,emailupdates,securityprofile,username,password,active,primaryuser from users where id = 2661
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select userprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select changepassword access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select search access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select centreprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select centreprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select subscription access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminsecurity access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select centreswitch access from securityprofiles where id = 1
		   50 Query	select uc.companyid from usercompanies uc where uc.primarycompany = 'N' and uc.userid = 2661
		   50 Query	select id from usercompanies where userid = 3027 and primarycompany = 'N' and companyid = 1414
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminsecurity access from securityprofiles where id = 1
		   50 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   50 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   51 Prepare	select id, firstname, lastname, title, birthdate, active from staff where companyid = ? and active = 'Y' and payrollcode in ('S','H') order by firstname,lastname
		   51 Execute	select id, firstname, lastname, title, birthdate, active from staff where companyid = '1414' and active = 'Y' and payrollcode in ('S','H') order by firstname,lastname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select stafftab access from securityprofiles where id = 1
		   50 Query	select firstname, lastname from staff where id = 12157
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12157 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
180803 20:07:01	   50 Query	select firstname, lastname from staff where id = 10234
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10234 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11791
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11791 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11704
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11704 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 10769
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10769 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 10639
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10639 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9506
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9506 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 8891
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 8891 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11768
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11768 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11579
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11579 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9006
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9006 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11712
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11712 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11002
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11002 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9977
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9977 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 12018
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 12018 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11424
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11424 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9232
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9232 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9219
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9219 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11427
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11427 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 11578
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 11578 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9231
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9231 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9719
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9719 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 10382
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 10382 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 9218
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 9218 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 7033
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7033 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select firstname, lastname from staff where id = 7130
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select staffprofile access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select limitstaff access from securityprofiles where id = 1
		   50 Query	select a.taskid,t.label from staffattendance a, tasks t where a.taskid = t.id and a.staffid = 7130 and a.date = '2018-08-03' and a.starttime <= '18:06' and (a.endtime is null or a.endtime > '18:06')
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select newstaff access from securityprofiles where id = 1
		   50 Query	select id, firstname, lastname, title, active from staff where companyid = 1414 and active = 'Y' and payrollcode in ('V') order by firstname,lastname
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select enrolmentreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select moneyreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select moneyreports access from securityprofiles where id = 1
		   50 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '8' and year(t.date) = '2018' and t.transactiontype = 'C'
180803 20:07:02	   50 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '7' and year(t.date) = '2018' and t.transactiontype = 'C'
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select moneyreports access from securityprofiles where id = 1
		   50 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '8' and year(t.date) = '2018' and t.transactiontype = 'P'
		   50 Query	select sum(t.amount) total
                            from transactions t, families f
                           where t.familyid = f.id and f.companyid = 1414 and month(t.date) = '7' and year(t.date) = '2018' and t.transactiontype = 'P'
		   50 Query	select sum(balance) balance
                            from families
                           where companyid = 1414 and status = 'A' and balance > 0
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select subsidyreports access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select subsidytracker access from securityprofiles where id = 1
		   50 Query	select programtype,year,month,count(id) claimcount, sum(expected) totalexpected, sum(received) totalreceived, (sum(expected) - sum(received)) balance
                        from subsidyclaims
                       where companyid = 1414
                         and resolved = 'N'
                       group by year,month order by year desc,month desc
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select activelist access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select inactivelist access from securityprofiles where id = 1
		   50 Query	select count(*) count from families where companyid = 1414 and status = 'A'
		   50 Query	select count(*) count from families where companyid = 1414 and status = 'I'
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select newfamily access from securityprofiles where id = 1
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select enrolmentreports access from securityprofiles where id = 1
		   50 Query	select count(id) totalactivecount
            from children
           where companyid = 1414
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   50 Query	select count(id) fulltimecount
            from children
           where companyid = 1414
             and (fullpart = 'F' or fullpart = '')
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   50 Query	select count(id) parttimecount
            from children
           where companyid = 1414
             and fullpart = 'P'
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   50 Query	select count(id) dropincount
            from children
           where companyid = 1414
             and fullpart = 'D'
             and ((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00'))
		   50 Query	select r.id,r.label,r.description,r.parentfee,r.type,t.code,t.alias,r.active,r.providerid
                from groups r, programtypes t
               where r.type = t.id
                 and r.companyid = 1414
                 and t.active = 'Y'
                 and r.active = 'Y'
                 and t.code <> 'dayhome' order by r.type,r.sortorder,r.label
		   50 Query	select id from children where groupid = 3445
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   50 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3445
		   50 Query	select id from children where groupid = 3448
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   50 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3448
		   50 Query	select id from children where groupid = 3446
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   50 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3446
		   50 Query	select id from children where groupid = 3447
             and ((((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate > '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')))
		   50 Query	select id from programtypes where companyid = 1414 and code = 'daycare'
		   50 Query	select id from children where companyid = 1414 and program = 'daycare' and (((registrationconfirmed = 'Y') and (startdate is not null and startdate <> '0000-00-00') and (enddate is null or enddate >= '2018-08-03' or enddate = '0000-00-00')) or  (providerisparent = 'Y')) order by providerisparent desc, birthdate desc
		   50 Query	select count(a.id) childcount
                  from childattendance a, children c
                  where c.id = a.childid
                  and a.date = '2018-08-03'
                  and a.starttime is not null
                  and a.endtime is null
                  and a.groupid = 3447
		   50 Query	select securityprofile from users where id = 2661
		   50 Query	select adminprogram access from securityprofiles where id = 1
		   50 Query	select starttime,id
          from childattendance
         where endtime is null
           and starttime > ''
           and date < date('2018-08-03')
           and companyid = 1414
180803 20:07:03	   51 Close stmt
		   51 Quit
		   50 Quit
180803 20:07:05	   53 Connect	timesavr_dev@localhost on
		   52 Connect	timesavr_dev@localhost on
		   53 Init DB	timesavr_dev
		   52 Init DB	timesavr_dev
		   54 Connect	timesavr_dev@localhost on timesavr_dev
		   55 Connect	timesavr_dev@localhost on timesavr_dev
		   53 Query	select timezone from preferences where companyid = 1414
		   53 Query	select companies.name companyname,
                       companies.email,
                       companies.id,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users,usercompanies uc, securityprofiles sp
                 where sp.id = users.securityprofile
                   and uc.userid = users.id
                   and uc.companyid = companies.id
                   and users.id = 2661 and uc.primarycompany = 'Y'
		   53 Query	select companies.name companyname,
                       companies.contactperson,
                       companies.email,
                       companies.phone,
                       companies.id,
                       companies.city,
                       companies.province,
                       companies.activescheduleid,
                       companies.initialsetupcomplete,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users, securityprofiles sp
                 where sp.id = users.securityprofile
                   and companies.id = 1414
		   53 Query	select hideinactivestaff,
               hideinactiveusers,
               hideinactivetasks,
               hideinactivetasktypes,
               hideinactivetimeoff,
               hideinactivegroups,
               hideinactivemessages,
               hidearchivedchildren,
               hidezerobalancefamilies,
               hideinactiveitems,
               hideinactivecertifications,
               hideinactiveareas,
               hideinactivewagetopups,
               hideinactivesurveyoptions,
               hideinactiveaccounts,
               hideinactiveagreements,
               hideinactivepriorities,
               hideinactiverecords,
               hideinactiveproviderchildren,
               hideeftfilestest,
               hideeftfilesinvalid,
               businessstarttime,
               businessendtime,
               childtimerounding,
               stafftimerounding,
               payrollrounding,
               payrollroundingtype,
               roundpayrollhours,
               roundclaimformhours,
               autofilltransactioncomment,
               autofeecalculationcomment,
               autoupdateschedule,
               hideweekendschedules,
               showpendingonschedule,
               showdropinsonbulkcharge,
               defaultfamilylist,
               enablestaffquickswitch,
               showemergencycontactoption,
               startpage,
               startpageparams,
               lastnamefirstchild,
               lastnamefirststaff,
               lastnamefirstprovider,
               hideweekendschildreports,
               useaccountnumbers,
               useitemnumbers,
               showchildabsentoption,
               transactionsperpage,
               showfulladdressonprofile,
               showworkaddressonprofile,
               confirmchildabsent,
               childprofiletitlealign,
               childprofiletitlesize,
               childprofiletitlecolormale,
               childprofiletitlecolorfemale,
               childprofileshowprogram,
               childprofileshowpicture,
               staffprofiletitlealign,
               staffprofiletitlesize,
               staffprofiletitlecolormale,
               staffprofiletitlecolorfemale,
               ignorezerocharges,
               stafftimelockdate,
               wagetopupmaxhours,
               wagetopupdefaultmonth,
               earningsdefaultmonth,
               infantcareincentivedefaultmonth,
               efttransactiondatecollections,
               efttransactiondatestaff,
               efttransactiondateproviders,
               shownoteschildattendance,
               splitinfantcareincentive,
               emailforonlineregistration,
               sortdayhomeadjustments,
               recordsperpagewaiting,
               recordsperpageunconfirmed,
               recordsperpageterminated,
               promptforpickuppersondaycare,
               promptforpickuppersonosc,
               promptforpickuppersondayhome,
               promptforpickuppersongrouphome,
               promptforpickuppersonpreschool,
               promptforpickuppersonecs,
               promptforpickuppersonother,
               calculatemultipliertype,
               grouptype,
               claimchargeitem,
               claimchargecomment,
               primarycolour,
               secondarycolour,
               tertiarycolour,
               quaternarycolour,
               quinarycolour,
               senarycolour,
               primarytextcolour,
               secondarytextcolour,
               tertiarytextcolour,
               quaternarytextcolour,
               quinarytextcolour,
               senarytextcolour,
               editabletextcolour,
               showselectordaycare,
               showselectorosc,
               showselectorpreschool,
               showselectordayhome,
               showselectorgrouphome,
               showselectorecs,
               showselectorother,
               lockbackupattendance,
               showsubsidyonattendance,
               showtimestamponattendance,
               centrenameonreports,
               newinvoiceopen,
               allchildrenactivethismonth,
               emailinvoicesto,
               emailreceiptsto,
               invoicemessage,
               showmedicalconcerns,
               showdietrestrictions,
               showallergies,
               showimmunizationquestions,
               showmedicationquestions
               from preferences where companyid = 1414
		   53 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   53 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   53 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   53 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   53 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   53 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   53 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   53 Query	select id, title, body from messages where companyid = 1414 and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:07'))
		   53 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid = 1414
		   53 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid = 1414
		   53 Query	select server from distribution where companyid = 1414
		   53 Query	select name from companies where id = 1414
		   53 Query	select count(c.id) count from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and curdate() >= s.startdate and date_add(date_format(curdate() ,'%Y-%m-01'),interval 1 month) <= s.enddate and c.subsidynotrequired = 'N'
		   53 Query	select count(*) count from (select c.id,max(s.enddate) maxenddate from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and c.registrationconfirmed = 'Y' and (c.startdate is not null and c.startdate <> '0000-00-00')  and c.subsidynotrequired = 'N' group by c.id having curdate() > maxenddate order by c.id,s.enddate) results
		   53 Query	select count(*) count from (select c.id,max(s.startdate),s.enddate from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and curdate() <= s.enddate and date_add(date_format(curdate() ,'%Y-%m-01'),interval 1 month) > s.enddate and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and c.registrationconfirmed = 'Y' and (c.startdate is not null and c.startdate <> '0000-00-00') and c.subsidynotrequired = 'N' group by c.id order by c.id,s.startdate) results
		   53 Query	select count(c.id) count from children c left join subsidy s on c.id = s.childid, groups r where r.id = c.groupid and r.companyid = 1414 and c.startdate <= curdate() and (c.enddate > curdate() or c.enddate is null or c.enddate = '0000-00-00') and c.subsidynotrequired = 'Y'
		   54 Quit
		   53 Quit
		   52 Query	select timezone from preferences where companyid = 1414
		   52 Query	select companies.name companyname,
                       companies.email,
                       companies.id,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users,usercompanies uc, securityprofiles sp
                 where sp.id = users.securityprofile
                   and uc.userid = users.id
                   and uc.companyid = companies.id
                   and users.id = 2661 and uc.primarycompany = 'Y'
		   52 Query	select companies.name companyname,
                       companies.contactperson,
                       companies.email,
                       companies.phone,
                       companies.id,
                       companies.city,
                       companies.province,
                       companies.activescheduleid,
                       companies.initialsetupcomplete,
                       users.securityprofile,
                       users.termsofservice,
                       sp.name securityprofilename,
                       users.firstname,
                       users.lastname
                  from companies,users, securityprofiles sp
                 where sp.id = users.securityprofile
                   and companies.id = 1414
		   52 Query	select hideinactivestaff,
               hideinactiveusers,
               hideinactivetasks,
               hideinactivetasktypes,
               hideinactivetimeoff,
               hideinactivegroups,
               hideinactivemessages,
               hidearchivedchildren,
               hidezerobalancefamilies,
               hideinactiveitems,
               hideinactivecertifications,
               hideinactiveareas,
               hideinactivewagetopups,
               hideinactivesurveyoptions,
               hideinactiveaccounts,
               hideinactiveagreements,
               hideinactivepriorities,
               hideinactiverecords,
               hideinactiveproviderchildren,
               hideeftfilestest,
               hideeftfilesinvalid,
               businessstarttime,
               businessendtime,
               childtimerounding,
               stafftimerounding,
               payrollrounding,
               payrollroundingtype,
               roundpayrollhours,
               roundclaimformhours,
               autofilltransactioncomment,
               autofeecalculationcomment,
               autoupdateschedule,
               hideweekendschedules,
               showpendingonschedule,
               showdropinsonbulkcharge,
               defaultfamilylist,
               enablestaffquickswitch,
               showemergencycontactoption,
               startpage,
               startpageparams,
               lastnamefirstchild,
               lastnamefirststaff,
               lastnamefirstprovider,
               hideweekendschildreports,
               useaccountnumbers,
               useitemnumbers,
               showchildabsentoption,
               transactionsperpage,
               showfulladdressonprofile,
               showworkaddressonprofile,
               confirmchildabsent,
               childprofiletitlealign,
               childprofiletitlesize,
               childprofiletitlecolormale,
               childprofiletitlecolorfemale,
               childprofileshowprogram,
               childprofileshowpicture,
               staffprofiletitlealign,
               staffprofiletitlesize,
               staffprofiletitlecolormale,
               staffprofiletitlecolorfemale,
               ignorezerocharges,
               stafftimelockdate,
               wagetopupmaxhours,
               wagetopupdefaultmonth,
               earningsdefaultmonth,
               infantcareincentivedefaultmonth,
               efttransactiondatecollections,
               efttransactiondatestaff,
               efttransactiondateproviders,
               shownoteschildattendance,
               splitinfantcareincentive,
               emailforonlineregistration,
               sortdayhomeadjustments,
               recordsperpagewaiting,
               recordsperpageunconfirmed,
               recordsperpageterminated,
               promptforpickuppersondaycare,
               promptforpickuppersonosc,
               promptforpickuppersondayhome,
               promptforpickuppersongrouphome,
               promptforpickuppersonpreschool,
               promptforpickuppersonecs,
               promptforpickuppersonother,
               calculatemultipliertype,
               grouptype,
               claimchargeitem,
               claimchargecomment,
               primarycolour,
               secondarycolour,
               tertiarycolour,
               quaternarycolour,
               quinarycolour,
               senarycolour,
               primarytextcolour,
               secondarytextcolour,
               tertiarytextcolour,
               quaternarytextcolour,
               quinarytextcolour,
               senarytextcolour,
               editabletextcolour,
               showselectordaycare,
               showselectorosc,
               showselectorpreschool,
               showselectordayhome,
               showselectorgrouphome,
               showselectorecs,
               showselectorother,
               lockbackupattendance,
               showsubsidyonattendance,
               showtimestamponattendance,
               centrenameonreports,
               newinvoiceopen,
               allchildrenactivethismonth,
               emailinvoicesto,
               emailreceiptsto,
               invoicemessage,
               showmedicalconcerns,
               showdietrestrictions,
               showallergies,
               showimmunizationquestions,
               showmedicationquestions
               from preferences where companyid = 1414
		   52 Query	select active from programtypes where companyid = 1414 and code = 'daycare'
		   52 Query	select active from programtypes where companyid = 1414 and code = 'osc'
		   52 Query	select active from programtypes where companyid = 1414 and code = 'preschool'
		   52 Query	select active from programtypes where companyid = 1414 and code = 'ecs'
		   52 Query	select active from programtypes where companyid = 1414 and code = 'grouphome'
		   52 Query	select active from programtypes where companyid = 1414 and code = 'dayhome'
		   52 Query	select active from programtypes where companyid = 1414 and code = 'other'
		   52 Query	select id, title, body from messages where companyid = 1414 and popup = 'Y' and ((popupdate < '2018-08-03') or (popupdate = '2018-08-03' and popuptime <= '18:07'))
		   52 Query	delete from childrengroupsauto where effective < '2018-08-03' and companyid = 1414
		   52 Query	select id,childid,groupid from childrengroupsauto where effective = '2018-08-03' and companyid = 1414
		   52 Query	select server from distribution where companyid = 1414
		   52 Query	select name from companies where id = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-1-01' and '2018-1-31' and companyid = 1414
180803 20:07:06	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-1-01' and '2017-1-31' and companyid = 1414
180803 20:07:07	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-2-01' and '2018-2-28' and companyid = 1414
180803 20:07:08	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-2-01' and '2017-2-28' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-3-01' and '2018-3-31' and companyid = 1414
180803 20:07:09	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-3-01' and '2017-3-31' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-4-01' and '2018-4-30' and companyid = 1414
180803 20:07:10	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-4-01' and '2017-4-30' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-5-01' and '2018-5-31' and companyid = 1414
180803 20:07:11	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-5-01' and '2017-5-31' and companyid = 1414
180803 20:07:12	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-6-01' and '2018-6-30' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-6-01' and '2017-6-30' and companyid = 1414
180803 20:07:13	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-7-01' and '2018-7-31' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-7-01' and '2017-7-31' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-8-01' and '2018-8-31' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-8-01' and '2017-8-31' and companyid = 1414
180803 20:07:14	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-9-01' and '2018-9-30' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-9-01' and '2017-9-30' and companyid = 1414
180803 20:07:15	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-10-01' and '2018-10-31' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-10-01' and '2017-10-31' and companyid = 1414
180803 20:07:16	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-11-01' and '2018-11-30' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-11-01' and '2017-11-30' and companyid = 1414
180803 20:07:17	   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2018-12-01' and '2018-12-31' and companyid = 1414
		   52 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
             where date between '2017-12-01' and '2017-12-31' and companyid = 1414
180803 20:07:18	   55 Quit
		   52 Quit
180803 20:07:30	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:07:38	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:17	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:20	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:22	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:23	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:25	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:28	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:30	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:31	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:33	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:34	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:36	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:38	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:39	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:41	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:42	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:43	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:45	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:47	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:48	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:50	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:52	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:53	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:55	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:57	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:08:58	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:00	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:01	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:02	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:04	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:05	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:07	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:08	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:10	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:12	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:13	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:15	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:16	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:18	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:19	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:21	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:23	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:24	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:26	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:27	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:29	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:30	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:32	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:33	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:35	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:36	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:37	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:38	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:40	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:41	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:42	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:43	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:45	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:46	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:47	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:48	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:50	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:51	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000
180803 20:09:52	    2 Query	select count(distinct(childid)) rowcount from childattendance use index(date)
where date between '2018-01-01' and '2018-01-31' and companyid = 1414
LIMIT 0, 1000