gen_issue_content_text.py

        d = dict()
        d['title_list'] = []

        now = datetime.datetime.now()

        base_title_qs = Title.objects.distinct().filter(state='P').order_by('stage', 'category')

        if section == 'c':
            base_title_qs = base_title_qs.filter(stage__id=2)

        elif section == 'f':
            base_title_qs = base_title_qs.filter(category__id=1)

        elif section == 'n':
            base_title_qs = base_title_qs.filter(category__id=2)

        titles_in_issue_qs = base_title_qs.filter(issue=issue)

        online_only_titles_qs = base_title_qs.filter(issue__isnull=True).filter(published_date__gt=issue.issue_date - timedelta(days=14)).filter(published_date__lte=issue.issue_date)

        d['title_list'].extend([t for t in titles_in_issue_qs if t not in d['title_list']])
        d['title_list'].extend([t for t in online_only_titles_qs if t not in d['title_list']])

base_title_qs.filter(category__id={ 'c': 2, 'f': 1, 'n': 2 }[section])

filters = {'c': {'stage__id': 2}, 'f': {'category__id': 1}, 'n': {'category__id': 2}}
base_title_qs.filter(**filters[section])