Lines Matching refs:sql

112         $sql = "SELECT
126         $result = $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
147         $sql = "SELECT COUNT(DISTINCT P.session) as sessions,
156 … $result = $this->db->queryRecord($sql, [$this->tz, $this->tz, $this->from, $this->tz, $this->to]);
166             $sql = "SELECT COUNT(*) as cnt
176             $count = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
182         $sql = "SELECT AVG(views) as cnt
191 …   $data['avgpages'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
194         $sql = "SELECT AVG((unixepoch(end) - unixepoch(dt)) / 60) as time
199 …  $data['timespent'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
202         $sql = "SELECT COUNT(*) as logins
206 …     $data['logins'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
209         $sql = "SELECT COUNT(*) as registrations
213 …$data['registrations'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to…
216         $sql = "SELECT COUNT(DISTINCT uid) as current
219         $data['current'] = $this->db->queryValue($sql);
242         $sql = "SELECT $TIME as time,
252         $result = $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
277             $sql = "SELECT $TIME as time,
284             $result = $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
313         $sql = "SELECT $TIME as time,
321         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to, $info]);
329         $sql = "SELECT COUNT(*) as cnt, R.engine
338         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
346         $sql = "SELECT COUNT(*) as cnt, query, query as ilookup
352         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
360         $sql = "SELECT COUNT(*) as cnt, SW.word, SW.word as ilookup
368         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
376         $sql = "SELECT COUNT(*) as cnt, link as url
382         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
390         $sql = "SELECT COUNT(*) as cnt, P.page
399         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
407         $sql = "SELECT COUNT(*) as cnt, page
413         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
421         $sql = "SELECT COUNT(*) as cnt, media, SUM(size) as filesize
428         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
436         $sql = "SELECT COUNT(*) as cnt, SUM(size) as filesize
440         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
448         $sql = "SELECT COUNT(*) as cnt, media, SUM(size) as filesize
455         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
463         $sql = "SELECT COUNT(*) as cnt, SUM(size) as filesize
467         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
475         $sql = "SELECT COUNT(*) as cnt, R.url
487         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
495         $sql = "SELECT COUNT(*) as cnt, R.url
508 …return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to, $this->tz, $this->…
516         $sql = "SELECT COUNT(*) as cnt, C.campaign
524         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
532         $sql = "SELECT COUNT(*) as cnt, C.campaign || ' ' || C.source AS campaign
541         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
549         $sql = "SELECT COUNT(*) as cnt, C.campaign || ' ' || C.medium AS campaign
558         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
567         $sql = "SELECT COUNT(DISTINCT P.session) as cnt, I.country
576         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
593         $sql = "SELECT COUNT(DISTINCT S.session) as cnt, $sel
600         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
608         $sql = "SELECT COUNT(DISTINCT S.session) as cnt, S.os
615         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
623         $sql = "SELECT COUNT(*) as cnt, U.domain
635         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
643         $sql = "SELECT COUNT(*) as cnt, S.user
653         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
661         $sql = "SELECT COUNT(*) as cnt, user
670         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
678         $sql = "SELECT COUNT(*) as cnt, G.`group`
689         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
697         $sql = "SELECT COUNT(*) as cnt, G.`group`
707         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
716         $sql = "SELECT COUNT(DISTINCT S.uid) as cnt,
732         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
740         $sql = "SELECT COUNT(DISTINCT S.uid) as cnt,
757         return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
765         $sql = "SELECT `user`, MAX(`dt`) as dt
773         return $this->db->queryAll($sql);