generated.sql

-- qs = Rule.objects.filter(Q(gene_traits__pk=first_filter) and Q(gene_traits__pk=second_filter))
SELECT "datasets_rules"."id",
       "datasets_rules"."created",
       "datasets_rules"."modified",
       "datasets_rules"."label",
       "datasets_rules"."biopsy_batch_id"
FROM   "datasets_rules"
       INNER JOIN "datasets_rules_gene_traits"
               ON ( "datasets_rules"."id" =
                    "datasets_rules_gene_traits"."rule_id" )
WHERE  "datasets_rules_gene_traits"."gene_trait_id" =
       a2ce06b9 - 50e1 - 4efd - 82ad - b9f776b01681
ORDER  BY "datasets_rules"."modified" ASC  

-- qs = Rule.objects.filter(gene_traits__pk=first_filter)
-- qs.filter(gene_traits__pk=second_filter)
SELECT "datasets_rules"."id",
       "datasets_rules"."created",
       "datasets_rules"."modified",
       "datasets_rules"."label",
       "datasets_rules"."biopsy_batch_id"
FROM   "datasets_rules"
       INNER JOIN "datasets_rules_gene_traits"
               ON ( "datasets_rules"."id" =
                    "datasets_rules_gene_traits"."rule_id" )
WHERE  "datasets_rules_gene_traits"."gene_trait_id" =
       b0718305 - ce7c - 459f - b4e9 - e3ae33074b49
ORDER  BY "datasets_rules"."modified" ASC  

-- qs = Rule.objects.filter(gene_traits__pk=first_filter).filter(gene_traits__pk=second_filter)
SELECT "datasets_rules"."id",
       "datasets_rules"."created",
       "datasets_rules"."modified",
       "datasets_rules"."label",
       "datasets_rules"."biopsy_batch_id"
FROM   "datasets_rules"
       INNER JOIN "datasets_rules_gene_traits"
               ON ( "datasets_rules"."id" =
                    "datasets_rules_gene_traits"."rule_id" )
       INNER JOIN "datasets_rules_gene_traits" T4
               ON ( "datasets_rules"."id" = T4."rule_id" )
WHERE  ( "datasets_rules_gene_traits"."gene_trait_id" =
                  b0718305 - ce7c - 459f - b4e9 - e3ae33074b49
         AND T4."gene_trait_id" = a2ce06b9 - 50e1 - 4efd - 82ad - b9f776b01681 )
ORDER  BY "datasets_rules"."modified" ASC