Enzotools Paste

if categoryId == '':
        sigs = Sig.objects.only('sig_id', 'name').extra(
            select = {
                'last_rating': 'SELECT MAX(substring(btrim(span) from \'[0-9]{4}$\')) FROM rating WHERE rating.sig_id = sig.sig_id',
                'last_endorsement': 'SELECT MAX(electionyear) FROM election JOIN endorse USING (election_id) WHERE endorse.sig_id = sig.sig_id',
            },
        ).filter(
            release_id__gte = RELEASE_ID,
            state_id = stateId
        ).order_by('sigcategory__category__name', 'name')
    else:
        categoryId = int(categoryId)
        sigs = Sig.objects.only('sig_id', 'name').extra(
            select = {
                'last_rating': 'SELECT MAX(substring(btrim(span) from \'[0-9]{4}$\')) FROM rating WHERE rating.sig_id = sig.sig_id',
                'last_endorsement': 'SELECT MAX(electionyear) FROM election JOIN endorse USING (election_id) WHERE endorse.sig_id = sig.sig_id',
            },
        ).filter(
            release_id__gte = RELEASE_ID,
            sigcategory__category__category_id = categoryId,
            state_id = stateId
        ).order_by('sigcategory__category__name', 'name')