Robotics Courses
 

  • Language
  • Sort
  • Price
< Prev 12345 Last
(default) 8 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Advertiser`.`id`, `Advertiser`.`title`, `Advertiser`.`description`, `Advertiser`.`link`, `Advertiser`.`button_title`, `Advertiser`.`logo`, `Advertiser`.`logo_blob`, `Advertiser`.`status`, `Advertiser`.`created`, `Advertiser`.`modified` FROM `1337iot`.`advertisers` AS `Advertiser` WHERE `status` = 1 ORDER BY rand() ASC LIMIT 1001
2SELECT `Configuration`.`id`, `Configuration`.`heading`, `Configuration`.`default_header`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `1337iot`.`configurations` AS `Configuration` WHERE 1 = 128280
3SELECT `Cmspages`.`name`, `Cmspages`.`seourl` FROM `1337iot`.`cmspages` AS `Cmspages` WHERE `Cmspages`.`showinfooter` = '1' AND `Cmspages`.`status` = '1' ORDER BY `Cmspages`.`name` ASC550
4SELECT `Category`.`id`, `Category`.`title`, `Category`.`status`, `Category`.`sort`, `Category`.`created`, `Category`.`modified` FROM `1337iot`.`categories` AS `Category` WHERE `Category`.`id` = 44 AND `Category`.`status` = '1' LIMIT 1110
5SELECT `Course`.*, `Userdetail`.`user_id`, `Userdetail`.`first_name`, `Userdetail`.`last_name`, (select count(*) from user_learning_courses CourseLearning where `CourseLearning`.`course_id` = `Course`.`id`) AS `Course__students`, (select avg(`CourseReview`.`rating`) from course_reviews CourseReview where `CourseReview`.`course_id` = `Course`.`id`) AS `Course__avgrating`, `Course`.`id` FROM `1337iot`.`courses` AS `Course` LEFT JOIN `1337iot`.`users` AS `User` ON (`Course`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`languages` AS `Language` ON (`Course`.`language_id` = `Language`.`id`) LEFT JOIN `1337iot`.`instruction_levels` AS `InstructionLevel` ON (`Course`.`instruction_level_id` = `InstructionLevel`.`id`) LEFT JOIN `1337iot`.`userdetails` AS `Userdetail` ON (`Course`.`user_id` = `Userdetail`.`user_id`) WHERE `Course`.`visibility` = 'Public' AND `Course`.`status` = '1' AND `Course`.`category_id` like '%44%' AND `Course`.`publishstatus` = 'Publish' ORDER BY `Course`.`modified` desc LIMIT 1010102
6SELECT COUNT(*) AS `count` FROM `1337iot`.`courses` AS `Course` LEFT JOIN `1337iot`.`users` AS `User` ON (`Course`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`languages` AS `Language` ON (`Course`.`language_id` = `Language`.`id`) LEFT JOIN `1337iot`.`instruction_levels` AS `InstructionLevel` ON (`Course`.`instruction_level_id` = `InstructionLevel`.`id`) WHERE `Course`.`visibility` = 'Public' AND `Course`.`status` = '1' AND `Course`.`category_id` like '%44%' AND `Course`.`publishstatus` = 'Publish'111
7SELECT `Category`.`id`, `Category`.`title` FROM `1337iot`.`categories` AS `Category` WHERE `Category`.`status`=1 ORDER BY `Category`.`sort` ASC, `Category`.`title` ASC34340
8SELECT `Language`.`id`, `Language`.`title` FROM `1337iot`.`languages` AS `Language` WHERE `Language`.`status`=1 ORDER BY `Language`.`title` asc41410