No exact definition; usually means "person, usually a nerd, who longs after unattainable people and/or social status; perfect material for an underdog"
When paired with oike it is one of the lowest, most insulting thing ever. Basically means person is a bottom feeder, and will never become anything more.