Popular Tags

Testmovie    Threetag2  Onetag  Twotag    Test 

Top partners

11 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`770
3DESCRIBE `aros_acos`770
4DESCRIBE `movies`15151
5DESCRIBE `users`38381
6DESCRIBE `movies_tags`330
7DESCRIBE `tags`220
8DESCRIBE `languages`440
9SELECT COUNT(*) AS `count` FROM `movies` AS `Movie` LEFT JOIN `users` AS `User` ON (`Movie`.`user_id` = `User`.`id`) WHERE `Movie`.`removed` <> 1 110
10SELECT `Movie`.`id`, `Movie`.`filename`, `Movie`.`screenshot`, `Movie`.`language_id`, `Movie`.`user_id`, `Movie`.`slug`, `Movie`.`title`, `Movie`.`summary`, `Movie`.`tags`, `Movie`.`runtime`, `Movie`.`created`, `Movie`.`modified`, `Movie`.`removed`, `Movie`.`encoded`, `Movie`.`random_filename`, `User`.`id`, `User`.`match_id`, `User`.`group`, `User`.`birthday`, `User`.`status`, `User`.`authority`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`dad`, `User`.`mom`, `User`.`kids`, `User`.`country`, `User`.`state`, `User`.`city`, `User`.`city_description`, `User`.`family_description`, `User`.`picture`, `User`.`pets`, `User`.`religion`, `User`.`drivinglicense`, `User`.`education`, `User`.`months_desired`, `User`.`preferred_start`, `User`.`special_needs`, `User`.`weekly_household_hours`, `User`.`references`, `User`.`dearfamily`, `User`.`dearaupair`, `User`.`last_login`, `User`.`last_activity`, `User`.`htmlEmail`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`country_id`, `User`.`rights` FROM `movies` AS `Movie` LEFT JOIN `users` AS `User` ON (`Movie`.`user_id` = `User`.`id`) WHERE `Movie`.`removed` <> 1 LIMIT 8880
11SELECT tag,count(movies_tags.tag_id) as quantity FROM movies_tags LEFT JOIN tags ON tags.id = movies_tags.tag_id GROUP BY tag_id ORDER BY quantity DESC LIMIT 25770