tsunami

log in
history

luke.breuer.com search terms

Luke Breuer
2008-12-23 22:10 UTC

SQL
with Terms as (
    select  term = cast(value as varchar(30))
    from    (
        select  search_term = dbo.Extract_Search_Term(referrer),
                client_ip
        from    v_IIS_Typical
    ) t
    cross apply dbo.RegexSplit(search_term, '\s+')
    where   search_term is not null
        and len(value) > 0   
    group by client_ip, value
)
select  term, count = count(*)
from    Terms
group by term
having  count(*) >= 10
order by count desc
Results
not split on spaces, with pretty graphs
term                           count
------------------------------ -----------
javascript                     2517
menu                           959
context                        913
modal                          724
drag                           460
xmlhttprequest                 353
dialog                         319
drop                           301
tutorial                       298
and                            257
firefox                        216
popup                          210
in                             205
timeout                        200
oncontextmenu                  179
click                          170
div                            150
contextmenu                    142
window                         138
right                          134
c#                             128
to                             118
disable                        108
+                              104
example                        100
mouse                          81
IE                             71
how                            67
browser                        62
using                          57
on                             56
css                            54
show                           52
js                             51
grid                           49
event                          48
element                        46
text                           46
freeze                         44
target                         42
position                       41
xmlhttp                        41
onmousedown                    40
ajax                           37
the                            37
a                              36
webmark                        36
selection                      36
items                          36
box                            35
not                            34
with                           34
html                           33
left                           33
hide                           33
background                     32
select                         31
for                            30
onmousemove                    28
table                          28
menus                          28
prevent                        27
modaldialog                    27
+javascript                    27
iframe                         26
script                         26
change                         25
java                           25
of                             24
image                          22
IE6                            22
prototype                      22
asp.net                        22
internet                       20
suppress                       19
"context                       19
button                         19
&                              19
examples                       18
menu"                          18
problem                        18
transparent                    18
over                           18
href                           18
powershell                     17
code                           17
elements                       17
does                           17
refresh                        17
scrollTop                      17
darken                         17
events                         16
is                             16
Jscript                        15
key                            15
onclick                        15
aspx                           15
draggable                      15
dragging                       14
add                            14
explorer                       14
pane                           14
item                           14
function                       14
sample                         14
tutorials                      14
textbox                        13
work                           13
hyperlink                      13
set                            13
cursor                         13
z-index                        12
replace                        12
display                        12
custom                         12
an                             12
email                          12
opera                          12
Return                         12
bookmark                       12
from                           11
input                          11
middle                         11
breuer                         11
mousemove                      11
manager                        11
enable                         11
settimeout                     11
tips                           10
page                           10
Parent                         10
clicked                        10
panes                          10
up                             10
httprequest                    10
simple                         10
move                           10