github.com/unigraph-dev/dgraph@v1.1.1-0.20200923154953-8b52b426f765/systest/21million/queries/query-044 (about)

     1  {
     2    movies as var(func: gt(count(~genre), 30000), orderasc: name@en) {
     3      name@en
     4      ~genre (orderasc: name@en, first: 2) @filter(gt(count(starring), 2)) {
     5        starring {
     6          performance.actor {
     7            ActorName as name@en
     8          }
     9          Stars as min(val(ActorName))
    10        }
    11      }
    12    }
    13  
    14    movies(func: uid(movies)) {
    15      name@en
    16      director.film: ~genre (orderasc: name@en, first: 2) @filter(gt(count(starring), 2)) {
    17        name@en
    18        starring (orderasc: val(Stars), first: 2) {
    19          performance.actor {
    20            name@en
    21          }
    22        }
    23      }
    24    }
    25  }
    26  ---
    27  {
    28    "movies": [
    29      {
    30        "name@en": "Documentary film",
    31        "director.film": [
    32          {
    33            "name@en": "!Women Art Revolution",
    34            "starring": [
    35              {
    36                "performance.actor": [
    37                  {
    38                    "name@en": "B. Ruby Rich"
    39                  }
    40                ]
    41              },
    42              {
    43                "performance.actor": [
    44                  {
    45                    "name@en": "Barbara Kruger"
    46                  }
    47                ]
    48              }
    49            ]
    50          },
    51          {
    52            "name@en": "$100 and a T-Shirt: A Documentary About Zines in the Northwest",
    53            "starring": [
    54              {
    55                "performance.actor": [
    56                  {
    57                    "name@en": "Calvin Johnson"
    58                  }
    59                ]
    60              },
    61              {
    62                "performance.actor": [
    63                  {
    64                    "name@en": "Donna Cossy"
    65                  }
    66                ]
    67              }
    68            ]
    69          }
    70        ]
    71      },
    72      {
    73        "name@en": "Short Film",
    74        "director.film": [
    75          {
    76            "name@en": "#PostModem",
    77            "starring": [
    78              {
    79                "performance.actor": [
    80                  {
    81                    "name@en": "Amy Seimetz"
    82                  }
    83                ]
    84              },
    85              {
    86                "performance.actor": [
    87                  {
    88                    "name@en": "Arly Montes"
    89                  }
    90                ]
    91              }
    92            ]
    93          },
    94          {
    95            "name@en": "#twitterkills",
    96            "starring": [
    97              {
    98                "performance.actor": [
    99                  {
   100                    "name@en": "Amanda Hendy"
   101                  }
   102                ]
   103              },
   104              {
   105                "performance.actor": [
   106                  {
   107                    "name@en": "Annie Hendy"
   108                  }
   109                ]
   110              }
   111            ]
   112          }
   113        ]
   114      },
   115      {
   116        "name@en": "Drama",
   117        "director.film": [
   118          {
   119            "name@en": "$100,000 for Ringo",
   120            "starring": [
   121              {
   122                "performance.actor": [
   123                  {
   124                    "name@en": "Eleonora Bianchi"
   125                  }
   126                ]
   127              },
   128              {
   129                "performance.actor": [
   130                  {
   131                    "name@en": "Fernando Sancho"
   132                  }
   133                ]
   134              }
   135            ]
   136          },
   137          {
   138            "name@en": "$9.99",
   139            "starring": [
   140              {
   141                "performance.actor": [
   142                  {
   143                    "name@en": "Anthony LaPaglia"
   144                  }
   145                ]
   146              },
   147              {
   148                "performance.actor": [
   149                  {
   150                    "name@en": "Barry Otto"
   151                  }
   152                ]
   153              }
   154            ]
   155          }
   156        ]
   157      },
   158      {
   159        "name@en": "Comedy",
   160        "director.film": [
   161          {
   162            "name@en": "\"FF.SS.\" – Cioè: \"...che mi hai portato a fare sopra a Posillipo se non mi vuoi più bene?\"",
   163            "starring": [
   164              {
   165                "performance.actor": [
   166                  {
   167                    "name@en": "Alfredo Cerruti"
   168                  }
   169                ]
   170              },
   171              {
   172                "performance.actor": [
   173                  {
   174                    "name@en": "Bobby Solo"
   175                  }
   176                ]
   177              }
   178            ]
   179          },
   180          {
   181            "name@en": "#1 Cheerleader Camp",
   182            "starring": [
   183              {
   184                "performance.actor": [
   185                  {
   186                    "name@en": "Adam Wright"
   187                  }
   188                ]
   189              },
   190              {
   191                "performance.actor": [
   192                  {
   193                    "name@en": "Alex Kozitsky"
   194                  }
   195                ]
   196              }
   197            ]
   198          }
   199        ]
   200      }
   201    ]
   202  }