Job List
No data to load.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Employer`.`employer_id`, `Employer`.`emp_title` FROM `dev2_global_new`.`sjs_employer` AS `Employer` WHERE 1 = 1 ORDER BY `Employer`.`emp_title` ASC | 9 | 9 | 0 | |
| 2 | SELECT `JobType`.`job_type_id`, `JobType`.`job_type_title` FROM `dev2_global_new`.`sjs_job_types` AS `JobType` WHERE 1 = 1 ORDER BY `JobType`.`job_type_title` ASC | 3 | 3 | 1 | |
| 3 | SELECT `Location`.`loc_id`, `Location`.`loc_title` FROM `dev2_global_new`.`sjs_locations` AS `Location` WHERE 1 = 1 ORDER BY `Location`.`loc_title` ASC | 4 | 4 | 0 | |
| 4 | SELECT `Technical`.`tech_id`, `Technical`.`tech_title` FROM `dev2_global_new`.`sjs_technicals` AS `Technical` WHERE `tech_parent_id` != 0 ORDER BY `Technical`.`tech_title` ASC | 159 | 159 | 1 | |
| 5 | SELECT `Language`.`lang_id`, `Language`.`lang_title` FROM `dev2_global_new`.`sjs_languages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`lang_title` ASC | 3 | 3 | 0 | |
| 6 | SELECT `SeekerExpectedSalaryRange`.`salary_id`, `SeekerExpectedSalaryRange`.`salary_amount` FROM `dev2_global_new`.`sjs_seeker_expected_salary_ranges` AS `SeekerExpectedSalaryRange` WHERE `SeekerExpectedSalaryRange`.`salary_status` = 'Active' ORDER BY `SeekerExpectedSalaryRange`.`salary_amount` ASC | 6 | 6 | 0 | |
| 7 | SELECT `Content`.`cont_alias`, `Content`.`cont_detail` FROM `dev2_global_new`.`sjs_contents` AS `Content` WHERE `Content`.`cont_status` = 'Active' | 12 | 12 | 1 | |
| 8 | SELECT `EmployerJob`.`emp_job_id`, `EmployerJob`.`job_title`, `EmployerJob`.`no_of_vacancy`, `Location`.`loc_title`, `JobType`.`job_type_title`, `EmployerJob`.`job_detail`, `EmployerJob`.`min_experience`, `EmployerJob`.`max_experience`, `EmployerJob`.`job_dead_line`, `EmployerJob`.`job_publish_date`, `EmployerJob`.`job_is_featured`, `Employer`.`emp_title`, `SeekerExpectedSalaryRange`.`salary_amount` FROM `dev2_global_new`.`sjs_employer_jobs` AS `EmployerJob` LEFT JOIN `dev2_global_new`.`sjs_employer` AS `Employer` ON (`EmployerJob`.`employer_id` = `Employer`.`employer_id`) LEFT JOIN `dev2_global_new`.`sjs_job_types` AS `JobType` ON (`EmployerJob`.`job_type` = `JobType`.`job_type_id`) LEFT JOIN `dev2_global_new`.`sjs_locations` AS `Location` ON (`EmployerJob`.`job_location` = `Location`.`loc_id`) LEFT JOIN `dev2_global_new`.`sjs_seeker_expected_salary_ranges` AS `SeekerExpectedSalaryRange` ON (`EmployerJob`.`job_salary` = `SeekerExpectedSalaryRange`.`salary_id`) WHERE ((`EmployerJob`.`job_publish_date` <= '2026-06-05') AND (`EmployerJob`.`job_dead_line` >= '2026-06-05') AND (`EmployerJob`.`display_status` = 'Active') AND (`EmployerJob`.`job_is_archive` = 'No')) GROUP BY `EmployerJob`.`emp_job_id` ORDER BY `EmployerJob`.`job_publish_date` DESC, `EmployerJob`.`created` DESC LIMIT 10 | 0 | 0 | 1 |