Buy it now..!

Training and Certification

Training and Certification tests	Outline	Demo	Purchase
SSCA® 'Elite' SIP training + on-line access to the SSCA® 'Elite' Certification test
SSCA® 'Elite' SIP training (no test access)
Networking 4 VVoIP + 'on-line' SSVVP™ certification test
SIP & Cloud - Advanced Sales training + SSSP™ test
Certification tests only
SSCA® 'Elite' Certification test access only (no training material)
SSVVP™ Certification test access only

(default) 48 queries took 4 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `login_logs`	5	5	1
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
3	SELECT `PreferencesProject`.`id`, `PreferencesProject`.`preference_id`, `PreferencesProject`.`project_id`, `PreferencesProject`.`value`, `PreferencesProject`.`created`, `PreferencesProject`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified`, `Preference`.`id`, `Preference`.`key`, `Preference`.`type`, `Preference`.`options`, `Preference`.`name`, `Preference`.`desc`, `Preference`.`sort_order`, `Preference`.`enabled`, `Preference`.`created`, `Preference`.`modified` FROM `preferences_projects` AS `PreferencesProject` LEFT JOIN `projects` AS `Project` ON (`PreferencesProject`.`project_id` = `Project`.`id`) LEFT JOIN `preferences` AS `Preference` ON (`PreferencesProject`.`preference_id` = `Preference`.`id`) WHERE `Project`.`id` = '2' AND `Preference`.`key` = 'themeroller' LIMIT 1	0	0	0
4	SELECT `ThemeConfig`.`id`, `ThemeConfig`.`alias`, `ThemeConfig`.`key`, `ThemeConfig`.`value`, `ThemeConfig`.`created`, `ThemeConfig`.`modified` FROM `theme_configs` AS `ThemeConfig` WHERE `ThemeConfig`.`alias` = 'sipschool'	18	18	0
5	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 94 LIMIT 1	1	1	0
6	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 101 LIMIT 1	1	1	0
7	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 147 LIMIT 1	1	1	0
8	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 226 LIMIT 1	1	1	0
9	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 97 LIMIT 1	1	1	0
10	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`category` = 'bannergroup' ORDER BY RAND() ASC LIMIT 1	1	1	1
11	SELECT `DesignConfig`.`id`, `DesignConfig`.`alias`, `DesignConfig`.`group`, `DesignConfig`.`key`, `DesignConfig`.`value`, `DesignConfig`.`params`, `DesignConfig`.`enabled`, `DesignConfig`.`created`, `DesignConfig`.`modified` FROM `design_configs` AS `DesignConfig` WHERE `DesignConfig`.`alias` = 'sipschool'	33	33	0
12	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 264 LIMIT 1	1	1	0
13	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 228 LIMIT 1	1	1	0
14	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 446 LIMIT 1	1	1	0
15	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 430 LIMIT 1	1	1	0
16	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 479 LIMIT 1	1	1	0
17	SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 432 LIMIT 1	1	1	0
18	SELECT `PreferencesProject`.`id`, `PreferencesProject`.`preference_id`, `PreferencesProject`.`project_id`, `PreferencesProject`.`value`, `PreferencesProject`.`created`, `PreferencesProject`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified`, `Preference`.`id`, `Preference`.`key`, `Preference`.`type`, `Preference`.`options`, `Preference`.`name`, `Preference`.`desc`, `Preference`.`sort_order`, `Preference`.`enabled`, `Preference`.`created`, `Preference`.`modified` FROM `preferences_projects` AS `PreferencesProject` LEFT JOIN `projects` AS `Project` ON (`PreferencesProject`.`project_id` = `Project`.`id`) LEFT JOIN `preferences` AS `Preference` ON (`PreferencesProject`.`preference_id` = `Preference`.`id`) WHERE alias = 'sipschool'	53	53	0
19	SELECT `Message`.`id`, `Message`.`key`, `Message`.`message`, `Message`.`enabled`, `Message`.`html`, `Message`.`created`, `Message`.`modified` FROM `messages` AS `Message` WHERE 1 = 1	33	33	0
20	SELECT `Quote`.* FROM `quotes` AS `Quote` LEFT JOIN `projects_quotes` AS `ProjectsQuote` ON (`ProjectsQuote`.`quote_id` = `Quote`.`id`) WHERE `ProjectsQuote`.`project_id` = 2 AND enabled = 1 AND sort_order < 99 ORDER BY `sort_order` ASC	16	16	0
21	SELECT `Quote`.* FROM `quotes` AS `Quote` LEFT JOIN `projects_quotes` AS `ProjectsQuote` ON (`ProjectsQuote`.`quote_id` = `Quote`.`id`) WHERE `ProjectsQuote`.`project_id` = 2 AND enabled = 1 AND sort_order = 99 ORDER BY RAND() ASC	0	0	1
22	SELECT `MenuItem`.`id`, `MenuItem`.`key`, `MenuItem`.`name`, `MenuItem`.`link`, `MenuItem`.`style`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `menu_items` AS `MenuItem` WHERE 1 = 1	20	20	0
23	SELECT `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified` FROM `projects` AS `Project` WHERE `Project`.`alias` = 'sipschool' LIMIT 1	1	1	0
24	SELECT `Course`.`id`, `Course`.`name`, `Course`.`alias`, `Course`.`description`, `Course`.`enabled`, `Course`.`ordering`, `Course`.`chargeable`, `Course`.`showpurchase`, `Course`.`created`, `Course`.`modified`, `Course`.`launcher`, `CoursesProject`.`course_id`, `CoursesProject`.`project_id` FROM `courses` AS `Course` JOIN `courses_projects` AS `CoursesProject` ON (`CoursesProject`.`project_id` = 2 AND `CoursesProject`.`course_id` = `Course`.`id`) ORDER BY `ordering` ASC	14	14	0
25	SELECT `PreferencesProject`.`id`, `PreferencesProject`.`preference_id`, `PreferencesProject`.`project_id`, `PreferencesProject`.`value`, `PreferencesProject`.`created`, `PreferencesProject`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified`, `Preference`.`id`, `Preference`.`key`, `Preference`.`type`, `Preference`.`options`, `Preference`.`name`, `Preference`.`desc`, `Preference`.`sort_order`, `Preference`.`enabled`, `Preference`.`created`, `Preference`.`modified` FROM `preferences_projects` AS `PreferencesProject` LEFT JOIN `projects` AS `Project` ON (`PreferencesProject`.`project_id` = `Project`.`id`) LEFT JOIN `preferences` AS `Preference` ON (`PreferencesProject`.`preference_id` = `Preference`.`id`) WHERE `Project`.`id` = '2' AND `Preference`.`key` = 'purchase' LIMIT 1	1	1	0
26	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 20 AND `Course`.`enabled` = 1	1	1	0
27	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 217 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	0	0	0
28	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 290 AND `Course`.`enabled` = 1	0	0	0
29	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 1 AND `Course`.`enabled` = 1	1	1	0
30	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 1 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	15	15	0
31	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 27 AND `Course`.`enabled` = 1	1	1	0
32	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 37 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	15	15	0
33	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 6 AND `Course`.`enabled` = 1	1	1	0
34	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 12 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	19	19	0
35	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 288 AND `Course`.`enabled` = 1	1	1	0
36	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 295 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	19	19	0
37	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 162 AND `Course`.`enabled` = 1	0	0	0
38	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 38 AND `Course`.`enabled` = 1	1	1	0
39	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 48 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	5	5	0
40	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 201 AND `Course`.`enabled` = 1	0	0	0
41	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 207 AND `Course`.`enabled` = 1	1	1	0
42	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 218 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	11	11	0
43	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 21 AND `Course`.`enabled` = 1	1	1	0
44	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 31 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	0	0	0
45	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 54 AND `Course`.`enabled` = 1	1	1	0
46	SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 65 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC	0	0	0
47	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 227 AND `Course`.`enabled` = 1	0	0	0
48	SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 208 AND `Course`.`enabled` = 1	0	0	0

(default) 48 queries took 4 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `login_logs`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';

SELECT `PreferencesProject`.`id`, `PreferencesProject`.`preference_id`, `PreferencesProject`.`project_id`, `PreferencesProject`.`value`, `PreferencesProject`.`created`, `PreferencesProject`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified`, `Preference`.`id`, `Preference`.`key`, `Preference`.`type`, `Preference`.`options`, `Preference`.`name`, `Preference`.`desc`, `Preference`.`sort_order`, `Preference`.`enabled`, `Preference`.`created`, `Preference`.`modified` FROM `preferences_projects` AS `PreferencesProject` LEFT JOIN `projects` AS `Project` ON (`PreferencesProject`.`project_id` = `Project`.`id`) LEFT JOIN `preferences` AS `Preference` ON (`PreferencesProject`.`preference_id` = `Preference`.`id`) WHERE `Project`.`id` = '2' AND `Preference`.`key` = 'themeroller' LIMIT 1

