Miscellany

    my $result = $c->model('IRCLogBot::Messages')->search(
        { created_at => DateTime->now()->date() },
        {   
            page     => $c->stash->{page},
            rows     => $c->stash->{max_per_page},
            order_by => 'me.id desc',
            prefetch => { channel => 'network', ircuser => 'hostmask' }
        }
    );

Result:

Caught exception in IRCMine::Controller::Root->index "DBIx::Class::ResultSet::all(): Error executing '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 ( created_at = ? ) ORDER BY me.id desc LIMIT 30': ERROR:  column reference "created_at" is ambiguous
LINE 1: ...twork ON ( network.id = channel.network ) WHERE ( created_at...
                                                             ^"