JOIN cd cds_unordered
ON cds_unordered.artist = me.artistid
WHERE ( me.rank = ? )
- GROUP BY cds_unordered.cdid, cds_unordered.artist, cds_unordered.title, cds_unordered.year, cds_unordered.genreid, cds_unordered.single_track, me.name, me.artistid
ORDER BY me.name ASC, me.artistid DESC
LIMIT 3
OFFSET 3
WHERE ( me.rank = ? )
ORDER BY me.name ASC, me.artistid DESC, tracks.cd
)},
- [ [ 'me.rank' => 13 ], [ 'me.rank' => 13 ] ],
+ [ map { [ { sqlt_datatype => 'integer', dbic_colname => 'me.rank' }
+ => 13 ] } (1,2)
+ ],
'correct SQL on limited prefetch over search_related ordered by root',
);