Lines Matching refs:sql

16         $sql    = "SELECT ref_type, COUNT(*) as cnt
21 $result = $this->hlp->runSQL($sql);
31 $sql = "SELECT COUNT(DISTINCT session) as sessions,
38 $result = $this->hlp->runSQL($sql);
47 $sql = "SELECT COUNT(*) as cnt
51 $result = $this->hlp->runSQL($sql);
64 $result = $this->hlp->runSQL($sql);
69 $sql = "SELECT AVG(views) as cnt
72 $result = $this->hlp->runSQL($sql);
76 $sql = "SELECT COUNT(id) as robots
80 $result = $this->hlp->runSQL($sql);
85 $sql = "SELECT AVG(end - dt)/60 as time
90 $result = $this->hlp->runSQL($sql);
94 $sql = "SELECT COUNT(*) as logins
98 $result = $this->hlp->runSQL($sql);
102 $sql = "SELECT COUNT(*) as registrations
106 $result = $this->hlp->runSQL($sql);
110 $sql = "SELECT COUNT(*) as current
113 $result = $this->hlp->runSQL($sql);
137 $sql = "SELECT $TIME as time,
146 $result = $this->hlp->runSQL($sql);
166 $sql = "SELECT $TIME as time,
173 $result = $this->hlp->runSQL($sql);
196 $sql = "SELECT $TIME as time,
203 return $this->hlp->runSQL($sql);
207 $sql = "SELECT COUNT(*) as cnt, engine as eflag, engine
213 return $this->hlp->runSQL($sql);
224 $sql = "SELECT COUNT(*) as cnt, query, query as ${I}lookup
231 return $this->hlp->runSQL($sql);
242 $sql = "SELECT COUNT(*) as cnt, word, word as ${I}lookup
251 return $this->hlp->runSQL($sql);
255 $sql = "SELECT COUNT(*) as cnt, link as url
261 return $this->hlp->runSQL($sql);
265 $sql = "SELECT COUNT(*) as cnt, page
272 return $this->hlp->runSQL($sql);
276 $sql = "SELECT COUNT(*) as cnt, page
282 return $this->hlp->runSQL($sql);
286 $sql = "SELECT COUNT(*) as cnt, media, SUM(size) as filesize
293 return $this->hlp->runSQL($sql);
297 $sql = "SELECT COUNT(*) as cnt, SUM(size) as filesize
301 return $this->hlp->runSQL($sql);
305 $sql = "SELECT COUNT(*) as cnt, media, SUM(size) as filesize
312 return $this->hlp->runSQL($sql);
316 $sql = "SELECT COUNT(*) as cnt, SUM(size) as filesize
320 return $this->hlp->runSQL($sql);
324 $sql = "SELECT COUNT(*) as cnt, ref as url
332 return $this->hlp->runSQL($sql);
336 $sql = "SELECT COUNT(*) as cnt, ref as url
346 return $this->hlp->runSQL($sql);
350 $sql = "SELECT COUNT(DISTINCT session) as cnt, B.code AS cflag, B.country
358 return $this->hlp->runSQL($sql);
370 $sql = "SELECT COUNT(DISTINCT session) as cnt, $sel
377 return $this->hlp->runSQL($sql);
381 $sql = "SELECT COUNT(DISTINCT session) as cnt, os as osflag, os
388 return $this->hlp->runSQL($sql);
392 $sql = "SELECT COUNT(*) as cnt, user
400 return $this->hlp->runSQL($sql);
404 $sql = "SELECT COUNT(*) as cnt, user
411 return $this->hlp->runSQL($sql);
415 $sql = "SELECT COUNT(*) as cnt, `group`
422 return $this->hlp->runSQL($sql);
426 $sql = "SELECT COUNT(*) as cnt, `group`
433 return $this->hlp->runSQL($sql);
438 $sql = "SELECT COUNT(DISTINCT uid) as cnt,
450 return $this->hlp->runSQL($sql);
454 $sql = "SELECT COUNT(DISTINCT uid) as cnt,
467 return $this->hlp->runSQL($sql);
471 $sql = "SELECT `user`, `dt`
476 return $this->hlp->runSQL($sql);