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();

##</code><code>##

  __PACKAGE__->columns(TEMP => qw/cds/);

##</code><code>##

$VAR1 = bless( { '__triggers' => {}, '_class_trigger_results' => [], 'id' => '1' }, 'Music::Artist' ); 
$VAR2 = bless( { '__triggers' => {}, '_class_trigger_results' => [], 'cds' => '2', 'id' => '2' }, 'Music::Artist' );