1 | SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'admin_contact_no' LIMIT 1 | | 0 | 0 | 4 |
2 | SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'ContactEmail' LIMIT 1 | | 1 | 1 | 0 |
3 | SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'SiteDomain' LIMIT 1 | | 1 | 1 | 0 |
4 | SELECT `Faqcategory`.`id`, `Faqcategory`.`name`, `Faqcategory`.`description`, `Faqcategory`.`status`, `Faqcategory`.`created`, `Faqcategory`.`modified` FROM `prod_jobcluster`.`faqcategories` AS `Faqcategory` WHERE `status` = 1 LIMIT 1 | | 1 | 1 | 0 |
5 | SELECT `Industry`.`id`, `Industry`.`name` FROM `prod_jobcluster`.`industries` AS `Industry` WHERE `Industry`.`name` = 'architecture' AND `Industry`.`status` = 1 LIMIT 1 | | 1 | 1 | 0 |
6 | SELECT `Vacancy`.`id`, `Vacancy`.`user_id`, `Vacancy`.`package_id`, `Vacancy`.`jobtitle`, `Vacancy`.`industry_id`, `Vacancy`.`address`, `Vacancy`.`country_id`, `Vacancy`.`region_id`, `Vacancy`.`city_id`, `Vacancy`.`lat`, `Vacancy`.`lon`, `Vacancy`.`qualification_id`, `Vacancy`.`specialization_id`, `Vacancy`.`currancy`, `Vacancy`.`minimumsalary`, `Vacancy`.`maximumsalary`, `Vacancy`.`duration`, `Vacancy`.`hidesal`, `Vacancy`.`experienceyear`, `Vacancy`.`employmenttype`, `Vacancy`.`keyskills`, `Vacancy`.`responsibilities`, `Vacancy`.`description`, `Vacancy`.`candidateindustry_id`, `Vacancy`.`candidatecountry_id`, `Vacancy`.`candidateregion_id`, `Vacancy`.`candidatecity_id`, `Vacancy`.`candidatecurrancy`, `Vacancy`.`currentannualminsal`, `Vacancy`.`currentannualmaxsal`, `Vacancy`.`candidateduration`, `Vacancy`.`teamsize`, `Vacancy`.`includecompany`, `Vacancy`.`excludecompany`, `Vacancy`.`referenceid`, `Vacancy`.`status`, `Vacancy`.`keywordgenerated`, `Vacancy`.`isdisclaimer`, `Vacancy`.`ipaddress`, `Vacancy`.`created`, `Vacancy`.`modified` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`industry_id` = (5) | | 1 | 1 | 1 |
7 | SELECT `Profile`.`id`, `Profile`.`user_id`, `Profile`.`fax`, `Profile`.`messangertype`, `Profile`.`messangerid`, `Profile`.`profileicon`, `Profile`.`dateofbirth`, `Profile`.`gender`, `Profile`.`maritalstatus`, `Profile`.`nationality`, `Profile`.`keyskills`, `Profile`.`qualification_id`, `Profile`.`otherqualification`, `Profile`.`experienceyear`, `Profile`.`minimumsalary`, `Profile`.`duration`, `Profile`.`currancy`, `Profile`.`preferredlocation`, `Profile`.`designation_id`, `Profile`.`otherdesignation`, `Profile`.`industry_id`, `Profile`.`otherindustry`, `Profile`.`specialization_id`, `Profile`.`otherspecialization`, `Profile`.`resumeheadline`, `Profile`.`language1`, `Profile`.`proficiencylevel1`, `Profile`.`language2`, `Profile`.`proficiencylevel2`, `Profile`.`language3`, `Profile`.`proficiencylevel3`, `Profile`.`jobtype`, `Profile`.`employmenttype`, `Profile`.`physicalchallanged`, `Profile`.`othercountries`, `Profile`.`profilesummary`, `Profile`.`willrelocate`, `Profile`.`emailnotifications`, `Profile`.`created`, `Profile`.`modified` FROM `prod_jobcluster`.`profiles` AS `Profile` WHERE `Profile`.`industry_id` = (5) | | 0 | 0 | 1 |
8 | SELECT `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Zone`.`id`, `Zone`.`name`, `Zone`.`created`, `Zone`.`modified` FROM `prod_jobcluster`.`countries` AS `Country` LEFT JOIN `prod_jobcluster`.`zones` AS `Zone` ON (`Country`.`zone_id` = `Zone`.`id`) WHERE 1 = 1 ORDER BY `Country`.`name` ASC | | 225 | 225 | 1 |
9 | SELECT `Country`.`id`, `Country`.`name` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Vacancy`.`country_id` = `Country`.`id`) WHERE `Vacancy`.`industry_id` = 5 AND `Vacancy`.`status` = 1 GROUP BY `Country`.`id` ORDER BY `Country`.`name` ASC | | 1 | 1 | 1 |
10 | SELECT Industry.id,Industry.name, `Vacancy`.`industry_id` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) LEFT JOIN `prod_jobcluster`.`packages` AS `Package` ON (`Vacancy`.`package_id` = `Package`.`id`) LEFT JOIN `prod_jobcluster`.`qualifications` AS `Qualification` ON (`Vacancy`.`qualification_id` = `Qualification`.`id`) LEFT JOIN `prod_jobcluster`.`industries` AS `Industry` ON (`Vacancy`.`industry_id` = `Industry`.`id`) LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Vacancy`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Vacancy`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Vacancy`.`city_id` = `City`.`id`) WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` != 5 GROUP BY `Industry`.`id`, `Vacancy`.`industry_id` ORDER BY `Industry`.`name` asc LIMIT 30 | | 10 | 10 | 1 |
11 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 1 | | 1 | 1 | 0 |
12 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 2 | | 1 | 1 | 0 |
13 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 4 | | 1 | 1 | 0 |
14 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 17 | | 1 | 1 | 0 |
15 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 20 | | 1 | 1 | 0 |
16 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 27 | | 1 | 1 | 0 |
17 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 31 | | 1 | 1 | 0 |
18 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 33 | | 1 | 1 | 0 |
19 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 42 | | 1 | 1 | 0 |