Back

SQL Details

Executed SQL
SELECT categories.id AS categories_id, categories.title AS categories_title, categories.description AS categories_description, categories.position AS categories_position, anon_1.id AS anon_1_id, anon_1.category_id AS anon_1_category_id, anon_1.title AS anon_1_title, anon_1.description AS anon_1_description, anon_1.position AS anon_1_position, anon_1.locked AS anon_1_locked, anon_1.show_moderators AS anon_1_show_moderators, anon_1.external AS anon_1_external, anon_1.post_count AS anon_1_post_count, anon_1.topic_count AS anon_1_topic_count, anon_1.last_post_id AS anon_1_last_post_id, anon_1.last_post_title AS anon_1_last_post_title, anon_1.last_post_user_id AS anon_1_last_post_user_id, anon_1.last_post_username AS anon_1_last_post_username, anon_1.last_post_created AS anon_1_last_post_created, users_1.password AS users_1_password, groups_1.id AS groups_1_id, groups_1.name AS groups_1_name, groups_1.description AS groups_1_description, groups_1.admin AS groups_1_admin, groups_1.super_mod AS groups_1_super_mod, groups_1.mod AS groups_1_mod, groups_1.guest AS groups_1_guest, groups_1.banned AS groups_1_banned, groups_1.mod_edituser AS groups_1_mod_edituser, groups_1.mod_banuser AS groups_1_mod_banuser, groups_1.editpost AS groups_1_editpost, groups_1.deletepost AS groups_1_deletepost, groups_1.deletetopic AS groups_1_deletetopic, groups_1.posttopic AS groups_1_posttopic, groups_1.postreply AS groups_1_postreply, users_1.id AS users_1_id, users_1.username AS users_1_username, users_1.email AS users_1_email, users_1.date_joined AS users_1_date_joined, users_1.lastseen AS users_1_lastseen, users_1.birthday AS users_1_birthday, users_1.gender AS users_1_gender, users_1.website AS users_1_website, users_1.location AS users_1_location, users_1.signature AS users_1_signature, users_1.avatar AS users_1_avatar, users_1.notes AS users_1_notes, users_1.last_failed_login AS users_1_last_failed_login, users_1.login_attempts AS users_1_login_attempts, users_1.activated AS users_1_activated, users_1.theme AS users_1_theme, users_1.language AS users_1_language, users_1.post_count AS users_1_post_count, users_1.primary_group_id AS users_1_primary_group_id, groups_2.id AS groups_2_id, groups_2.name AS groups_2_name, groups_2.description AS groups_2_description, groups_2.admin AS groups_2_admin, groups_2.super_mod AS groups_2_super_mod, groups_2.mod AS groups_2_mod, groups_2.guest AS groups_2_guest, groups_2.banned AS groups_2_banned, groups_2.mod_edituser AS groups_2_mod_edituser, groups_2.mod_banuser AS groups_2_mod_banuser, groups_2.editpost AS groups_2_editpost, groups_2.deletepost AS groups_2_deletepost, groups_2.deletetopic AS groups_2_deletetopic, groups_2.posttopic AS groups_2_posttopic, groups_2.postreply AS groups_2_postreply 
FROM categories JOIN (SELECT forums.id AS id, forums.category_id AS category_id, forums.title AS title, forums.description AS description, forums.position AS position, forums.locked AS locked, forums.show_moderators AS show_moderators, forums.external AS external, forums.post_count AS post_count, forums.topic_count AS topic_count, forums.last_post_id AS last_post_id, forums.last_post_title AS last_post_title, forums.last_post_user_id AS last_post_user_id, forums.last_post_username AS last_post_username, forums.last_post_created AS last_post_created 
FROM forums 
WHERE EXISTS (SELECT 1 
FROM forumgroups, groups 
WHERE forumgroups.forum_id = forums.id AND groups.id = forumgroups.group_id AND groups.id = ?)) AS anon_1 ON categories.id = anon_1.category_id LEFT OUTER JOIN (moderators AS moderators_1 JOIN users AS users_1 ON users_1.id = moderators_1.user_id) ON moderators_1.forum_id = anon_1.id LEFT OUTER JOIN groups AS groups_1 ON groups_1.id = users_1.primary_group_id LEFT OUTER JOIN (forumgroups AS forumgroups_1 JOIN groups AS groups_2 ON groups_2.id = forumgroups_1.group_id) ON forumgroups_1.forum_id = anon_1.id ORDER BY categories.position, categories.id, anon_1.position
Original query duration
2.4140 ms
CATEGORIES_ID CATEGORIES_TITLE CATEGORIES_DESCRIPTION CATEGORIES_POSITION ANON_1_ID ANON_1_CATEGORY_ID ANON_1_TITLE ANON_1_DESCRIPTION ANON_1_POSITION ANON_1_LOCKED ANON_1_SHOW_MODERATORS ANON_1_EXTERNAL ANON_1_POST_COUNT ANON_1_TOPIC_COUNT ANON_1_LAST_POST_ID ANON_1_LAST_POST_TITLE ANON_1_LAST_POST_USER_ID ANON_1_LAST_POST_USERNAME ANON_1_LAST_POST_CREATED USERS_1_PASSWORD GROUPS_1_ID GROUPS_1_NAME GROUPS_1_DESCRIPTION GROUPS_1_ADMIN GROUPS_1_SUPER_MOD GROUPS_1_MOD GROUPS_1_GUEST GROUPS_1_BANNED GROUPS_1_MOD_EDITUSER GROUPS_1_MOD_BANUSER GROUPS_1_EDITPOST GROUPS_1_DELETEPOST GROUPS_1_DELETETOPIC GROUPS_1_POSTTOPIC GROUPS_1_POSTREPLY USERS_1_ID USERS_1_USERNAME USERS_1_EMAIL USERS_1_DATE_JOINED USERS_1_LASTSEEN USERS_1_BIRTHDAY USERS_1_GENDER USERS_1_WEBSITE USERS_1_LOCATION USERS_1_SIGNATURE USERS_1_AVATAR USERS_1_NOTES USERS_1_LAST_FAILED_LOGIN USERS_1_LOGIN_ATTEMPTS USERS_1_ACTIVATED USERS_1_THEME USERS_1_LANGUAGE USERS_1_POST_COUNT USERS_1_PRIMARY_GROUP_ID GROUPS_2_ID GROUPS_2_NAME GROUPS_2_DESCRIPTION GROUPS_2_ADMIN GROUPS_2_SUPER_MOD GROUPS_2_MOD GROUPS_2_GUEST GROUPS_2_BANNED GROUPS_2_MOD_EDITUSER GROUPS_2_MOD_BANUSER GROUPS_2_EDITPOST GROUPS_2_DELETEPOST GROUPS_2_DELETETOPIC GROUPS_2_POSTTOPIC GROUPS_2_POSTREPLY
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 1 1 The Growler Yet another web-based journalism project - [thegrowler.org](http://thegrowler.org). 1 0 0 1 1 1 About theGrowler.org 1 growler 2016-11-21 01:05:40.363338 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 1 Administrator The Administrator Group 1 0 0 0 0 1 1 1 1 1 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 1 1 The Growler Yet another web-based journalism project - [thegrowler.org](http://thegrowler.org). 1 0 0 1 1 1 About theGrowler.org 1 growler 2016-11-21 01:05:40.363338 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 2 Super Moderator The Super Moderator Group 0 1 0 0 0 1 1 1 1 1 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 1 1 The Growler Yet another web-based journalism project - [thegrowler.org](http://thegrowler.org). 1 0 0 1 1 1 About theGrowler.org 1 growler 2016-11-21 01:05:40.363338 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 3 Moderator The Moderator Group 0 0 1 0 0 1 1 1 1 1 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 1 1 The Growler Yet another web-based journalism project - [thegrowler.org](http://thegrowler.org). 1 0 0 1 1 1 About theGrowler.org 1 growler 2016-11-21 01:05:40.363338 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 4 Member The Member Group 0 0 0 0 0 0 0 1 0 0 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 1 1 The Growler Yet another web-based journalism project - [thegrowler.org](http://thegrowler.org). 1 0 0 1 1 1 About theGrowler.org 1 growler 2016-11-21 01:05:40.363338 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 5 Banned The Banned Group 0 0 0 0 1 0 0 0 0 0 0 0
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 1 1 The Growler Yet another web-based journalism project - [thegrowler.org](http://thegrowler.org). 1 0 0 1 1 1 About theGrowler.org 1 growler 2016-11-21 01:05:40.363338 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 6 Guest The Guest Group 0 0 0 1 0 0 0 0 0 0 0 0
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 2 1 BAD DEEDS How often are deeds filed with the city fraudulent? We reviewed a few thousand. The results might, or if you are cynic, might not, surprise you. 1 0 0 0 0 None None None None 2016-11-21 01:01:31.555306 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 1 Administrator The Administrator Group 1 0 0 0 0 1 1 1 1 1 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 2 1 BAD DEEDS How often are deeds filed with the city fraudulent? We reviewed a few thousand. The results might, or if you are cynic, might not, surprise you. 1 0 0 0 0 None None None None 2016-11-21 01:01:31.555306 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 2 Super Moderator The Super Moderator Group 0 1 0 0 0 1 1 1 1 1 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 2 1 BAD DEEDS How often are deeds filed with the city fraudulent? We reviewed a few thousand. The results might, or if you are cynic, might not, surprise you. 1 0 0 0 0 None None None None 2016-11-21 01:01:31.555306 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 3 Moderator The Moderator Group 0 0 1 0 0 1 1 1 1 1 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 2 1 BAD DEEDS How often are deeds filed with the city fraudulent? We reviewed a few thousand. The results might, or if you are cynic, might not, surprise you. 1 0 0 0 0 None None None None 2016-11-21 01:01:31.555306 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 4 Member The Member Group 0 0 0 0 0 0 0 1 0 0 1 1
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 2 1 BAD DEEDS How often are deeds filed with the city fraudulent? We reviewed a few thousand. The results might, or if you are cynic, might not, surprise you. 1 0 0 0 0 None None None None 2016-11-21 01:01:31.555306 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 5 Banned The Banned Group 0 0 0 0 1 0 0 0 0 0 0 0
1 Journalism Many things are written and almost all are from a demonstrably flawed basis. often times the comments are better than the article itself. 1 2 1 BAD DEEDS How often are deeds filed with the city fraudulent? We reviewed a few thousand. The results might, or if you are cynic, might not, surprise you. 1 0 0 0 0 None None None None 2016-11-21 01:01:31.555306 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 6 Guest The Guest Group 0 0 0 1 0 0 0 0 0 0 0 0
2 HoodWatch 1 3 2 HoodCats Cats in the hood!!! 1 0 0 0 0 None None None None 2017-05-07 13:18:02.823025 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 1 Administrator The Administrator Group 1 0 0 0 0 1 1 1 1 1 1 1
2 HoodWatch 1 3 2 HoodCats Cats in the hood!!! 1 0 0 0 0 None None None None 2017-05-07 13:18:02.823025 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 2 Super Moderator The Super Moderator Group 0 1 0 0 0 1 1 1 1 1 1 1
2 HoodWatch 1 3 2 HoodCats Cats in the hood!!! 1 0 0 0 0 None None None None 2017-05-07 13:18:02.823025 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 3 Moderator The Moderator Group 0 0 1 0 0 1 1 1 1 1 1 1
2 HoodWatch 1 3 2 HoodCats Cats in the hood!!! 1 0 0 0 0 None None None None 2017-05-07 13:18:02.823025 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 4 Member The Member Group 0 0 0 0 0 0 0 1 0 0 1 1
2 HoodWatch 1 3 2 HoodCats Cats in the hood!!! 1 0 0 0 0 None None None None 2017-05-07 13:18:02.823025 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 5 Banned The Banned Group 0 0 0 0 1 0 0 0 0 0 0 0
2 HoodWatch 1 3 2 HoodCats Cats in the hood!!! 1 0 0 0 0 None None None None 2017-05-07 13:18:02.823025 None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None 6 Guest The Guest Group 0 0 0 1 0 0 0 0 0 0 0 0