Skip to content

Ranker : top priority datasets are not retrieved #156

@broija

Description

@broija
  • 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

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

Status

No status

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions