Lines Matching full:as
36 * @param string $from The start date as YYYY-MM-DD
37 * @param string $to The end date as YYYY-MM-DD
118 END as ref_type,
119 COUNT(*) as cnt
120 FROM pageviews as P
121 LEFT JOIN referers as R ON P.ref_id = R.id
122 LEFT JOIN sessions as S ON P.session = S.session
128 foreach ($result as $row) {
147 $sql = "SELECT COUNT(DISTINCT P.session) as sessions,
148 COUNT(P.session) as views,
149 COUNT(DISTINCT S.user) as users,
150 COUNT(DISTINCT S.uid) as visitors,
151 DATETIME(MAX(P.dt), ?) as last
152 FROM pageviews as P
153 LEFT JOIN sessions as S ON P.session = S.session
166 $sql = "SELECT COUNT(*) as cnt
168 SELECT P.session, COUNT(*) as views
169 FROM pageviews as P
170 LEFT JOIN sessions as S ON P.session = S.session
182 $sql = "SELECT AVG(views) as cnt
184 SELECT P.session, COUNT(*) as views
185 FROM pageviews as P
186 LEFT JOIN sessions as S ON P.session = S.session
194 $sql = "SELECT AVG((unixepoch(end) - unixepoch(dt)) / 60) as time
195 FROM sessions as S
202 $sql = "SELECT COUNT(*) as logins
203 FROM logins as A
209 $sql = "SELECT COUNT(*) as registrations
210 FROM logins as A
216 $sql = "SELECT COUNT(DISTINCT uid) as current
242 $sql = "SELECT $TIME as time,
243 COUNT(DISTINCT P.session) as sessions,
244 COUNT(P.session) as pageviews,
245 COUNT(DISTINCT S.uid) as visitors
246 FROM pageviews as P
247 LEFT JOIN sessions as S ON P.session = S.session
253 foreach ($result as $row) {
276 foreach (['E', 'C', 'D'] as $type) {
277 $sql = "SELECT $TIME as time,
278 COUNT(*) as cnt
279 FROM edits as A
285 foreach ($result as $row) {
313 $sql = "SELECT $TIME as time,
314 AVG(value)/$mod as cnt
315 FROM history as A
329 $sql = "SELECT COUNT(*) as cnt, R.engine
330 FROM pageviews as P,
331 referers as R
346 $sql = "SELECT COUNT(*) as cnt, query, query as ilookup
360 $sql = "SELECT COUNT(*) as cnt, SW.word, SW.word as ilookup
361 FROM search as S,
362 searchwords as SW
376 $sql = "SELECT COUNT(*) as cnt, link as url
377 FROM outlinks as A
390 $sql = "SELECT COUNT(*) as cnt, P.page
391 FROM pageviews as P,
392 sessions as S
407 $sql = "SELECT COUNT(*) as cnt, page
408 FROM edits as A
421 $sql = "SELECT COUNT(*) as cnt, media, SUM(size) as filesize
422 FROM media as A
436 $sql = "SELECT COUNT(*) as cnt, SUM(size) as filesize
437 FROM media as A
448 $sql = "SELECT COUNT(*) as cnt, media, SUM(size) as filesize
449 FROM media as A
463 $sql = "SELECT COUNT(*) as cnt, SUM(size) as filesize
464 FROM media as A
475 $sql = "SELECT COUNT(*) as cnt, R.url
476 FROM pageviews as P
477 LEFT JOIN sessions as S ON P.session = S.session
478 LEFT JOIN referers as R ON P.ref_id = R.id
495 $sql = "SELECT COUNT(*) as cnt, R.url
496 FROM pageviews as P
497 LEFT JOIN sessions as S ON P.session = S.session
498 LEFT JOIN referers as R ON P.ref_id = R.id
516 $sql = "SELECT COUNT(*) as cnt, C.campaign
517 FROM campaigns as C,
518 sessions as S
532 $sql = "SELECT COUNT(*) as cnt, C.campaign || ' ' || C.source AS campaign
533 FROM campaigns as C,
534 sessions as S
549 $sql = "SELECT COUNT(*) as cnt, C.campaign || ' ' || C.medium AS campaign
550 FROM campaigns as C,
551 sessions as S
567 $sql = "SELECT COUNT(DISTINCT P.session) as cnt, I.country
568 FROM pageviews as P,
569 iplocation as I
586 $sel = 'S.ua_info as browser, S.ua_ver';
589 $sel = 'S.ua_info as browser';
593 $sql = "SELECT COUNT(DISTINCT S.session) as cnt, $sel
594 FROM sessions as S
608 $sql = "SELECT COUNT(DISTINCT S.session) as cnt, S.os
609 FROM sessions as S
623 $sql = "SELECT COUNT(*) as cnt, U.domain
624 FROM pageviews as P,
625 sessions as S,
626 users as U
643 $sql = "SELECT COUNT(*) as cnt, S.user
644 FROM pageviews as P,
645 sessions as S
661 $sql = "SELECT COUNT(*) as cnt, user
662 FROM edits as E,
663 sessions as S
678 $sql = "SELECT COUNT(*) as cnt, G.`group`
679 FROM pageviews as P,
680 sessions as S,
681 groups as G
697 $sql = "SELECT COUNT(*) as cnt, G.`group`
698 FROM edits as E,
699 sessions as S,
700 groups as G
716 $sql = "SELECT COUNT(DISTINCT S.uid) as cnt,
717 ROUND(P.screen_x/100)*100 as res_x,
718 ROUND(P.screen_y/100)*100 as res_y,
719 CAST(ROUND(P.screen_x/100)*100 AS int)
721 CAST(ROUND(P.screen_y/100)*100 AS int) as resolution
722 FROM pageviews as P,
723 sessions as S
740 $sql = "SELECT COUNT(DISTINCT S.uid) as cnt,
741 ROUND(P.view_x/100)*100 as res_x,
742 ROUND(P.view_y/100)*100 as res_y,
743 CAST(ROUND(P.view_x/100)*100 AS int)
745 CAST(ROUND(P.view_y/100)*100 AS int) as resolution
746 FROM pageviews as P,
747 sessions as S
765 $sql = "SELECT `user`, MAX(`dt`) as dt