-
Notifications
You must be signed in to change notification settings - Fork 2
Open
Labels
bugSomething isn't workingSomething isn't working
Description
- Printing the SQL query and executing in postgres does not give the same result as the ORM.
- First 8 datasets are missing.
SELECT mvp_downloader_library.dataset_id, mvp_downloader_library.resource_id, mvp_downloader_library.deeplink, mvp_downloader_library.deeplink_file_size, dataset_ranks.rank, asset_resource.asset_id, ranking_id
FROM mvp_downloader_library JOIN dataset_ranks ON dataset_ranks.dataset_id = mvp_downloader_library.dataset_id JOIN resources ON resources.id = mvp_downloader_library.resource_id JOIN asset_resource ON asset_resource.resource_id = mvp_downloader_library.resource_id LEFT OUTER JOIN rescues ON rescues.asset_id = asset_resource.asset_id
WHERE dataset_ranks.ranking_id = 8 AND rescues.asset_id IS NULL ORDER BY dataset_ranks.rank
LIMIT 5
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working
Type
Projects
Status
No status