Being a marketplace that enables Talents and Companies to connect directly with each other, we make it simpler to find and apply for jobs. JobCluster is designed in such a way that it helps you to search easily the best jobs, gets you to know about employers, understand their options, discover the best companies and this way you can find your best career opportunities.
JobCluster is providing an innovative way to the traditional ways for hiring to ensure a more pleasant approach to find Talent and job opportunities. We walk that extra mile to be sure that you are able to put your best foot forward. We do help you to leverage our experience for your job interviews. We also share our insights into the psychology of HR personnel. Our guidance will help you to understand the perspective of the interviewer and appropriately strategize for their interview.
We also keep you abreast of the latest industry news and opinion of the experts. The aim is to nurture your talents and keep you updated on the prevailing economic scenario and how it impacts the job market.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'admin_contact_no' LIMIT 1 | 0 | 0 | 3 | |
| 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, `Vacancy`.`industry_id` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`industries` AS `Industry` ON (`Vacancy`.`industry_id` = `Industry`.`id`) WHERE `Vacancy`.`status` = 1 GROUP BY `Industry`.`id`, `Vacancy`.`industry_id` ORDER BY `Industry`.`name` asc LIMIT 30 | 11 | 11 | 1 | |
| 6 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 1 | 1 | 1 | 0 | |
| 7 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 2 | 1 | 1 | 0 | |
| 8 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 4 | 1 | 1 | 0 | |
| 9 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 5 | 1 | 1 | 0 | |
| 10 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 17 | 1 | 1 | 0 | |
| 11 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 20 | 1 | 1 | 0 | |
| 12 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 27 | 1 | 1 | 0 | |
| 13 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 31 | 1 | 1 | 0 | |
| 14 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 33 | 1 | 1 | 0 | |
| 15 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`status` = 1 AND `Vacancy`.`industry_id` = 42 | 1 | 1 | 0 | |
| 16 | SELECT `Region`.`id`, `City`.`name`, `Country`.`name`, `Region`.`name`, `Vacancy`.`region_id` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` 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 GROUP BY `Region`.`id`, `Country`.`name`, `City`.`name`, `Vacancy`.`region_id` ORDER BY `Region`.`name` asc LIMIT 30 | 12 | 12 | 1 | |
| 17 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 4098 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 18 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 4098 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 19 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 1698 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 20 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 4105 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 21 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 1704 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 22 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 4127 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 23 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 4268 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 24 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 4268 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 25 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 4128 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 26 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 532 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 27 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 3784 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 28 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`region_id` = 1233 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 29 | SELECT `City`.`name`, `Country`.`name`, `Region`.`name`, `Vacancy`.`country_id` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` 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 GROUP BY `Country`.`id`, `Vacancy`.`country_id`, `Country`.`name`, `Region`.`name`, `City`.`name` ORDER BY `Country`.`name` asc LIMIT 30 | 12 | 12 | 1 | |
| 30 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 37 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
| 31 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 104 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 32 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 104 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 33 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 149 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 34 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 149 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 35 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 221 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 36 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 78 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 37 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 226 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 38 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 226 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 39 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 226 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 40 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 226 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 41 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`country_id` = 226 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 42 | 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`, `User`.`id`, `User`.`group_id`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`password`, `User`.`confirm`, `User`.`status`, `User`.`address`, `User`.`country_id`, `User`.`region_id`, `User`.`city_id`, `User`.`zipcode`, `User`.`phone`, `User`.`company_id`, `User`.`agency_id`, `User`.`usertype`, `User`.`typeid`, `User`.`superuser`, `User`.`parent_id`, `User`.`lastlogin`, `User`.`lastlogin2`, `User`.`notification`, `User`.`iagreed`, `User`.`ipaddress`, `User`.`created`, `User`.`modified` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `Vacancy`.`status` = 1 And (`User`.`group_id` = 2 OR `User`.`group_id`=3) GROUP BY `User`.`company_id`, `User`.`agency_id`, `Vacancy`.`id` LIMIT 30 | 30 | 30 | 3 | |
| 43 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 71 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
| 44 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 71 LIMIT 1 | 1 | 1 | 1 | |
| 45 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 71 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
| 46 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 71 LIMIT 1 | 1 | 1 | 1 | |
| 47 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 61 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 48 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 61 LIMIT 1 | 1 | 1 | 0 | |
| 49 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 71 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 50 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 71 LIMIT 1 | 1 | 1 | 0 | |
| 51 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 75 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
| 52 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 75 LIMIT 1 | 1 | 1 | 1 | |
| 53 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 77 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 54 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 77 LIMIT 1 | 1 | 1 | 0 | |
| 55 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 77 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 56 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 77 LIMIT 1 | 1 | 1 | 0 | |
| 57 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 71 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 58 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 71 LIMIT 1 | 1 | 1 | 0 | |
| 59 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
| 60 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 0 | |
| 61 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 62 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 0 | |
| 63 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 59 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 64 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 59 LIMIT 1 | 1 | 1 | 0 | |
| 65 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 81 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 66 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 81 LIMIT 1 | 1 | 1 | 0 | |
| 67 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 82 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 68 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 82 LIMIT 1 | 1 | 1 | 0 | |
| 69 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 71 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 70 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 71 LIMIT 1 | 1 | 1 | 0 | |
| 71 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 13 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
| 72 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 13 LIMIT 1 | 1 | 1 | 0 | |
| 73 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 13 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 74 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 13 LIMIT 1 | 1 | 1 | 1 | |
| 75 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 83 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 76 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 83 LIMIT 1 | 1 | 1 | 0 | |
| 77 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 83 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 78 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 83 LIMIT 1 | 1 | 1 | 1 | |
| 79 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 83 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 80 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 83 LIMIT 1 | 1 | 1 | 1 | |
| 81 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 83 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 82 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 83 LIMIT 1 | 1 | 1 | 0 | |
| 83 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 84 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 1 | |
| 85 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 86 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 0 | |
| 87 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 88 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 1 | |
| 89 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 90 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 0 | |
| 91 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 92 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 0 | |
| 93 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 94 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 0 | |
| 95 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 96 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 1 | |
| 97 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 98 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 1 | |
| 99 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 100 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 0 | |
| 101 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`id`) WHERE `User`.`company_id` = 79 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
| 102 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 79 LIMIT 1 | 1 | 1 | 1 | |
| 103 | SELECT `Industry`.`id`, `Industry`.`parent_id`, `Industry`.`name`, `Industry`.`status`, `Industry`.`lft`, `Industry`.`rght`, `Industry`.`created`, `Industry`.`modified` FROM `prod_jobcluster`.`industries` AS `Industry` WHERE `Industry`.`status` = 1 ORDER BY `Industry`.`name` ASC | 57 | 57 | 1 | |
| 104 | SELECT `Article`.`id`, `Article`.`user_id`, `Article`.`articlecategory_id`, `Article`.`featuredimagesmall`, `Article`.`featuredimage`, `Article`.`title`, `Article`.`body`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `prod_jobcluster`.`articles` AS `Article` WHERE `Article`.`status` = 1 ORDER BY `Article`.`id` Desc LIMIT 5 | 5 | 5 | 1 | |
| 105 | SELECT `Company`.`id`, `Company`.`name`, `Company`.`logo` FROM `prod_jobcluster`.`companies` AS `Company` WHERE `Company`.`status` = 1 ORDER BY rand() ASC LIMIT 12 | 12 | 12 | 0 | |
| 106 | SELECT `Vasorder`.`id`, `Vasorder`.`user_id`, `Vasorder`.`valueaddedservice_id`, `Vasorder`.`discount`, `Vasorder`.`coupon_discount`, `Vasorder`.`coupon_code`, `Vasorder`.`taxe`, `Vasorder`.`subtotal`, `Vasorder`.`grandtotal`, `Vasorder`.`first_name`, `Vasorder`.`last_name`, `Vasorder`.`card_holder_name`, `Vasorder`.`address`, `Vasorder`.`email_address`, `Vasorder`.`city_id`, `Vasorder`.`region_id`, `Vasorder`.`country_id`, `Vasorder`.`zipcode`, `Vasorder`.`phone`, `Vasorder`.`status`, `Vasorder`.`response`, `Vasorder`.`expiry_date`, `Vasorder`.`created`, `Vasorder`.`modified` FROM `prod_jobcluster`.`vasorders` AS `Vasorder` WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1754839175' ORDER BY `Vasorder`.`modified` desc | 0 | 0 | 0 | |
| 107 | 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`, `User`.`id`, `User`.`group_id`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`password`, `User`.`confirm`, `User`.`status`, `User`.`address`, `User`.`country_id`, `User`.`region_id`, `User`.`city_id`, `User`.`zipcode`, `User`.`phone`, `User`.`company_id`, `User`.`agency_id`, `User`.`usertype`, `User`.`typeid`, `User`.`superuser`, `User`.`parent_id`, `User`.`lastlogin`, `User`.`lastlogin2`, `User`.`notification`, `User`.`iagreed`, `User`.`ipaddress`, `User`.`created`, `User`.`modified`, `Industry`.`id`, `Industry`.`parent_id`, `Industry`.`name`, `Industry`.`status`, `Industry`.`lft`, `Industry`.`rght`, `Industry`.`created`, `Industry`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Vacancy`.`user_id` = `User`.`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`) left JOIN `prod_jobcluster`.`packages` AS `Package` ON (`Package`.`id` = `Vacancy`.`package_id`) WHERE `Vacancy`.`id` in (('')) and `Vacancy`.`status` = 1 ORDER BY `Package`.`amount` Desc, `Vacancy`.`created` Desc | 0 | 0 | 1 | |
| 108 | SELECT `Testimonial`.`id`, `Testimonial`.`description`, `Profile`.`profileicon`, `User`.`firstname`, `User`.`lastname` FROM `prod_jobcluster`.`testimonials` AS `Testimonial` LEFT JOIN `prod_jobcluster`.`users` AS `User` ON (`Testimonial`.`user_id` = `User`.`id`) left JOIN `prod_jobcluster`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `Testimonial`.`status` = 1 GROUP BY `Testimonial`.`id`, `Profile`.`profileicon` ORDER BY `Testimonial`.`created` desc | 0 | 0 | 1 |
