use Test::More;
use lib qw(t/lib);
-use DBIC::SqlMakerTest;
use DBICTest;
+use DBIC::SqlMakerTest;
use DBIx::Class::SQLMaker::LimitDialects;
my ($ROWS, $OFFSET) = (
LEFT JOIN "track" "tracks"
ON "tracks"."cd" = "cds_unordered"."cdid"
WHERE "me"."rank" = ?
- GROUP BY "cds_unordered"."cdid", "cds_unordered"."artist", "cds_unordered"."title", "cds_unordered"."year", "cds_unordered"."genreid", "cds_unordered"."single_track"
+ GROUP BY "cds_unordered"."cdid", "cds_unordered"."artist", "cds_unordered"."title", "cds_unordered"."year", "cds_unordered"."genreid", "cds_unordered"."single_track", "me"."name"
ORDER BY MAX("genre"."name") DESC,
- MAX( tracks.title ) DESC,
- MIN("me"."name"),
+ MAX("tracks"."title") DESC,
+ "me"."name" ASC,
"year" DESC,
"cds_unordered"."title" DESC
LIMIT ?
ON "tracks"."cd" = "cds_unordered"."cdid"
WHERE "me"."rank" = ?
ORDER BY "genre"."name" DESC,
- tracks.title DESC,
+ "tracks"."title" DESC,
"me"."name" ASC,
"year" DESC,
"cds_unordered"."title" DESC