[16-Nov-2017 10:00:13 UTC] aaa 
[16-Nov-2017 10:00:13 UTC] Executing query: SELECT * FROM VEH_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com') ORDER BY _ID
[16-Nov-2017 10:00:14 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:14 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606514102 
[16-Nov-2017 10:00:15 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com') AND vehid = '1 - 08 +'  ORDER BY DATE DESC   LIMIT 5  
[16-Nov-2017 10:00:15 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = '1 - 08  ' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')
[16-Nov-2017 10:00:15 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606514101    order by date  
[16-Nov-2017 10:03:10 UTC] aaa 
[16-Nov-2017 10:03:10 UTC] Executing query: SELECT * FROM VEH_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com') ORDER BY _ID
[16-Nov-2017 10:03:11 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')  AND date >= 0 AND date < 1573606691169 
[16-Nov-2017 10:03:11 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com') AND vehid = '2015 Ram 1500'  ORDER BY DATE DESC   LIMIT 5  
[16-Nov-2017 10:03:11 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')   AND date >= 0 AND date < 1573606691168    order by date  
[16-Nov-2017 10:03:11 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')
[16-Nov-2017 10:03:41 UTC] Running chart query: SELECT  date, dist from LOG_TABLE where dist is not null and dist > 0 and type = 0  AND   VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')   AND date >= 0 AND date < 1573606691168    order by date
[16-Nov-2017 10:03:43 UTC] Running chart query: SELECT  date, cost/qty as cost from LOG_TABLE where cost is not null and cost > 0 and qty is not null and qty > 0 and type = 0  AND   VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')   AND date >= 0 AND date < 1573606691168    order by date
[16-Nov-2017 10:03:45 UTC] Running chart query: SELECT date, sum(cost) as cost FROM LOG_TABLE WHERE type = 0 AND  VEHID = '2015 Ram 1500' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'magarswapnil896@gmail.com')   AND date >= 0 AND date < 1573606691168  GROUP BY month, year ORDER BY odo asc 
[16-Nov-2017 10:04:36 UTC] aaa 
[16-Nov-2017 10:04:38 UTC] Executing query: SELECT * FROM VEH_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com') ORDER BY _ID
[16-Nov-2017 10:04:39 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:39 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')  AND date >= 0 AND date < 1573606778989 
[16-Nov-2017 10:04:40 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com') AND vehid = '1 - 08 +'  ORDER BY DATE DESC   LIMIT 5  
[16-Nov-2017 10:04:40 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = '1 - 08  ' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')
[16-Nov-2017 10:04:40 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    order by date  
[16-Nov-2017 10:04:44 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    order by date  
[16-Nov-2017 10:04:51 UTC] Running chart query: SELECT   date, count(*) as fillups from LOG_TABLE where type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    group by month, year order by date  
[16-Nov-2017 10:04:53 UTC] Running chart query: SELECT  date, cost/qty as cost from LOG_TABLE where cost is not null and cost > 0 and qty is not null and qty > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    order by date
[16-Nov-2017 10:04:55 UTC] Running chart query: SELECT date, sum(cost) as cost FROM LOG_TABLE WHERE type = 0 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988  GROUP BY month, year ORDER BY odo asc 
[16-Nov-2017 10:04:56 UTC] Running chart query: SELECT cost, date, missed_fill FROM LOG_TABLE WHERE cost > 0 AND type = 0 AND  VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988  ORDER BY odo ASC
[16-Nov-2017 10:04:58 UTC] Running chart query: SELECT  date, cost/qty as cost from LOG_TABLE where cost is not null and cost > 0 and qty is not null and qty > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    order by date
[16-Nov-2017 10:04:59 UTC] Running chart query: SELECT  date, dist from LOG_TABLE where dist is not null and dist > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    order by date
[16-Nov-2017 10:04:59 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    order by date  
[16-Nov-2017 10:05:05 UTC] Running chart query: SELECT  date, dist from LOG_TABLE where dist is not null and dist > 0 and type = 0  AND   VEHID = '1 - 08 +' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'nitin19srivastava@gmail.com')   AND date >= 0 AND date < 1573606778988    order by date
[17-Nov-2017 12:06:44 UTC] aaa 
[17-Nov-2017 12:06:44 UTC] Executing query: SELECT * FROM VEH_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com') ORDER BY _ID
[17-Nov-2017 12:06:46 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:46 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')  AND date >= 0 AND date < 1573700504776 
[17-Nov-2017 12:06:47 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')
[17-Nov-2017 12:06:47 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com') AND vehid = 'Ford EcoSport'  ORDER BY DATE DESC   LIMIT 5  
[17-Nov-2017 12:06:47 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = 'Ford EcoSport' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'appsrackinc@gmail.com')   AND date >= 0 AND date < 1573700504775    order by date  
[17-Nov-2017 12:07:51 UTC] aaa 
[17-Nov-2017 12:07:51 UTC] Executing query: SELECT * FROM VEH_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') ORDER BY _ID
[17-Nov-2017 12:07:52 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:52 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700571794 
[17-Nov-2017 12:07:53 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') AND vehid = 'Dodge Durango'  ORDER BY DATE DESC   LIMIT 5  
[17-Nov-2017 12:07:53 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')
[17-Nov-2017 12:07:53 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')   AND date >= 0 AND date < 1573700571793    order by date  
[17-Nov-2017 12:07:57 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') AND vehid = 'Dodge Durango'  ORDER BY DATE DESC  
[17-Nov-2017 12:08:06 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') AND vehid = 'Dodge Durango GT'  ORDER BY DATE DESC  
[17-Nov-2017 12:08:16 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  _ID = 478 AND  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') AND vehid = 'Dodge Durango GT'  ORDER BY DATE DESC  
[17-Nov-2017 12:10:25 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:25 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700724589 
[17-Nov-2017 12:10:26 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') AND vehid = 'Dodge Durango GT'  ORDER BY DATE DESC   LIMIT 5  
[17-Nov-2017 12:10:26 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')
[17-Nov-2017 12:10:26 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = 'Dodge Durango GT' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')   AND date >= 0 AND date < 1573700724588    order by date  
[17-Nov-2017 12:10:34 UTC] aaa 
[17-Nov-2017 12:10:34 UTC] Executing query: SELECT * FROM VEH_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') ORDER BY _ID
[17-Nov-2017 12:10:35 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700734309 
[17-Nov-2017 12:10:35 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')
[17-Nov-2017 12:10:35 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')   AND date >= 0 AND date < 1573700734308    order by date  
[17-Nov-2017 12:10:35 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') AND vehid = 'Dodge Durango'  ORDER BY DATE DESC   LIMIT 5  
[17-Nov-2017 12:10:40 UTC] For distance, running dashboard query: SELECT  MAX(odo) - MIN(odo) as result FROM LOG_TABLE  WHERE  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For fill-ups, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For fuel-qty, running dashboard query: SELECT  TRUNCATE(SUM(QTY), 2) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For fuel-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For services, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE TYPE = 1 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For service-cost, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For other-expenses, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 2 	 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For avg-fuel-efficiency, running dashboard query: SELECT  avg(consumption) as result from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For dist-between-fillups, running dashboard query: SELECT  AVG(dist) as result FROM LOG_TABLE WHERE dist > 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For qty-per-fillup, running dashboard query: SELECT  AVG(qty) as result  FROM LOG_TABLE WHERE type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For cost-per-fillup, running dashboard query: SELECT  AVG(cost) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For avg-price-per-volume, running dashboard query: SELECT  AVG(cost/qty) as result  FROM LOG_TABLE WHERE cost != 0 AND type = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For fuel-cost-per-distance, running dashboard query: SELECT  SUM(COST) / SUM(dist) as result FROM LOG_TABLE WHERE dist > 0 and cost > 0 and consumption > 0 and TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For service-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For service-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For service-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 1  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For expense-cost-per-distance, running dashboard query: SELECT  SUM(cost) / (MAX(odo) - MIN(odo)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For expense-cost, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For expense-days, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE WHERE cost > 0 and type = 2  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For fuel-cost-excluding-this-month, running dashboard query: SELECT  SUM(COST) as result FROM LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For fillups-excluding-this-month, running dashboard query: SELECT  COUNT(*) as result from LOG_TABLE WHERE TYPE = 0 AND STRCMP(DATE_FORMAT(NOW(), "%Y%m"), DATE_FORMAT(FROM_UNIXTIME(date/1000), "%Y%m"))  != 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For months-since-first-fillup, running dashboard query: SELECT  MAX(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date/1000))))  as result from LOG_TABLE WHERE TYPE = 0  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For days-since-first-fillup, running dashboard query: SELECT  1 + (MAX(date)/(1000*60*60*24)) - (MIN(date)/(1000*60*60*24)) as result FROM LOG_TABLE where TYPE = 0 AND cost != 0 AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For total-trips, running dashboard query: SELECT  COUNT(*) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For total-trip-distance, running dashboard query: SELECT  SUM(qty - odo) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For total-trip-time, running dashboard query: SELECT  SUM(consumption - date) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For total-tax-deduction, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] For trip-distance-by-type, running dashboard query: SELECT  SUM(cost) as result FROM LOG_TABLE WHERE type = 3  AND  VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')  AND date >= 0 AND date < 1573700739433 
[17-Nov-2017 12:10:40 UTC] Executing query: SELECT * FROM LOG_TABLE WHERE  USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com') AND vehid = 'Dodge Durango'  ORDER BY DATE DESC   LIMIT 5  
[17-Nov-2017 12:11:04 UTC] Running chart query: SELECT  date, consumption from LOG_TABLE where consumption is not null and consumption > 0 and type = 0  AND   VEHID = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')   AND date >= 0 AND date < 1573700739432    order by date  
[17-Nov-2017 12:12:11 UTC] Run querySELECT MAX(odo) as result FROM LOG_TABLE WHERE vehid = 'Dodge Durango' AND USER_ID = (SELECT USER_ID FROM USER_ID WHERE EMAIL = 'itznupur@gmail.com')
