Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
SELECT name name_category, COUNT(fa.film_id) total_films FROM (SELECT film_id FROM film_actor WHERE actor_id IN (SELECT actor_id FROM film_actor WHERE film_id in (SELECT film_id FROM movie WHERE release_year>2013) GROUP BY actor_id HAVING count(film_id)>7)) AS fa LEFT JOIN movie AS m ON m.film_id = fa.film_id LEFT JOIN film_category AS fc ON fa.film_id = fc.film_id LEFT JOIN category AS c ON fc.category_id = c.category_id GROUP BY name ORDER BY total_films DESC, name_category
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
