id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 12751 order_by after select_related returns empty queryset ozgurisil@… nobody "When querying a model with select_related(), if the related model contains a field which has null rows, adding the order_by() results in an empty set. However, count() gives the correct number of records. Foo.objects.select_related('a__b__c').order_by('x') # returns [] Foo.objects.select_related('a__b__c').order_by('x').count() #returns correct number If I fill the null rows with data, the problem vanishes. This further leads to a ""TemplateSyntaxError: 'NoneType' object has no attribute '_latest_transaction_cache'"" in the template. " Uncategorized closed Database layer (models, ORM) dev Normal invalid order_by, select_related Unreviewed 0 0 0 0 0 0