It sure looks like it's something automated. Either that, or someone has a stopwatch and is bring up a page that queries the database every couple of minutes
| 72260 | username | localhost | database | Query | 413 | Waiting for table | SELECT COUNT(*) as total, a.USER_ID, b.USER_DISPLAY_NAME as user
FROM ubbt_POSTS AS a,
ubbt_USERS |
| 72752 | username | localhost | database | Query | 271 | Waiting for table | SELECT COUNT(*) as total, a.USER_ID, b.USER_DISPLAY_NAME as user
FROM ubbt_POSTS AS a,
ubbt_USERS |
| 73390 | username | localhost | database | Query | 117 | Waiting for table | SELECT COUNT(*) as total, a.USER_ID, b.USER_DISPLAY_NAME as user
FROM ubbt_POSTS AS a,
ubbt_USERS |
The 413, 271, 117 are how long the queries have been waiting. There are roughly about 73 of them backed up now. And they keep going, about 120-150 seconds in between eachother. Never less than a 2 minute span between them.
I can't see the full query but they don't appear to be part of the default threads install at all.
