Music::Artist->set_sql(most_cds => qq{ SELECT artist.id, COUNT(cd.id) AS cds FROM artist, cd WHERE artist.id = cd.artist GROUP BY artist.id ORDER BY cds DESC LIMIT 10 }); my @artists = Music::Artist->search_most_cds(); #### __PACKAGE__->columns(TEMP => qw/cds/); #### $VAR1 = bless( { '__triggers' => {}, '_class_trigger_results' => [], 'id' => '1' }, 'Music::Artist' ); $VAR2 = bless( { '__triggers' => {}, '_class_trigger_results' => [], 'cds' => '2', 'id' => '2' }, 'Music::Artist' );