raw(raw_query, params=None, translations=None) Takes a raw SQL query, executes it, and returns a django.db.models.query

db The database that will be used if this query is executed now.

distinct(*fields) Returns a new QuerySet that uses SELECT DISTINCT in its SQL query. This eliminates

datetimes(field_name, kind, order='ASC', tzinfo=None) Returns a QuerySet that evaluates to a list of

latest(field_name=None) Returns the latest object in the table, by date, using the field_name provided as the date

select_for_update(nowait=False) Returns a queryset that will lock rows until the end of the transaction, generating a SELECT

aggregate(*args, **kwargs) Returns a dictionary of aggregate values (averages, sums, etc.) calculated over the QuerySet

class Count(expression, distinct=False, **extra) [source] Returns the number of objects that

get_or_create(defaults=None, **kwargs) A convenience method for looking up an object with the given kwargs (may

last() Works like first(), but returns the last object in the queryset.