cPanel/WHM

SELECT `sys_settings`.`var_name`, `sys_settings`.`var_value` FROM `sys_settings`

SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')

SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')

SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')

SELECT `sys_settings`.`var_value` FROM `sys_settings` WHERE (var_name = 'session_life_time_unlimited')

SELECT `ac`.`auto_relate`, `ac`.`max_staff_users`, `ac`.`max_client_users`, `ac`.`name`, (SELECT COUNT(*) FROM `users` WHERE (account_id = 2) AND (ldap_user = 'Y')) AS `ldap_users_num` FROM `accounts` AS `ac` WHERE (ac.account_id = 2)

SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (type   = 'staff') AND (active = 'Y') AND (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) AND (login != 'sales@web-site-scripts.com')

SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (type   = 'client') AND (active = 'Y') AND (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) AND (login != 'sales@web-site-scripts.com')

SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) = 0) AND (login != 'sales@web-site-scripts.com')

SELECT COUNT(*) AS `count` FROM `accounts` WHERE (LOWER(name) != 'preview')

SELECT `accounts`.`name` FROM `accounts` WHERE (LOWER(name) != 'preview') ORDER BY `account_id` ASC LIMIT 1

SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type       = 'Hosted') AND (account_id = 2)

SELECT `vm`.`view_id` AS `id`, `vm`.`name`, `vm`.`type`, `vm`.`hash`, `vm`.`settings` AS `tabs`, `vm`.`style_id` AS `styles`, `vm`.`gmt`, `vm`.`time_format`, `vm`.`date_format`, `vm`.`lang_id`, `vm`.`status`, `vm`.`access_mode`, `vm`.`voting_id` AS `voting`, `g`.`offset` AS `gmt_offset` FROM `view_manage` AS `vm`
 LEFT JOIN `gmt` AS `g` ON g.gmt_id = vm.gmt WHERE (view_id = 2)

SELECT `votings`.`voting_id` AS `value`, `votings`.`voting_name` AS `text` FROM `votings` WHERE (account_id = 2) OR (system = 'Y') ORDER BY `voting_name` ASC

SELECT `tpl`.`theme_id`, `tpl`.`theme_name`, `tpl`.`based_on`, `tpl`.`system`, CASE WHEN ((vm.style_id = tpl.copy_of_theme OR vm.style_id = tpl.theme_id) AND vm.account_id = 2) THEN 'Y' ELSE  'N' END AS `current` FROM `tpl_themes` AS `tpl`
 LEFT JOIN `view_manage` AS `vm` ON (vm.style_id = tpl.copy_of_theme OR vm.style_id = tpl.theme_id) AND vm.type = 'Hosted'  AND vm.account_id = 2 WHERE (tpl.account_id = 1 AND tpl.copy = 'N' AND tpl.system = 'Y') OR (tpl.account_id = 2 AND copy = 'N' AND tpl.system = 'N') ORDER BY `theme_name` ASC

SELECT `votings`.* FROM `votings` WHERE (voting_id = 1)

SELECT `voting_items`.`item_title` AS `title`, `voting_items`.`value` FROM `voting_items` WHERE (voting_id = 1) ORDER BY `value` DESC

SELECT `view_styles`.* FROM `view_styles` WHERE (style_id = 4)

SELECT `view_elements_styles`.`element_name` AS `name`, `view_elements_styles`.`element_type` AS `style` FROM `view_elements_styles` WHERE (style_id = 4) ORDER BY `element_name` ASC

SELECT `languages`.`name` AS `text`, `languages`.`lang_id` AS `value` FROM `languages` WHERE (status = 'on') AND (lang != 'def') ORDER BY `lang_id` ASC

SELECT `gmt`.* FROM `gmt` ORDER BY `offset` ASC

SELECT `view_manage`.`view_id` AS `id`, `view_manage`.`hash`, `view_manage`.`status`, `view_manage`.`lang_id`, `view_manage`.`name` FROM `view_manage` WHERE (account_id = 2) AND (type = 'HOSTED') LIMIT 1

SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type       = 'Hosted') AND (account_id = 2)

SELECT `view_manage`.`settings` FROM `view_manage` WHERE (view_id = 2)

