Django 1.11.11 ORM 内关联 起别名 尝试CASE WHEN

这是模型类

class Market(models.Model):
    """市场"""
    id = models.AutoField(primary_key=True)
    market_name = models.CharField(max_length=100L, unique=True, help_text='市场名称')
    market_url = models.CharField(max_length=100L, help_text='市场地址')
    platform = models.CharField(max_length=50, null=True, help_text='平台,Amazon,ebay等')
    country_code = models.CharField(max_length=30L, help_text='市场地区代号,US,CN')
    market_abbreviation = models.CharField(max_length=30L, null=True, help_text='市场简写')

    class Meta:
        db_table = 'market_market'
        app_label = 'market'
        managed = False

    def __unicode__(self):
        return '%s' % self.market_name

class UrgentRule(models.Model):
    CHANNEL = (
        ('Aliexpress', 'Aliexpress'),
        ...
    )
    MESSAGE = {
   
        ('a1','加急单无发票'),
        ('a2', '加急单有发票'),
        ('a3', 'Lazada加急单'),
        ('a4', 'Ebay加急单'),
        ('a5', 'Shopee加急单'),
        ('a6', '加急'),