Vocale Ltd is proud to have the support of the following Industry organisations and it's through these (plus many others not shown here) that make The SIP School and WebRTC School the industry leaders in SIP, VoIP and WebRTC certifications. For more detail on certifications attainable, please visit the FAQ page on this site.
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `pages` | 12 | 12 | 1 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 1 | |
| 3 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 1 | |
| 4 | SHOW FULL COLUMNS FROM `email_settings` | 12 | 12 | 1 | |
| 5 | SHOW FULL COLUMNS FROM `terms` | 5 | 5 | 1 | |
| 6 | SHOW FULL COLUMNS FROM `contacts` | 8 | 8 | 1 | |
| 7 | SHOW FULL COLUMNS FROM `news_feeds` | 7 | 7 | 1 | |
| 8 | SHOW FULL COLUMNS FROM `courses` | 11 | 11 | 1 | |
| 9 | SHOW FULL COLUMNS FROM `projects` | 6 | 6 | 1 | |
| 10 | SHOW FULL COLUMNS FROM `logs` | 9 | 9 | 1 | |
| 11 | SHOW FULL COLUMNS FROM `users` | 28 | 28 | 1 | |
| 12 | SHOW FULL COLUMNS FROM `clients` | 4 | 4 | 1 | |
| 13 | SHOW FULL COLUMNS FROM `clients_users` | 2 | 2 | 1 | |
| 14 | SHOW FULL COLUMNS FROM `course_modules` | 18 | 18 | 1 | |
| 15 | SHOW FULL COLUMNS FROM `languages` | 8 | 8 | 1 | |
| 16 | SHOW FULL COLUMNS FROM `tests` | 26 | 26 | 1 | |
| 17 | SHOW FULL COLUMNS FROM `questions` | 9 | 9 | 1 | |
| 18 | SHOW FULL COLUMNS FROM `answers` | 6 | 6 | 1 | |
| 19 | SHOW FULL COLUMNS FROM `questions_tests` | 2 | 2 | 1 | |
| 20 | SHOW FULL COLUMNS FROM `languages_tests` | 2 | 2 | 1 | |
| 21 | SHOW FULL COLUMNS FROM `courses_login_logs` | 6 | 6 | 1 | |
| 22 | SHOW FULL COLUMNS FROM `modules` | 15 | 15 | 1 | |
| 23 | SHOW FULL COLUMNS FROM `servers` | 9 | 9 | 1 | |
| 24 | SHOW FULL COLUMNS FROM `modules_login_logs` | 7 | 7 | 1 | |
| 25 | SHOW FULL COLUMNS FROM `course_modules_modules` | 2 | 2 | 1 | |
| 26 | SHOW FULL COLUMNS FROM `domains` | 5 | 5 | 1 | |
| 27 | SHOW FULL COLUMNS FROM `policies` | 7 | 7 | 1 | |
| 28 | SHOW FULL COLUMNS FROM `pdf_files` | 14 | 14 | 2 | |
| 29 | SHOW FULL COLUMNS FROM `preferences_projects` | 6 | 6 | 1 | |
| 30 | SHOW FULL COLUMNS FROM `preferences` | 10 | 10 | 1 | |
| 31 | SHOW FULL COLUMNS FROM `quotes` | 8 | 8 | 1 | |
| 32 | SHOW FULL COLUMNS FROM `addresses` | 24 | 24 | 1 | |
| 33 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_general_ci'; | 1 | 1 | 1 | |
| 34 | SHOW FULL COLUMNS FROM `countries` | 8 | 8 | 3 | |
| 35 | SHOW FULL COLUMNS FROM `taxes` | 8 | 8 | 1 | |
| 36 | SHOW FULL COLUMNS FROM `results` | 19 | 19 | 1 | |
| 37 | SHOW FULL COLUMNS FROM `theme_configs` | 6 | 6 | 1 | |
| 38 | SHOW FULL COLUMNS FROM `groups` | 8 | 8 | 1 | |
| 39 | SHOW FULL COLUMNS FROM `voips` | 9 | 9 | 3 | |
| 40 | SHOW FULL COLUMNS FROM `menu_items` | 7 | 7 | 1 | |
| 41 | SHOW FULL COLUMNS FROM `design_configs` | 9 | 9 | 1 | |
| 42 | SHOW FULL COLUMNS FROM `messages` | 7 | 7 | 1 | |
| 43 | SHOW FULL COLUMNS FROM `online_exams` | 13 | 13 | 1 | |
| 44 | SHOW FULL COLUMNS FROM `profiles` | 8 | 8 | 1 | |
| 45 | SELECT `Domain`.`id`, `Domain`.`project_id`, `Domain`.`domain`, `Domain`.`created`, `Domain`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified` FROM `domains` AS `Domain` LEFT JOIN `projects` AS `Project` ON (`Domain`.`project_id` = `Project`.`id`) WHERE domain = 'dev.thesipschool.com' LIMIT 1 | 1 | 1 | 0 | |
| 46 | 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 | |
| 47 | 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 | |
| 48 | 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 | |
| 49 | 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 | |
| 50 | 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 | |
| 51 | 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 | |
| 52 | 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 | |
| 53 | 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 | |
| 54 | 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 | |
| 55 | 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 | |
| 56 | 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 | |
| 57 | 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 | |
| 58 | 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 | |
| 59 | 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 | |
| 60 | 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 | |
| 61 | 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 | |
| 62 | 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 | |
| 63 | SELECT `Country`.`id`, `Country`.`iso`, `Country`.`name`, `Country`.`printable_name`, `Country`.`iso3`, `Country`.`numcode`, `Country`.`tax_id`, `Country`.`sorting`, `Tax`.`id`, `Tax`.`name`, `Tax`.`local_name`, `Tax`.`code`, `Tax`.`rate`, `Tax`.`message`, `Tax`.`created`, `Tax`.`modified` FROM `countries` AS `Country` LEFT JOIN `taxes` AS `Tax` ON (`Country`.`tax_id` = `Tax`.`id`) WHERE iso = 'US' LIMIT 1 | 1 | 1 | 0 | |
| 64 | SHOW FULL COLUMNS FROM `projects_quotes` | 2 | 2 | 1 | |
| 65 | 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 | |
| 66 | 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 | |
| 67 | 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 | |
| 68 | SELECT `Page`.`id`, `Page`.`project_id`, `Page`.`tag`, `Page`.`title`, `Page`.`content`, `Page`.`rightcode`, `Page`.`show_splash`, `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_desc`, `Page`.`created`, `Page`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified` FROM `pages` AS `Page` LEFT JOIN `projects` AS `Project` ON (`Page`.`project_id` = `Project`.`id`) WHERE `Page`.`tag` = 'industry.html' AND `Project`.`alias` = 'sipschool' LIMIT 1 | 0 | 0 | 0 | |
| 69 | SELECT `Page`.`id`, `Page`.`project_id`, `Page`.`tag`, `Page`.`title`, `Page`.`content`, `Page`.`rightcode`, `Page`.`show_splash`, `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_desc`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`tag` = 'industry.html' AND (`Page`.`project_id` = 0 OR `Page`.`project_id` IS NULL) LIMIT 1 | 1 | 1 | 0 |