http://www.perlmonks.org?node_id=973270


in reply to DBIx and ManyToMany Relationships

My DBIx::Class knowledge is a bit rusty, but I think what you want is 

$rs->search(
    {},
    {
        rows     => 10,
        join     => { contentlinks => 'content' },
        prefetch => { contentlinks => 'content' },
    }
);

[download]

(It might be that the prefetch alone is enough, and you don't need the join; I'm not quite sure).

For constructing queries, ignore your ManyToMany -- it is not a reliationship you can use in queries (only a shortcut on the result objects), so it probably confuses you. Simply ignore it.

Perl 6 - the future is here, just unevenly distributed

In Section Seekers of Perl Wisdom