| 1 | SHOW FULL COLUMNS FROM `courses` | | 11 | 11 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 3 | SHOW FULL COLUMNS FROM `login_logs` | | 5 | 5 | 1 |
| 4 | SHOW FULL COLUMNS FROM `course_modules` | | 18 | 18 | 1 |
| 5 | SHOW FULL COLUMNS FROM `courses_login_logs` | | 6 | 6 | 1 |
| 6 | SHOW FULL COLUMNS FROM `modules` | | 15 | 15 | 1 |
| 7 | SHOW FULL COLUMNS FROM `servers` | | 9 | 9 | 1 |
| 8 | SHOW FULL COLUMNS FROM `modules_login_logs` | | 7 | 7 | 1 |
| 9 | SHOW FULL COLUMNS FROM `course_modules_modules` | | 2 | 2 | 0 |
| 10 | 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 |
| 11 | 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 |
| 12 | 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 |
| 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 id = 94 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 id = 101 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 id = 147 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 id = 226 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 id = 97 LIMIT 1 | | 1 | 1 | 0 |
| 18 | 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 |
| 19 | 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 |
| 20 | 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 |
| 21 | 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 |
| 22 | 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 |
| 23 | 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 |
| 24 | 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 |
| 25 | 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 |
| 26 | 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 |
| 27 | 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 |
| 28 | 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 |
| 29 | 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 |
| 30 | 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 |
| 31 | 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 |
| 32 | SHOW FULL COLUMNS FROM `courses_projects` | | 2 | 2 | 1 |
| 33 | 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 |
| 34 | 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 |
| 35 | 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 |
| 36 | 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 |
| 37 | 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 |
| 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` = 290 AND `Course`.`enabled` = 1 | | 0 | 0 | 0 |
| 39 | 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 |
| 40 | 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 |
| 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` = 27 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` = 37 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC | | 15 | 15 | 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` = 6 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` = 12 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC | | 19 | 19 | 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` = 288 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` = 295 AND `CourseModulesModule`.`module_id` = `Module`.`id`) ORDER BY `Module`.sort ASC | | 19 | 19 | 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` = 162 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` = 38 AND `Course`.`enabled` = 1 | | 1 | 1 | 0 |
| 49 | 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 |
| 50 | 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 |
| 51 | 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 |
| 52 | 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 |
| 53 | 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 |
| 54 | 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 |
| 55 | 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 |
| 56 | 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 |
| 57 | 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 |
| 58 | 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 |
