Stuff

create view showrecent.v as SELECT me.id, me.body, me.created_at, me.channel, me.ircuser, me.vectors, ircuser.id, ircuser.name, ircuser.hostmask, ircuser.created_at, hostmask.id, hostmask.mask, hostmask.created_at, channel.id, channel.name, channel.created_at, channel.network, channel.message_count, network.id, network.address, network.port, network.created_at FROM messages me  JOIN users ircuser ON ( ircuser.id = me.ircuser )  JOIN hostmasks hostmask ON ( hostmask.id = ircuser.hostmask )  JOIN channels channel ON ( channel.id = me.channel )  JOIN networks network ON ( network.id = channel.network ) WHERE ( me.created_at BETWEEN '2007-5-7 00:00:00' AND '2007-5-7 20:00:00' ) LIMIT 30, 30;