below is the dbix query that i came up w/ from the documentation. The error i got was "No relationship DBIx::Class::ResultSet::count(): No such relationship image_folder". i have tested the sql and it works.

my $rs = $schema->resultset('ImageDescription')->search(
    { 'image_folder.name' => 'japan' }, 
    { join => { 'image_folder' =>  'image_folder'} }
);
[download]