UPDATE `view_manage` SET `views_num` = views_num + 1, `last_view_date` = ? WHERE (view_id = 2)

SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = '15')

SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)

SELECT `g`.`group_id` AS `gid`, `g`.`name`, `g`.`allow_delete`, `g`.`description`, `g`.`type`, (SELECT COUNT(user_id) FROM `users_groups` AS `ug` WHERE (ug.group_id = g.group_id)) AS `users_count` FROM `groups` AS `g` WHERE (account_id = 2) ORDER BY `name` ASC

DROP TABLE IF EXISTS `tmp_visible_articles_20101`;

DROP TABLE IF EXISTS `tmp_visible_articles_20101`;

CREATE TEMPORARY TABLE `tmp_visible_articles_20101` (`faq_id` int PRIMARY KEY) ENGINE=MEMORY

INSERT INTO `tmp_visible_articles_20101` SELECT `faq`.`faq_id` AS `id` FROM `faq_articles` AS `faq` USE INDEX (`PRIMARY`) WHERE (account_id = 2) AND (freeAccess = 'Y') AND (draft = 'N') AND (status = 'moderated') AND ( `public` = 'Y' AND
                                ((public_start_date <= '2013-05-24 00:29:46' OR public_start_date IS NULL)
                                    AND
                                  (public_end_date IS NULL OR public_end_date >= '2013-05-24 00:29:46')
                                ))

SELECT `tmp_visible_articles_20101`.`faq_id` FROM `tmp_visible_articles_20101`

SELECT `ac`.`category_id` FROM `articles_categories` AS `ac`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON ac.faq_id = tmp.faq_id UNION SELECT `fc`.`cat_id` AS `category_id` FROM `faq_categories` AS `fc` WHERE (fc.`public` = 'Y') AND (fc.account_id = 2)

SELECT `fc`.`cat_id` AS `id`, `fc`.`parent_id` AS `pid`, `fc`.`cat_name` AS `text`, `fc`.`position`, `fc`.`meta_keywords`, `fc`.`meta_description`, `fc`.`public`, CASE WHEN childCount.`count` IS NULL
                                                                                 THEN 0
                                                                                 ELSE childCount.`count`
                                                                             END  AS `childCount`, CASE WHEN totalArticles.`count` IS NULL
                                                                                    THEN 0
                                                                                    ELSE totalArticles.`count`
                                                                                END  AS `totalArticles` FROM `faq_categories` AS `fc`
 LEFT JOIN (SELECT `faq_categories`.`parent_id`, COUNT(cat_id) AS `count` FROM `faq_categories` GROUP BY `parent_id`) AS `childCount` ON childCount.parent_id = fc.cat_id
 LEFT JOIN (SELECT `ac`.`category_id`, COUNT(ac.faq_id) AS `count` FROM `articles_categories` AS `ac`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON ac.faq_id = tmp.faq_id GROUP BY `category_id`) AS `totalArticles` ON totalArticles.category_id = fc.cat_id WHERE (fc.account_id = 2) ORDER BY `fc`.`position` ASC, `fc`.`cat_name` ASC

SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmCategoryCreateEdit') AND (gp.value = '1')

SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmCategoryDelete') AND (gp.value = '1')

SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmArticleCreateEdit') AND (gp.value = '1')

SELECT `gcp`.`category_id` FROM `users_groups` AS `ug`
 LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id
 LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmArticleDelete') AND (gp.value = '1')

SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`featured`, `fa`.`rating`, `fa`.`views`, CASE
                                                     WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-24 00:29:46') OR (public_start_date IS NULL))
                                                            AND (public_end_date IS NULL OR public_end_date >= '2013-05-24 00:29:46')))
                                                     THEN 'Y'
                                                     ELSE 'N'
                                                  END  AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `ac`.`category_id` FROM `faq_articles` AS `fa`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON fa.faq_id = tmp.faq_id
 LEFT JOIN `articles_categories` AS `ac` ON ac.faq_id = fa.faq_id WHERE (ac.category_id IN (8,15) ) ORDER BY `fa`.`featured` ASC, `fa`.`question` asc

SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)

SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') AND (far.featured = 'Y') AND (far.faq_id IN (SELECT `articles_categories`.`faq_id` FROM `articles_categories` WHERE (category_id = '15'))) ORDER BY `far`.`status_change_date` DESC, `faqId` DESC LIMIT 10

SELECT COUNT(fa.faq_id) AS `num` FROM `faq_articles` AS `fa`
 LEFT JOIN `articles_categories` AS `ac` ON ac.faq_id = fa.faq_id
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON fa.faq_id = tmp.faq_id WHERE (ac.category_id = '15') AND (fa.draft = 'N') AND (fa.status = 'moderated')

SELECT `faq_categories`.`cat_id` FROM `faq_categories` WHERE (parent_id = 15)

SELECT COUNT(fa.faq_id) AS `num` FROM `faq_articles` AS `fa`
 LEFT JOIN `articles_categories` AS `ac` ON ac.faq_id = fa.faq_id
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON fa.faq_id = tmp.faq_id WHERE (ac.category_id = 30) AND (fa.draft = 'N') AND (fa.status = 'moderated')

SELECT `faq_categories`.`cat_id` FROM `faq_categories` WHERE (parent_id = 30)

SELECT COUNT(fa.faq_id) AS `num` FROM `faq_articles` AS `fa`
 LEFT JOIN `articles_categories` AS `ac` ON ac.faq_id = fa.faq_id
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON fa.faq_id = tmp.faq_id WHERE (ac.category_id = 111) AND (fa.draft = 'N') AND (fa.status = 'moderated')

SELECT `faq_categories`.`cat_id` FROM `faq_categories` WHERE (parent_id = 111)

SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') AND (far.faq_id IN (SELECT `articles_categories`.`faq_id` FROM `articles_categories` WHERE (category_id = '15'))) ORDER BY `far`.`views` DESC, `faqId` DESC LIMIT 10

SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') AND (far.faq_id IN (SELECT `articles_categories`.`faq_id` FROM `articles_categories` WHERE (category_id = '15'))) ORDER BY `far`.`rating` DESC, `faqId` DESC LIMIT 10

SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') AND (far.faq_id IN (SELECT `articles_categories`.`faq_id` FROM `articles_categories` WHERE (category_id = '15'))) ORDER BY `far`.`real_creation_date` DESC, `faqId` DESC LIMIT 10

SELECT `faq_categories`.`cat_name` FROM `faq_categories` WHERE (cat_id = '15') AND (account_id = 2) LIMIT 1

SELECT SQL_CALC_FOUND_ROWS `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far`
 INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') AND (far.faq_id IN (SELECT `articles_categories`.`faq_id` FROM `articles_categories` WHERE (category_id = '15'))) ORDER BY `far`.`featured` ASC, `far`.`question` asc, `faqId` DESC LIMIT 10

SELECT FOUND_ROWS()

SELECT `tpl_layouts`.`layout_id`, `tpl_layouts`.`template` FROM `tpl_layouts` WHERE (theme_id = 4) AND (layout_name = 'BrowseCategory')

SELECT `lb`.`block_id`, `lbc`.`block_name`, `lbc`.`template` FROM `tpl_layouts_blocks` AS `lb`
 INNER JOIN `tpl_blocks` AS `lbc` ON lbc.block_id = lb.block_id WHERE (layout_id = 61)

SELECT `tpl_snippets`.`template`, `tpl_snippets`.`snippet_name`, `tpl_snippets`.`block_id` FROM `tpl_snippets` WHERE (theme_id = 4)

SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')

SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')

SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 2) AND (type != 'notification')

UPDATE `faq_categories` SET `views` = views + 1 WHERE (cat_id = '15')

INSERT INTO `tmp_visible_articles_20101` SELECT `faq`.`faq_id` AS `id` FROM `faq_articles` AS `faq` USE INDEX (`PRIMARY`) WHERE (account_id = 2) AND (freeAccess = 'Y') AND (draft = 'N') AND (status = 'moderated') AND ( `public` = 'Y' AND
                                ((public_start_date <= '2013-05-24 00:29:46' OR public_start_date IS NULL)
                                    AND
                                  (public_end_date IS NULL OR public_end_date >= '2013-05-24 00:29:46')
                                ))

61