SELECT `ThemeConfig`.`id`, `ThemeConfig`.`alias`, `ThemeConfig`.`key`, `ThemeConfig`.`value`, `ThemeConfig`.`created`, `ThemeConfig`.`modified` FROM `theme_configs` AS `ThemeConfig` WHERE `ThemeConfig`.`alias` = 'sipschool'

SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 94 LIMIT 1

SELECT `DesignConfig`.`id`, `DesignConfig`.`alias`, `DesignConfig`.`group`, `DesignConfig`.`key`, `DesignConfig`.`value`, `DesignConfig`.`params`, `DesignConfig`.`enabled`, `DesignConfig`.`created`, `DesignConfig`.`modified` FROM `design_configs` AS `DesignConfig` WHERE `DesignConfig`.`alias` = 'sipschool'

SELECT `Message`.`id`, `Message`.`key`, `Message`.`message`, `Message`.`enabled`, `Message`.`html`, `Message`.`created`, `Message`.`modified` FROM `messages` AS `Message` WHERE 1 = 1

SELECT `Quote`.* FROM `quotes` AS `Quote` LEFT JOIN `projects_quotes` AS `ProjectsQuote` ON (`ProjectsQuote`.`quote_id` = `Quote`.`id`) WHERE `ProjectsQuote`.`project_id` = 2 AND enabled = 1 AND sort_order < 99 ORDER BY `sort_order` ASC

