tsunami

log in
history

luke.breuer.com common searches

Luke Breuer
2008-12-21 23:27 UTC

counts are count(distinct client_ip)
  1. 769 google live yahoo javascript drag and drop
  2. 671 google live yahoo javascript context menu
  3. 459 google live yahoo javascript modal dialog
  4. 451 google live yahoo javascript Modal window
  5. 438 google live yahoo xmlhttprequest timeout
  6. 385 google live yahoo javascript modal popup
  7. 295 google live yahoo javascript drag drop
  8. 231 google live yahoo javascript modal
  9. 217 google live yahoo context menu javascript
  10. 199 google live yahoo javascript oncontextmenu
  11. 174 google live yahoo javascript contextmenu
  12. 121 google live yahoo javascript drag
  13. 118 google live yahoo javascript drag and drop tutorial
  14. 102 google live yahoo javascript menu tutorial
  15. 092 google live yahoo xmlhttprequest C#
  16. 091 google live yahoo drag and drop javascript
  17. 087 google live yahoo modal div
  18. 075 google live yahoo XMLHTTP timeout
  19. 073 google live yahoo oncontextmenu javascript
  20. 073 google live yahoo xmlhttprequest tutorial
  21. 070 google live yahoo modal dialog javascript
  22. 069 google live yahoo javascript right click context menu
  23. 065 google live yahoo drag and drop tutorial
  24. 063 google live yahoo c# xmlhttprequest
  25. 055 google live yahoo raptor flowchart
  26. 052 google live yahoo contextmenu javascript
  27. 050 google live yahoo RAPTOR programming
  28. 050 google live yahoo javascript dialog
  29. 049 google live yahoo javascript setSelection
  30. 049 google live yahoo modal popup javascript
  31. 047 google live yahoo javascript Modal Box
  32. 045 google live yahoo C# tuple
  33. 045 google live yahoo javascript modaldialog
  34. 041 google live yahoo ajax modal dialog
  35. 041 google live yahoo javascript drag drop tutorial
  36. 041 google live yahoo modal javascript
  37. 038 google live yahoo C# stdout
  38. 037 google live yahoo modal dialog in javascript
  39. 037 google live yahoo javascript disable context menu
  40. 036 google live yahoo javascript modal div
  41. 034 google live yahoo drag and drop javascript tutorial
  42. 034 google live yahoo div modal
  43. 033 google live yahoo javascript drag & drop
  44. 033 google live yahoo javascript drag and drop example
  45. 031 google live yahoo javascript drag image
  46. 030 google live yahoo css modal dialog
  47. 027 google live yahoo context menu in javascript
  48. 026 google live yahoo javascript context menus
  49. 024 google live yahoo javascript context
  50. 024 google live yahoo javascript modal dialogs
  51. 023 google live yahoo c# treenode
  52. 023 google live yahoo javascript modal dialogue
  53. 023 google live yahoo modal window tutorial
  54. 022 google live yahoo javascript custom context menu
  55. 022 google live yahoo raptor programing
  56. 021 google live yahoo javascript grid tutorial
  57. 021 google live yahoo modaldialog javascript
  58. 020 google live yahoo javascript text selection
  59. 020 google live yahoo javascript popup modal
  60. 020 google live yahoo javascript model dialog
  61. 020 google live yahoo javascript context menu event
  62. 019 google live yahoo drag and drop example
  63. 019 google live yahoo tsunami diagrams
  64. 018 google live yahoo javascript drag tutorial
  65. 018 google live yahoo modal window example
  66. 017 google live yahoo c# tuples
  67. 017 google live yahoo modal javascript popup
  68. 017 google live yahoo javascript show modal dialog
  69. 017 google live yahoo javascript drag and drop
  70. 017 google live yahoo javascript draggable
  71. 016 google live yahoo javascript modal dialog box
  72. 016 google live yahoo javascript contextual menu
  73. 016 google live yahoo modal popup in javascript
  74. 016 google live yahoo modal dialog
  75. 015 google live yahoo drag and drop tutorials
  76. 015 google live yahoo MODAL bACKGROUND
  77. 015 google live yahoo modal dialog using javascript
  78. 015 google live yahoo javascript xmlhttprequest timeout
  79. 014 google live yahoo javascript set selection
  80. 014 google live yahoo javascript darken background
  81. 014 google live yahoo javascript modal iframe
  82. 014 google live yahoo javascript hide context menu
  83. 014 google live yahoo Tuple C#
  84. 014 google live yahoo XHR timeout
  85. 013 google live yahoo drag drop tutorial
  86. 013 google live yahoo c# stderr
  87. 013 google live yahoo javascript window dialog
  88. 013 google live yahoo modal dialog box javascript
  89. 013 google live yahoo right click context menu javascript
  90. 013 google live yahoo popup modal javascript
  91. 013 google live yahoo xmlhttprequest timer
  92. 013 google live yahoo xmlhttprequest setTimeout
  93. 013 google live yahoo stdout c#
  94. 012 google live yahoo css modal window
  95. 012 google live yahoo dialog javascript
  96. 012 google live yahoo ajax modal window
  97. 012 google live yahoo draggable javascript
  98. 012 google live yahoo drag and drop using javascript
  99. 012 google live yahoo drag and drop javascript example
  100. 012 google live yahoo modal window in javascript
SQL
You will have to view source to see the specifics, as tsunami is parsing code that generates code it parses...
with Term as (
    select  term = dbo.Extract_Search_Term(referrer),
            escaped = replace(replace(dbo.Extract_Search_Term(referrer), '#', '%23'), ' ', '+'),
            client_ip
    from    v_IIS_Typical
    where   dbo.Extract_Search_Term(referrer) is not null
)
select  top 100 
        replace(replace(replace(replace(replace(
            '1. ?count ?google ?yahoo ?live  ?term'
            ,'?google', 'google')
            ,'?yahoo',  'live')
            ,'?live',   'yahoo')
            ,'?count', case when count(distinct client_ip) >= 100 then cast(count(distinct client_ip) as varchar) else '0' + cast(count(distinct client_ip) as varchar) end)
            ,'?term', term) 
from    Term
group by term, escaped
order by count(distinct client_ip) desc