$filtered_cd_rs->as_query,
q{(
SELECT cds_unordered.cdid, cds_unordered.artist, cds_unordered.title, cds_unordered.year, cds_unordered.genreid, cds_unordered.single_track,
- tracks.trackid, tracks.cd, tracks.position, tracks.title, tracks.last_updated_on, tracks.last_updated_at, tracks.small_dt
+ tracks.trackid, tracks.cd, tracks.position, tracks.title, tracks.last_updated_on, tracks.last_updated_at
FROM artist me
JOIN (
SELECT cds_unordered.cdid, cds_unordered.artist, cds_unordered.title, cds_unordered.year, cds_unordered.genreid, cds_unordered.single_track
'last_updated_at' => undef,
'last_updated_on' => undef,
'position' => '1',
- 'small_dt' => undef,
'title' => 'Boring Name',
'trackid' => '10'
},
'last_updated_at' => undef,
'last_updated_on' => undef,
'position' => '2',
- 'small_dt' => undef,
'title' => 'Boring Song',
'trackid' => '11'
},
'last_updated_at' => undef,
'last_updated_on' => undef,
'position' => '3',
- 'small_dt' => undef,
'title' => 'No More Ideas',
'trackid' => '12'
}
'last_updated_at' => undef,
'last_updated_on' => undef,
'position' => '1',
- 'small_dt' => undef,
'title' => 'Sad',
'trackid' => '13'
},
'last_updated_at' => undef,
'last_updated_on' => undef,
'position' => '3',
- 'small_dt' => undef,
'title' => 'Suicidal',
'trackid' => '15'
},
'last_updated_at' => undef,
'last_updated_on' => undef,
'position' => '2',
- 'small_dt' => undef,
'title' => 'Under The Weather',
'trackid' => '14'
}