SELECT `MenuItem`.`id`, `MenuItem`.`key`, `MenuItem`.`name`, `MenuItem`.`link`, `MenuItem`.`style`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `menu_items` AS `MenuItem` WHERE 1 = 1

SELECT `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified` FROM `projects` AS `Project` WHERE `Project`.`alias` = 'sipschool' LIMIT 1

SELECT `Course`.`id`, `Course`.`name`, `Course`.`alias`, `Course`.`description`, `Course`.`enabled`, `Course`.`ordering`, `Course`.`chargeable`, `Course`.`showpurchase`, `Course`.`created`, `Course`.`modified`, `Course`.`launcher`, `CoursesProject`.`course_id`, `CoursesProject`.`project_id` FROM `courses` AS `Course` JOIN `courses_projects` AS `CoursesProject` ON (`CoursesProject`.`project_id` = 2 AND `CoursesProject`.`course_id` = `Course`.`id`) ORDER BY `ordering` ASC

SELECT DISTINCT `CourseModule`.id, `Course`.name, `Course`.description, `Course`.chargeable, `Course`.showpurchase, `Course`.ordering, `Language`.flag, `CourseModule`.demo_id, `CourseModule`.api_demo_module, `CourseModule`.outline_doc FROM `course_modules` AS `CourseModule` LEFT JOIN `courses` AS `Course` ON (`CourseModule`.`course_id` = `Course`.`id`) LEFT JOIN `languages` AS `Language` ON (`CourseModule`.`language_id` = `Language`.`id`) LEFT JOIN `tests` AS `Test` ON (`CourseModule`.`test_id` = `Test`.`id`) LEFT JOIN `courses_login_logs` AS `CoursesLoginLog` ON (`CoursesLoginLog`.`course_module_id` = `CourseModule`.`id`) WHERE `CourseModule`.`course_id` = 20 AND `Course`.`enabled` = 1

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 217 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 1 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 37 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 12 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 295 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 48 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 218 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 31 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

SELECT `Module`.`id`, `Module`.`server_id`, `Module`.`project_id`, `Module`.`parent_id`, `Module`.`name`, `Module`.`alias`, `Module`.`description`, `Module`.`web_objects`, `Module`.`public`, `Module`.`bucket`, `Module`.`start_file`, `Module`.`html5`, `Module`.`sort`, `Module`.`created`, `Module`.`modified`, `CourseModulesModule`.`course_module_id`, `CourseModulesModule`.`module_id` FROM `modules` AS `Module` JOIN `course_modules_modules` AS `CourseModulesModule` ON (`CourseModulesModule`.`course_module_id` = 65 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC

Training and Certification

SSCA® 'Elite' SIP training + on-line access to the SSCA® 'Elite' Certification test

SSCA® 'Elite' SIP training (no test access)

Networking 4 VVoIP + 'on-line' SSVVP™ certification test

SIP & Cloud - Advanced Sales training + SSSP™ test

Certification tests only

SSCA® 'Elite' Certification test access only (no training material)

SSVVP™ Certification test access only