Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

Linguica

Administrators
  • Content count

    10069
  • Joined

  • Last visited

About Linguica

  • Rank
    Badministrator

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Single Status Update

See all updates by Linguica

  1. select count(searchindex.wordid) as poop,word.title from word,searchindex where searchindex.wordid=word.wordid group by word.title order by poop desc limit 100

    132248quote
    131528/quote
    59208dont
    59099doom
    40556/b
    38093good
    38057/i
    34677time
    34249make
    33094people
    31305/url
    29952game
    26600ive
    23511thing
    23444heh
    23048im
    20350back
    20150hell
    19745work
    19658yeah
    19058made
    18826didnt
    18813play
    18579doesnt
    18487ill
    17773youre
    17249pretty
    17247post
    16746things
    16729stuff
    16463url
    16219find
    15967map
    15127level
    14674cool
    14131lot
    14065games
    13668thought
    13416bad
    13272thread
    13171great
    13031long
    12993isnt
    12716put
    12548zdoom
    12180shit
    11919bit
    11609nice
    11329remember
    11193wad
    11111maps
    11076run
    10970give
    10941version
    10849levels
    10765damn
    10636big
    10436read
    10435idea
    10324years
    10204point
    10177problem
    10121fun
    10007played
    9981guess
    9940playing
    9892start
    9758wont
    9748original
    9645real
    9602making
    9445id
    9402day
    9383end
    9335hard
    9285makes
    9141reason
    9036love
    8993wrong
    8957found
    8918edit
    8826fucking
    8820wouldnt
    8757kind
    8740forum
    8738guy
    8718place
    8706music
    8689fact
    8620sounds
    8607theyre
    8542guys
    8444hope
    8427havent
    8334feel
    8328part
    8282man
    8111life
    8051computer
    7951ago

    1. Show previous comments  15 more
    2. The Ultimate DooMer

      The Ultimate DooMer

      Everyone did variations of it like Action, Action!, Action!! etc. so they all counted separately...

    3. Linguica

      Linguica

      select count(*) from word,searchindex where searchindex.wordid=word.wordid and word.title="action"

      3693

      select count(*) from word,searchindex where searchindex.wordid=word.wordid and word.title="fag"

      453

    4. Mancubus II

      Mancubus II

      Numbermind said:

      doom doom doom ...

      There. It is now as it should be.


      Actually I believe that's a post count, not a word count, so what you're seeing is the number of posts that include each word at least once.

×