Mailing List Archive

I have started to take a look at the database structure. I think
eventually I'll be able to come up with some ideas for speeding things
up. So far I've just been playing with the data.

The following SQL statements search the Recent Changes tables.
Unfortunately, without subqueries it gets cumbersome.

-- Changes by multiple users
select rc_user_text, rc_title, rc_comment from recentchanges where
rc_user in (4369, 188, 2376) order by rc_timestamp desc limit 999

-- Changes by sysops
select rc_user_text, rc_title, rc_comment from recentchanges where
rc_user in (100, 1078, 1104, 1123, 1131, 1132, 1300, 150, 166, 17, 188,
2, 24, 29, 30, 300, 31, 3113, 3362, 34, 369, 38, 39, 4, 43, 488, 51,
513, 584, 59, 62, 66, 68, 733, 83, 86, 90, 94, 95, 97, 99) order by
rc_timestamp limit 999

Other SQL statements:

-- blocked IP's sorted by blocker
select user_name, ipb_address, ipb_reason, ipb_timestamp from ipblocks,
user where ipb_by = user_id order by user_name, ipb_timestamp

-- Anonymous edits
select cur_user_text, cur_title, cur_comment from cur where cur_user=0
order by cur_timestamp desc limit 99

-- Vandal track
select rc_user_text, rc_title, rc_comment from recentchanges where
rc_user_text = '213.229.14.90' order by rc_timestamp desc


Ed Poor