def METHOD_NAME(organisation):
    """Published projects of an organisation."""
    return organisation.published_projects().select_related(
        'partners',
        'categories',
        'primary_location',
        'primary_location__country',
    ).prefetch_related(
        'categories',
        'partners'
    ).order_by('-id')