Something screwed up with one of your indexes, basically, drop all intranet related indexes (and perhaps even views, I can't remember anymore) then add them back in. Should fix it. (If I remember correctly.) As for the ticket stuff, I haven't gotten to it, but it looks like it might be choking on your :) in the query (Though I don't know yet).. You aught to turn on Full Debug, so it's clearer what's happening. And last off.. Looks like the screen_name isn't in the users_active table, pop into psql and see what the schema looks like for the table.