Surely http://p3rl.org/DBIx::Class::ParameterizedJoinHack is exactly what's needed here - just use it on a belongs_to rel with a join_type of left so non-matching entries are still returned, then prefetch that rel?
(ironic since I'm replying to the man who was kind enough to sponsor Shadowcat to develop that module in the first place :) -- Matt S Trout - Shadowcat Systems - Perl consulting with a commit bit and a clue http://shadowcat.co.uk/blog/matt-s-trout/ http://twitter.com/shadowcat_mst/ Email me now on mst (at) shadowcat.co.uk and let's chat about how our CPAN commercial support, training and consultancy packages could help your team. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk