Background Image

Buy SSCA  SIP and get SIP and Cloud Advanced Sales for free!

For April 2024 only, if you purchase the SSCA ‘Elite’ training along with the SSCA certification test we’ll throw in our SIP and Cloud Advanced Sales training + SSSP™ test for free!

Details/Demos on SSCA here

Details/Demos on SIP and Cloud Advanced Sales here

BUY IT NOW

NOTE: If you purchase a SIP training license for Student A, the Sales license is assigned to Student A and and cannot be transferred to Student B (for example).

(default) 54 queries took 33 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `pages`12121
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
4SHOW FULL COLUMNS FROM `email_settings`12121
5SHOW FULL COLUMNS FROM `terms`551
6SHOW FULL COLUMNS FROM `contacts`881
7SHOW FULL COLUMNS FROM `news_feeds`771
8SHOW FULL COLUMNS FROM `courses`11111
9SHOW FULL COLUMNS FROM `course_modules`18181
10SHOW FULL COLUMNS FROM `languages`881
11SHOW FULL COLUMNS FROM `tests`26261
12SHOW FULL COLUMNS FROM `questions`991
13SHOW FULL COLUMNS FROM `answers`661
14SHOW FULL COLUMNS FROM `questions_tests`221
15SHOW FULL COLUMNS FROM `languages_tests`221
16SHOW FULL COLUMNS FROM `courses_login_logs`661
17SHOW FULL COLUMNS FROM `modules`15151
18SHOW FULL COLUMNS FROM `servers`991
19SHOW FULL COLUMNS FROM `modules_login_logs`771
20SHOW FULL COLUMNS FROM `course_modules_modules`220
21SHOW FULL COLUMNS FROM `policies`771
22SHOW FULL COLUMNS FROM `theme_configs`661
23SHOW FULL COLUMNS FROM `groups`881
24SHOW FULL COLUMNS FROM `voips`991
25SHOW FULL COLUMNS FROM `menu_items`771
26SHOW FULL COLUMNS FROM `design_configs`991
27SHOW FULL COLUMNS FROM `messages`771
28SHOW FULL COLUMNS FROM `online_exams`13131
29SHOW FULL COLUMNS FROM `profiles`881
30SELECT `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 1111
31SELECT `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 1000
32SELECT `ThemeConfig`.`id`, `ThemeConfig`.`alias`, `ThemeConfig`.`key`, `ThemeConfig`.`value`, `ThemeConfig`.`created`, `ThemeConfig`.`modified` FROM `theme_configs` AS `ThemeConfig` WHERE `ThemeConfig`.`alias` = 'sipschool' 18180
33SELECT `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 1110
34SELECT `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 1110
35SELECT `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 1110
36SELECT `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 1110
37SELECT `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 1110
38SELECT `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 1111
39SELECT `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' 33330
40SELECT `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 1110
41SELECT `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 1110
42SELECT `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 1110
43SELECT `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 1110
44SELECT `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 1110
45SELECT `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 1110
46SELECT `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' 53530
47SELECT `Message`.`id`, `Message`.`key`, `Message`.`message`, `Message`.`enabled`, `Message`.`html`, `Message`.`created`, `Message`.`modified` FROM `messages` AS `Message` WHERE 1 = 1 33330
48SELECT `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 1110
49SHOW FULL COLUMNS FROM `projects_quotes`221
50SELECT `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 16160
51SELECT `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 001
52SELECT `MenuItem`.`id`, `MenuItem`.`key`, `MenuItem`.`name`, `MenuItem`.`link`, `MenuItem`.`style`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `menu_items` AS `MenuItem` WHERE 1 = 1 20200
53SELECT `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` = 'offer.html' AND `Project`.`alias` = 'sipschool' LIMIT 1001
54SELECT `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` = 'offer.html' AND (`Page`.`project_id` = 0 OR `Page`.`project_id` IS NULL) LIMIT 1110