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
28705	Wrong annotation when used with QuerySet.order_by()	Rafael Capucho	nobody	"Related to old closed ticket: https://code.djangoproject.com/ticket/25316

# Models

{{{
class Application(models.Model):
    package_name = models.CharField(max_length=128, null=False, blank=True)
    package_version_code = models.IntegerField(blank=True)
    package_version_name = models.CharField(max_length=64, null=False, blank=True)
    label = models.CharField(max_length=64, null=False, blank=True)

    class Meta:
        ordering = ['label', 'package_version_code']

class Profile(models.Model):
    applications = models.ManyToManyField(
        'applications.Application',
        related_name='application_%(class)s',
        blank=True
    )

class Device(models.Model):
   profile = models.ForeignKey(
        Profile,
        related_name='devices',
        blank=True,
        null=True
    )
}}}

The error is:
[[Image(https://i.imgur.com/JbUyRQJ.png)]]
"	Bug	closed	Database layer (models, ORM)	1.11	Normal	needsinfo	Annotate, ORM, Order_by		Unreviewed	0	0	0	0	0	0