*/public function read($key) {return $this->_Memcache->get($key);
$key = 'app__employer'
MemcachePool::get() - [internal], line ??
MemcacheEngine::read() - CORE/Cake/Cache/Engine/MemcacheEngine.php, line 152
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
AppModel::find() - APP/Model/AppModel.php, line 53
Employer::getEmployerInfo() - APP/Model/Employer.php, line 83
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 44
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employer_first_ebe9e819f995e7f92f92fe356a89130a' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 63
Employer::getEmployerInfo() - APP/Model/Employer.php, line 83
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 44
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employer' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 64
Employer::getEmployerInfo() - APP/Model/Employer.php, line 83
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 44
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employersjob_all_1bc3add1eb9887e1e3dc0b4e0d616f21' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 63
EmployersJob::getOpenJobsForEmployer() - APP/Model/EmployersJob.php, line 207
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 53
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employersjob' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 64
EmployersJob::getOpenJobsForEmployer() - APP/Model/EmployersJob.php, line 207
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 53
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employermobileimage_first_6c477526ab641df9422d164524b8de12' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 63
DboSource::query() - CORE/Cake/Model/Datasource/DboSource.php, line 599
Model::__call() - CORE/Cake/Model/Model.php, line 827
EmployerMobileImage::findByEmployerId() - APP/Model/EmployerMobileImage.php, line 7
EmployerMobileImage::getMobileImage() - APP/Model/EmployerMobileImage.php, line 7
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 60
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employermobileimage' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 64
DboSource::query() - CORE/Cake/Model/Datasource/DboSource.php, line 599
Model::__call() - CORE/Cake/Model/Model.php, line 827
EmployerMobileImage::findByEmployerId() - APP/Model/EmployerMobileImage.php, line 7
EmployerMobileImage::getMobileImage() - APP/Model/EmployerMobileImage.php, line 7
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 60
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Work for A.Manberg Recruiter Group 96.0 in Ithaca, NYWarning (2): filemtime(): stat failed for /var/app/current/app/View/Layouts/../../webroot/css/proven.responsive.min.css [APP/View/Layouts/responsive.ctp, line 69]
$viewFile = '/var/app/current/app/View/Layouts/responsive.ctp'
$dataForView = array(
'metatag_description' => 'Find work and jobs at A.Manberg Recruiter Group 96.0 in <span class='locality'>Ithaca</span>, <span class='region'>New York</span>.',
'title_for_layout' => 'Work for A.Manberg Recruiter Group 96.0 in Ithaca, NY',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'A.Manberg Recruiter Group 96.0',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Ithaca',
'state' => 'NY',
'lat' => '42.44559860',
'lon' => '-76.49639893',
'street_address' => '',
'id' => '30871',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '14850',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New York'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at A.Manberg Recruiter Group 96.0',
'employers_own_page' => false,
'mobile_image' => '',
'isMobile' => false,
'isWorker' => false,
'isSales' => false,
'isEducator' => false,
'adminLoggedIn' => false,
'isEmployer' => false,
'loggedIn' => false,
'isFacebookAppUser' => false,
'campaign' => 'NONE',
'content_for_layout' => '
<div id="proven-public-page">
<div class="container">
<div class="row">
<div class="col-md-10 col-md-offset-1 col-sm-12">
<div class="hidden-xs" style="margin-bottom:20px;">
<div class="back-button-panel">
<a class="blue-link" style="" href="/jobs/search" title="View All Jobs">← View All Jobs</a>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<div class="job-post-details">
<div class="row">
<div class="hidden-xs col-sm-2">
<div class="company-logo">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>A.Manberg Recruiter Group 96.0</h1>
<p class="text-muted">Ithaca, NY</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
</div>
</div>
<hr />
<div class="open-positions">
<h3>Open Positions</h3>
<div class="job-listing ui-box-shadow">
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">May 05, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45661" job_id="45661" href="/jobs/view/45661" title="WEEKEND) MAINTENANCE MECHANIC - We are hiring now!"><strong>WEEKEND) MAINTENANCE MECHANIC - We are hiring now!</strong></a>
</h2>
<div class="job-location">Ithaca</div>
</div>
<div class="col-xs-12">
<p class="description">WEEKEND) MAINTENANCE MECHANIC This full time position is located in Lansing , NY; however please expect receiving calls from a 952 area code in case you are considered. Relocation assistance is not provided. We are looking for a passionate Maintenance Mechanic who wants to help the world thrive!...</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<p>
<strong>Search, browse and apply to jobs on iOS and Android</strong>
</p>
<div>
<a href="/candidates/app" target="_blank" title="Download the iPhone App">
<img src="/css/images/App_Store_available.png" width="112" />
</a>
<a href="/candidates/app/google" target="_blank" title="Download the Android App">
<img src="/css/images/google_play_badge.png" width="112" />
</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>',
'scripts_for_layout' => ''
)
$metatag_description = 'Find work and jobs at A.Manberg Recruiter Group 96.0 in <span class='locality'>Ithaca</span>, <span class='region'>New York</span>.'
$title_for_layout = 'Work for A.Manberg Recruiter Group 96.0 in Ithaca, NY'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'A.Manberg Recruiter Group 96.0',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Ithaca',
'state' => 'NY',
'lat' => '42.44559860',
'lon' => '-76.49639893',
'street_address' => '',
'id' => '30871',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '14850',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New York'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '45661',
'open' => '1',
'title' => 'WEEKEND) MAINTENANCE MECHANIC - We are hiring now!',
'unique_name' => '',
'description' => '<p><strong>WEEKEND) MAINTENANCE MECHANIC</strong></p>
<p><strong>This full time position is located in Lansing , NY; however please expect receiving calls from a 952 area code in case you are considered. Relocation assistance is not provided. </strong></p>
<p> </p>
<p><strong>We are looking for a passionate Maintenance Mechanic who wants to help the world thrive!</strong></p>
<p><strong>Our client has a Maintenance Mechanic job opportunity at its underground Salt Mining and surface operations. </strong></p>
<p> </p>
<p><strong>This position offers a competitive benefit package including hourly pay. Successful candidate must be able to work all shifts. Applicants should achieve a rating of at least of 70% or above on the entry level mechanic evaluation.</strong></p>
<p> </p>
<p><strong>Primary duties for the position will include but not be limited to the following tasks: </strong></p>
<ul>
<li>Safe installation, assembly, maintenance, testing, evaluation, and repair of stationary system, pumps, septic tanks, mobile equipment and vehicles such as loaders, roof scalers, drills, feeder breaker, conveyers, crushers, screeners, load out systems and utility vehicles. </li>
<li>Material handling, housekeeping, parts procurement and assignments as directed by a supervisor. </li>
<li>Must be able to work on surface or underground. </li>
<li>Possession of journeyman certification as an electrician is an plus.</li>
</ul>
<p> </p>
<p><strong>Qualifications</strong></p>
<p><strong>Required:</strong></p>
<ul>
<li>Right to work in the U.S. that is not based solely on possession of a student visa or a visa sponsored by a third-party employer.</li>
<li>requires employees be a minimum of 18 years old to work in a production facility.</li>
<li>Must be able to read/write English.</li>
<li>Basic computer skills</li>
<li>Must be able to perform physical job duties including bending/stooping, climbing ladders, open/close valves, shoveling, pounding with hammer and work in confined spaces.</li>
<li>Ability to lift a minimum of 70 pounds.</li>
<li>Ability to work in elevated areas.</li>
<li>Must be able to operate machinery</li>
<li>Must be able to operate heavy equipment</li>
<li>Ability to work holidays, nights, weekends or different shifts.</li>
<li>Ability to interpret and understand reports, safety/operating procedures & other policies and procedures and utilize equipment checklist. </li>
<li>Must have basic skills in the repair and troubleshooting of the following areas: diesel systems, 12 & 24-volt electrical systems</li>
<li>Must be able to perform maintenance trades including mechanical maintenance and hydraulic and pneumatic.</li>
<li>At least 2 years of experience in mechanic maintenance roles. </li>
</ul>
<p> </p>
<p><strong>Preferred:</strong></p>
<ul>
<li>Must exhibit skills in cutting, welding and fabrication</li>
<li>High School diploma or Equivalent </li>
<li>Able to work under special work conditions, such as extreme heat or cold.</li>
<li>Ability to perform lubrication, servicing and minor maintenance for equipment related to the classification</li>
<li>Able to work overtime </li>
<li>Successful completion of accredited trade school or 3 years practical experience as an industrial mechanic.</li>
<li>Able to perform maintenance trades including welding, pipe fitting, and fabrication, rigging systems, gearbox and bearing, maintenance, lubrication, pumps and piping systems.</li>
<li>Previous experience with MRO (Maintenance Repair Ops) and/or MRP (Material Requirement Planning).</li>
</ul>
<p><strong>SKILLS AND CERTIFICATIONS</strong> [note: bold skills and certification are required]</p>
<p><strong>At least 2 years of experience in mechanic maintenance roles.</strong> </p>
<p><strong>Must be able to perform maintenance trades including mechanical maintenance and hydraulic and pneuma</strong> </p>
<p><strong>Must have basic skills in the repair and troubleshooting of the following areas: diesel systems, 12</strong> </p>
<p><strong>Ability to interpret and understand reports, safety/operating procedures & other policies and proced</strong> </p>
<p>Security Clearance Required: No</p>
<p>Visa Candidate Considered: No</p>
<p><strong>COMPENSATION</strong></p>
<p><strong>Base Salary </strong></p>
<p>Full-time Benefits - Full </p>
<p>Relocation Assistance Available - No </p>
<p>Commission Compensation - No </p>
<p>Bonus Eligible - No </p>
<p>Overtime Eligible - No </p>
<p>Interview Travel Reimbursed - No </p>
<p><strong>CANDIDATE DETAILS</strong></p>
<p><strong>2+ to 5 years experience</strong></p>
<p><strong>Seniority Level - Mid-Senior</strong></p>
<p><strong>Management Experience Required - No</strong></p>
<p><strong>Minimum Education - High School Diploma or Equivalent</strong></p>
<p><strong>Willingness to Travel - Never</strong></p>
<p><strong>SCREENING QUESTIONS</strong></p>
<p><strong>Are you 18 years of age or older?</strong></p>
<p><strong>Are you able and willing to perform with or without reasonable accommodation job duties like: bending/stooping, climbing ladders, open/close valves, shoveling, Pounding with hammer and work in confined spaces?</strong></p>
<p><strong>Are you able to lift 70 of pounds with or without reasonable accommodation?</strong></p>
<p><strong>Are you able to work in extreme heat or cold with or without reasonable accommodation?</strong></p>
<p><strong>Are you able to work in elevated areas with or without reasonable accommodation?</strong></p>
<p><strong>Are you able to operate machinery with or without reasonable accommodation?</strong></p>
<p><strong>Are you able to operate heavy equipment with or without reasonable accommodation?</strong></p>
<p><strong>Are you able to read and write English?</strong></p>
<p><strong>Do you have a High School diploma or GED equivalent?</strong></p>
<p><strong>Do you have experience using a computer?</strong></p>
<p><strong>Do you have experience with standard methods, principles, practices, tools and equipment of maintenance trades like: Electrical, Welding, pipe fitting, and fabrication, Rigging systems,Gearbox and bearing maintenance and Lubrication?</strong></p>
<p><strong>Do you have experience with standard methods, principles, practices, tools and equipment of maintenance trades like: Pumps and piping systems, Mechanical maintenance, Hydraulic and pneumatic systems?</strong></p>
<p><strong>Do you have experience in the machinist trade?</strong></p>
<p><strong>Do you have experience with MRO (Maintenance Repair Ops) and/or MRP (Material Requirement Planning)?</strong></p>
<p><strong>Are you able to nterpret and understand reports, safety/operating procedures & other policies and procedures and utilize equipment checklist?</strong></p>
<p><strong>Do you have experiene in the repair and troubleshooting of diesel systems and 12 & 24-volt electrical systems?</strong></p>
<p><strong>Do you have 2 years of experience in mechanic maintenance roles?</strong></p>
<p><strong>Are you able/willing to work overtime?</strong></p>
<p><strong>Are you able and/or willing to work rotating shifts including nights, weekends, and holidays?</strong></p>
<p><strong>IDEAL CANDIDATE</strong></p>
<p><strong>Strong Maintenance experience.</strong></p>',
'post_date' => '2019-05-05 19:15:04',
'compensation' => '',
'craigslist_city' => 'ithaca',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New York'
)
)
)
$display_company_title = 'Jobs at A.Manberg Recruiter Group 96.0'
$employers_own_page = false
$mobile_image = ''
$isMobile = false
$isWorker = false
$isSales = false
$isEducator = false
$adminLoggedIn = false
$isEmployer = false
$loggedIn = false
$isFacebookAppUser = false
$campaign = 'NONE'
$content_for_layout = '
<div id="proven-public-page">
<div class="container">
<div class="row">
<div class="col-md-10 col-md-offset-1 col-sm-12">
<div class="hidden-xs" style="margin-bottom:20px;">
<div class="back-button-panel">
<a class="blue-link" style="" href="/jobs/search" title="View All Jobs">← View All Jobs</a>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<div class="job-post-details">
<div class="row">
<div class="hidden-xs col-sm-2">
<div class="company-logo">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>A.Manberg Recruiter Group 96.0</h1>
<p class="text-muted">Ithaca, NY</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
</div>
</div>
<hr />
<div class="open-positions">
<h3>Open Positions</h3>
<div class="job-listing ui-box-shadow">
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">May 05, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45661" job_id="45661" href="/jobs/view/45661" title="WEEKEND) MAINTENANCE MECHANIC - We are hiring now!"><strong>WEEKEND) MAINTENANCE MECHANIC - We are hiring now!</strong></a>
</h2>
<div class="job-location">Ithaca</div>
</div>
<div class="col-xs-12">
<p class="description">WEEKEND) MAINTENANCE MECHANIC This full time position is located in Lansing , NY; however please expect receiving calls from a 952 area code in case you are considered. Relocation assistance is not provided. We are looking for a passionate Maintenance Mechanic who wants to help the world thrive!...</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<p>
<strong>Search, browse and apply to jobs on iOS and Android</strong>
</p>
<div>
<a href="/candidates/app" target="_blank" title="Download the iPhone App">
<img src="/css/images/App_Store_available.png" width="112" />
</a>
<a href="/candidates/app/google" target="_blank" title="Download the Android App">
<img src="/css/images/google_play_badge.png" width="112" />
</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>'
$scripts_for_layout = ''
$no_title_bar = false
$no_bottom_bar = false
$no_index = false
filemtime - [internal], line ??
include - APP/View/Layouts/responsive.ctp, line 69
View::_evaluate() - CORE/Cake/View/View.php, line 961
View::_render() - CORE/Cake/View/View.php, line 923
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - CORE/Cake/Controller/Controller.php, line 960
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 769
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
WEEKEND) MAINTENANCE MECHANIC This full time position is located in Lansing , NY; however please expect receiving calls from a 952 area code in case you are considered. Relocation assistance is not provided. We are looking for a passionate Maintenance Mechanic who wants to help the world thrive!...
Search, browse and apply to jobs on iOS and Android
(default) 3 queries took 2 ms
Nr
Query
Error
Affected
Num. rows
Took (ms)
1
SELECT `Employer`.`company_name`, `Employer`.`founded_date`, `Employer`.`city`, `Employer`.`state`, `Employer`.`lat`, `Employer`.`lon`, `Employer`.`street_address`, `Employer`.`id`, `Employer`.`about_us`, `Employer`.`company_benefits`, `Employer`.`other_information`, `Employer`.`cultural_description`, `Employer`.`company_expectations`, `Employer`.`recruitment_video`, `Employer`.`looking_for`, `State`.`name`, `Employer`.`zipcode`, `Employer`.`yelp_page`, `Employer`.`facebook_page`, `Employer`.`website`, `Employer`.`company_logo`, `Employer`.`twitter_name`, `User`.`email_validated`, `User`.`active` FROM `proven_production`.`employers` AS `Employer` left JOIN `proven_production`.`states` AS `State` ON (`Employer`.`state`=`State`.`abbreviation`) LEFT JOIN `proven_production`.`users` AS `User` ON (`Employer`.`user_id` = `User`.`id`) WHERE `Employer`.`id` = 30871 AND `Employer`.`active` = 1 LIMIT 1
1
1
1
2
SELECT `EmployersJob`.`id`, `EmployersJob`.`open`, `EmployersJob`.`title`, `EmployersJob`.`unique_name`, `EmployersJob`.`description`, `EmployersJob`.`post_date`, `EmployersJob`.`compensation`, `EmployersJob`.`craigslist_city`, `EmployersJob`.`craigslist_sub_city`, `EmployersJob`.`craigslist_sub_sub_city`, `EmployersJob`.`craigslist_state` FROM `proven_production`.`employers_jobs` AS `EmployersJob` LEFT JOIN `proven_production`.`ut_zipcodes` AS `UtZipcode` ON (`EmployersJob`.`zip` = `UtZipcode`.`zipcode`) WHERE `EmployersJob`.`employer_id` = 30871 AND `EmployersJob`.`open` = 1 AND `EmployersJob`.`anonymous_post` = 0 GROUP BY `EmployersJob`.`id` ORDER BY `EmployersJob`.`post_date` DESC
1
1
1
3
SELECT `EmployerMobileImage`.`file_name` FROM `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` WHERE `EmployerMobileImage`.`employer_id` = 30871 LIMIT 1