From TeamWeaverWiki
This page documents the database table "aggquery" as used by Inverse Search and Woogle4MediaWiki for the aggregate query logging.
See also Aggclick table
| field
| description
| Test
| fix/upd
| change on
| issue/info
| usage (vs. IS)
| db_opt*/TST
|
| id | id | | | | | | PK
|
| qid | hashed, normalized query string | | x | | (unique) | | UNIQUE_IDX
|
| needstring | query string | | x | | (normalized) | | UNIQUE_IDX
|
| needexec | overall query executions | hash | U | query | (without browsing) | redlinks(rq), ws(in) |
|
| needexecclick | overall query executions without at least on following result click | hash | U | click | Session! | ws(in) |
|
| recency (!) | XXXX | | U | query | !!! | |
|
| firstdate | date of the first time, the query was executed | | x | | | |
|
| lastdate | date of the last time, the query was executed (now) | | U | query | | redlinks(rq), ws(rq) |
|
| resulthits | number of result hits for query | | U | query | Visibility!, Dyn? | |
|
| sizequeryusers | size of queryusers | | U | query | User! | redlinks(rq), ws(in) |
|
| needexecpages | number of query executions for which at least one further result page was browsed | | U | browse | Session! | ws(in) |
|
| needexecavgpage | average number of result pages users browsed for this query | hash | U | query, browse | Session! | |
|
| resultclicks | total number of result clicks following this query (e.g. 1*result1 + 3*result2 = 4) | | U | click | | ws(in) |
|
| uniqueresults | number of unique results clicked following this query (e.g. result1 + result2 = 2) | | U | click | | |
|
| queryusers | CSV-list of all anonymized user ids who executed this query at least once | | U | query | User! | |
|
| publicusers | subset of queryusers who agreed to be publicly associated with this query | | U | query | User! | |
|
|
|