SELECT "book"."revisionId" AS "book_revisionId", "book"."crossRevisionId" AS "book_crossRevisionId", "book"."title" AS "book_title", "book"."isbn" AS "book_isbn", "book"."entitlementId" AS "book_entitlementId", "book"."readingStatePriorityTimestamp" AS "book_readingStatePriorityTimestamp", "book"."readingStateStatus" AS "book_readingStateStatus", "book"."readingStateTimesStartedReading" AS "book_readingStateTimesStartedReading", "book"."readingStateCurrentBookmarkLastModified" AS "book_readingStateCurrentBookmarkLastModified", "book"."readingStateCurrentBookmarkProgressPercent" AS "book_readingStateCurrentBookmarkProgressPercent", "book"."readingStateCurrentBookmarkContentSourceProgressPercent" AS "book_readingStateCurrentBookmarkContentSourceProgressPercent", "book"."readingStateCurrentBookmarkLocationValue" AS "book_readingStateCurrentBookmarkLocationValue", "book"."readingStateCurrentBookmarkLocationType" AS "book_readingStateCurrentBookmarkLocationType", "book"."readingStateCurrentBookmarkLocationSource" AS "book_readingStateCurrentBookmarkLocationSource", "book"."publisherName" AS "book_publisherName", "book"."seriesNumber" AS "book_seriesNumber", "book"."seriesNumberFloat" AS "book_seriesNumberFloat", "book"."phoneticTitleKana" AS "book_phoneticTitleKana", "book"."subtitle" AS "book_subtitle", "book"."phoneticSubtitleKana" AS "book_phoneticSubtitleKana", "book"."phoneticTitleMetadata" AS "book_phoneticTitleMetadata", "book"."seriesTitleMetadata" AS "book_seriesTitleMetadata", "book"."entitlementDate" AS "book_entitlementDate", "book"."coverImageId" AS "book_coverImageId", "book"."entitlementAccessibility" AS "book_entitlementAccessibility", "book"."isInternetArchive" AS "book_isInternetArchive", "book"."isRemoved" AS "book_isRemoved", "book"."isHiddenFromArchive" AS "book_isHiddenFromArchive", "book"."isDownloaded" AS "book_isDownloaded", "book"."isLocked" AS "book_isLocked", "book"."size" AS "book_size", "book"."seriesId" AS "book_seriesId", "series"."id" AS "series_id", "category"."id" AS "category_id", "bookContributor"."displayOrder" AS "bookContributor_displayOrder", "bookContributor"."bookRevisionId" AS "bookContributor_bookRevisionId", "bookContributor"."contributorId" AS "bookContributor_contributorId", "contributor"."id" AS "contributor_id", "contributor"."nameMetadata" AS "contributor_nameMetadata", "contributor"."id" AS "contributor_id", "contributor"."id" FROM "book" "book" LEFT JOIN "series" "series" ON "series"."id"="book"."seriesId"  LEFT JOIN "book_categories_category" "book_category" ON "book_category"."bookRevisionId"="book"."revisionId" LEFT JOIN "category" "category" ON "category"."id"="book_category"."categoryId"  LEFT JOIN "bookContributor" "bookContributor" ON "bookContributor"."bookRevisionId"="book"."revisionId"  LEFT JOIN "contributor" "contributor" ON "contributor"."id"="bookContributor"."contributorId" WHERE "book"."isRemoved" != 1 AND "book"."isLocked" != 1 AND "book"."entitlementAccessibility" != "Preorder" ORDER BY "book"."seriesNumberFloat" DESC, "book"."revisionId" ASC