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

     1  {
     2    var(func: allofterms(name@en, "Taraji Henson")) {
     3      actor.film {
     4        F as performance.film {
     5          G as count(genre)
     6          genre {
     7            C as count(~genre @filter(uid(F)))
     8          }
     9        }
    10      }
    11    }
    12  
    13    Taraji_films_by_genre_count(func: uid(G), orderdesc: val(G)) {
    14      film_name : name@en
    15      genres : genre (orderdesc: val(C)) {
    16        genre_name : name@en
    17      }
    18    }
    19  }
    20  ---
    21  {
    22    "Taraji_films_by_genre_count": [
    23      {
    24        "film_name": "Date Night",
    25        "genres": [
    26          {
    27            "genre_name": "Comedy"
    28          },
    29          {
    30            "genre_name": "Crime Fiction"
    31          },
    32          {
    33            "genre_name": "Romance Film"
    34          },
    35          {
    36            "genre_name": "Thriller"
    37          },
    38          {
    39            "genre_name": "Action Film"
    40          },
    41          {
    42            "genre_name": "Romantic comedy"
    43          },
    44          {
    45            "genre_name": "Action/Adventure"
    46          },
    47          {
    48            "genre_name": "Action Comedy"
    49          },
    50          {
    51            "genre_name": "Chase Movie"
    52          },
    53          {
    54            "genre_name": "Screwball comedy"
    55          }
    56        ]
    57      },
    58      {
    59        "film_name": "I Can Do Bad All by Myself",
    60        "genres": [
    61          {
    62            "genre_name": "Drama"
    63          },
    64          {
    65            "genre_name": "Comedy"
    66          },
    67          {
    68            "genre_name": "Romance Film"
    69          },
    70          {
    71            "genre_name": "Romantic comedy"
    72          },
    73          {
    74            "genre_name": "Comedy-drama"
    75          },
    76          {
    77            "genre_name": "Musical Drama"
    78          },
    79          {
    80            "genre_name": "Backstage Musical"
    81          },
    82          {
    83            "genre_name": "Musical comedy"
    84          }
    85        ]
    86      },
    87      {
    88        "film_name": "Four Brothers",
    89        "genres": [
    90          {
    91            "genre_name": "Drama"
    92          },
    93          {
    94            "genre_name": "Crime Fiction"
    95          },
    96          {
    97            "genre_name": "Thriller"
    98          },
    99          {
   100            "genre_name": "Action Film"
   101          },
   102          {
   103            "genre_name": "Action/Adventure"
   104          },
   105          {
   106            "genre_name": "Family Drama"
   107          },
   108          {
   109            "genre_name": "Crime Drama"
   110          }
   111        ]
   112      },
   113      {
   114        "film_name": "Hustle & Flow",
   115        "genres": [
   116          {
   117            "genre_name": "Drama"
   118          },
   119          {
   120            "genre_name": "Crime Fiction"
   121          },
   122          {
   123            "genre_name": "Romance Film"
   124          },
   125          {
   126            "genre_name": "Indie film"
   127          },
   128          {
   129            "genre_name": "Musical Drama"
   130          },
   131          {
   132            "genre_name": "Music"
   133          },
   134          {
   135            "genre_name": "Hip hop film"
   136          }
   137        ]
   138      },
   139      {
   140        "film_name": "Smokin' Aces",
   141        "genres": [
   142          {
   143            "genre_name": "Drama"
   144          },
   145          {
   146            "genre_name": "Comedy"
   147          },
   148          {
   149            "genre_name": "Crime Fiction"
   150          },
   151          {
   152            "genre_name": "Thriller"
   153          },
   154          {
   155            "genre_name": "Action Film"
   156          },
   157          {
   158            "genre_name": "Black comedy"
   159          },
   160          {
   161            "genre_name": "Action Thriller"
   162          }
   163        ]
   164      },
   165      {
   166        "film_name": "The Adventures of Rocky and Bullwinkle",
   167        "genres": [
   168          {
   169            "genre_name": "Comedy"
   170          },
   171          {
   172            "genre_name": "Adventure Film"
   173          },
   174          {
   175            "genre_name": "Family"
   176          },
   177          {
   178            "genre_name": "Adventure Comedy"
   179          },
   180          {
   181            "genre_name": "Children's/Family"
   182          },
   183          {
   184            "genre_name": "Buddy film"
   185          },
   186          {
   187            "genre_name": "Fantasy Adventure"
   188          }
   189        ]
   190      },
   191      {
   192        "film_name": "Satan's School for Girls",
   193        "genres": [
   194          {
   195            "genre_name": "Drama"
   196          },
   197          {
   198            "genre_name": "Crime Fiction"
   199          },
   200          {
   201            "genre_name": "Mystery"
   202          },
   203          {
   204            "genre_name": "Horror"
   205          },
   206          {
   207            "genre_name": "Television film"
   208          },
   209          {
   210            "genre_name": "Cult film"
   211          }
   212        ]
   213      },
   214      {
   215        "film_name": "The Karate Kid",
   216        "genres": [
   217          {
   218            "genre_name": "Drama"
   219          },
   220          {
   221            "genre_name": "Comedy"
   222          },
   223          {
   224            "genre_name": "Action Film"
   225          },
   226          {
   227            "genre_name": "Sports films"
   228          },
   229          {
   230            "genre_name": "Family"
   231          },
   232          {
   233            "genre_name": "Martial Arts Film"
   234          }
   235        ]
   236      },
   237      {
   238        "film_name": "The Family That Preys",
   239        "genres": [
   240          {
   241            "genre_name": "Drama"
   242          },
   243          {
   244            "genre_name": "Comedy"
   245          },
   246          {
   247            "genre_name": "Romance Film"
   248          },
   249          {
   250            "genre_name": "Comedy-drama"
   251          },
   252          {
   253            "genre_name": "Family Drama"
   254          }
   255        ]
   256      },
   257      {
   258        "film_name": "Talk to Me",
   259        "genres": [
   260          {
   261            "genre_name": "Drama"
   262          },
   263          {
   264            "genre_name": "Music"
   265          },
   266          {
   267            "genre_name": "Biographical film"
   268          },
   269          {
   270            "genre_name": "History"
   271          },
   272          {
   273            "genre_name": "War film"
   274          }
   275        ]
   276      },
   277      {
   278        "film_name": "Not Easily Broken",
   279        "genres": [
   280          {
   281            "genre_name": "Drama"
   282          },
   283          {
   284            "genre_name": "Comedy"
   285          },
   286          {
   287            "genre_name": "Romance Film"
   288          },
   289          {
   290            "genre_name": "Film adaptation"
   291          }
   292        ]
   293      },
   294      {
   295        "film_name": "All or Nothing",
   296        "genres": [
   297          {
   298            "genre_name": "Drama"
   299          },
   300          {
   301            "genre_name": "Crime Fiction"
   302          },
   303          {
   304            "genre_name": "Romance Film"
   305          },
   306          {
   307            "genre_name": "Indie film"
   308          }
   309        ]
   310      },
   311      {
   312        "film_name": "Larry Crowne",
   313        "genres": [
   314          {
   315            "genre_name": "Drama"
   316          },
   317          {
   318            "genre_name": "Comedy"
   319          },
   320          {
   321            "genre_name": "Romance Film"
   322          },
   323          {
   324            "genre_name": "Romantic comedy"
   325          }
   326        ]
   327      },
   328      {
   329        "film_name": "Term Life",
   330        "genres": [
   331          {
   332            "genre_name": "Drama"
   333          },
   334          {
   335            "genre_name": "Thriller"
   336          },
   337          {
   338            "genre_name": "Crime"
   339          }
   340        ]
   341      },
   342      {
   343        "film_name": "Peep World",
   344        "genres": [
   345          {
   346            "genre_name": "Comedy"
   347          },
   348          {
   349            "genre_name": "Indie film"
   350          },
   351          {
   352            "genre_name": "Comedy-drama"
   353          }
   354        ]
   355      },
   356      {
   357        "film_name": "Something New",
   358        "genres": [
   359          {
   360            "genre_name": "Drama"
   361          },
   362          {
   363            "genre_name": "Comedy"
   364          },
   365          {
   366            "genre_name": "Romance Film"
   367          }
   368        ]
   369      },
   370      {
   371        "film_name": "Baby Boy",
   372        "genres": [
   373          {
   374            "genre_name": "Drama"
   375          },
   376          {
   377            "genre_name": "Crime Fiction"
   378          },
   379          {
   380            "genre_name": "Coming of age"
   381          }
   382        ]
   383      },
   384      {
   385        "film_name": "The Brotherly Love Table Read",
   386        "genres": [
   387          {
   388            "genre_name": "Comedy"
   389          },
   390          {
   391            "genre_name": "Short Film"
   392          },
   393          {
   394            "genre_name": "Animation"
   395          }
   396        ]
   397      },
   398      {
   399        "film_name": "The Curious Case of Benjamin Button",
   400        "genres": [
   401          {
   402            "genre_name": "Drama"
   403          },
   404          {
   405            "genre_name": "Romance Film"
   406          },
   407          {
   408            "genre_name": "Adventure Film"
   409          }
   410        ]
   411      },
   412      {
   413        "film_name": "Think Like A Man",
   414        "genres": [
   415          {
   416            "genre_name": "Comedy"
   417          },
   418          {
   419            "genre_name": "Romance Film"
   420          },
   421          {
   422            "genre_name": "Romantic comedy"
   423          }
   424        ]
   425      },
   426      {
   427        "film_name": "Once Fallen",
   428        "genres": [
   429          {
   430            "genre_name": "Drama"
   431          },
   432          {
   433            "genre_name": "Crime Fiction"
   434          },
   435          {
   436            "genre_name": "Indie film"
   437          }
   438        ]
   439      },
   440      {
   441        "film_name": "Hurricane Season",
   442        "genres": [
   443          {
   444            "genre_name": "Drama"
   445          },
   446          {
   447            "genre_name": "Sports films"
   448          }
   449        ]
   450      },
   451      {
   452        "film_name": "Forehead Tittaes",
   453        "genres": [
   454          {
   455            "genre_name": "Comedy"
   456          },
   457          {
   458            "genre_name": "Short Film"
   459          }
   460        ]
   461      },
   462      {
   463        "film_name": "Madly Madagascar",
   464        "genres": [
   465          {
   466            "genre_name": "Short Film"
   467          },
   468          {
   469            "genre_name": "Animation"
   470          }
   471        ]
   472      },
   473      {
   474        "film_name": "No Good Deed",
   475        "genres": [
   476          {
   477            "genre_name": "Crime Fiction"
   478          },
   479          {
   480            "genre_name": "Thriller"
   481          }
   482        ]
   483      },
   484      {
   485        "film_name": "The Good Doctor",
   486        "genres": [
   487          {
   488            "genre_name": "Drama"
   489          },
   490          {
   491            "genre_name": "Thriller"
   492          }
   493        ]
   494      },
   495      {
   496        "film_name": "Hair Show",
   497        "genres": [
   498          {
   499            "genre_name": "Comedy"
   500          },
   501          {
   502            "genre_name": "Indie film"
   503          }
   504        ]
   505      },
   506      {
   507        "film_name": "Animal",
   508        "genres": [
   509          {
   510            "genre_name": "Drama"
   511          },
   512          {
   513            "genre_name": "Crime Fiction"
   514          }
   515        ]
   516      },
   517      {
   518        "film_name": "From the Rough",
   519        "genres": [
   520          {
   521            "genre_name": "Drama"
   522          },
   523          {
   524            "genre_name": "Sports films"
   525          }
   526        ]
   527      },
   528      {
   529        "film_name": "Streetwise",
   530        "genres": [
   531          {
   532            "genre_name": "Crime Fiction"
   533          },
   534          {
   535            "genre_name": "Action Film"
   536          }
   537        ]
   538      },
   539      {
   540        "film_name": "Murder, She Wrote: The Last Free Man",
   541        "genres": [
   542          {
   543            "genre_name": "Mystery"
   544          }
   545        ]
   546      },
   547      {
   548        "film_name": "Taken From Me: The Tiffany Rubin Story",
   549        "genres": [
   550          {
   551            "genre_name": "Drama"
   552          }
   553        ]
   554      }
   555    ]
   556  }