*/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_3c90f4a76466865b53d513da4d6cfe9e' 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_bd9674d6b0812d8447ba85916a921f45' 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_309b8e9626c21c8d5d465d15d467a21b' 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 Community Development Institute Head Sta in Hyannis, MAWarning (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 Community Development Institute Head Sta in <span class='locality'>Hyannis</span>, <span class='region'>Massachusetts</span>.',
'title_for_layout' => 'Work for Community Development Institute Head Sta in Hyannis, MA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Community Development Institute Head Sta',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Hyannis',
'state' => 'MA',
'lat' => '41.65150070',
'lon' => '-70.29560089',
'street_address' => '',
'id' => '31112',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '02601',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'Massachusetts'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
),
(int) 1 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Community Development Institute Head Sta',
'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>Community Development Institute Head Sta</h1>
<p class="text-muted">Hyannis, MA</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">July 12, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46017" job_id="46017" href="/jobs/view/46017" title="Facilities/Transportation Manager- We are hiring now!"><strong>Facilities/Transportation Manager- We are hiring now!</strong></a>
</h2>
<div class="job-location">Cape Cod / Islands</div>
</div>
<div class="col-xs-12">
<p class="description">Providing safe, healthy facilities that meets all local, state and federal regulations is crucial to the operation of a Head Start/Early Head Start program. This position is responsible for overall management of the Head Start/Early Head Start facilities by ensuring that all buildings meet federal,...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">July 06, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46000" job_id="46000" href="/jobs/view/46000" title="Administrative Assistant Fiscal"><strong>Administrative Assistant Fiscal</strong></a>
</h2>
<div class="job-location">Cape Cod / Islands</div>
</div>
<div class="col-xs-12">
<p class="description">CDI HS has provided interim management services to over 200 programs in all 48 states, the District of Columbia, and Puerto Rico. CDI HS staff are recognized nationally as experts in providing Head Start and Early Head Start Training and Technical Assistance (TTA) services in the areas of administration...</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 Community Development Institute Head Sta in <span class='locality'>Hyannis</span>, <span class='region'>Massachusetts</span>.'
$title_for_layout = 'Work for Community Development Institute Head Sta in Hyannis, MA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Community Development Institute Head Sta',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Hyannis',
'state' => 'MA',
'lat' => '41.65150070',
'lon' => '-70.29560089',
'street_address' => '',
'id' => '31112',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '02601',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'Massachusetts'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46017',
'open' => '1',
'title' => 'Facilities/Transportation Manager- We are hiring now!',
'unique_name' => '',
'description' => '<p>Providing safe, healthy facilities that meets all local, state and federal regulations is crucial to the operation of a Head Start/Early Head Start program. This position is responsible for overall management of the Head Start/Early Head Start facilities by ensuring that all buildings meet federal, state and local licensing requirements pertinent to type of use and that all required licenses are up to date. In addition this position ensures that leases, contracts or agreements for all sites are current with appropriate signatures, oversees the maintenance and cleaning of buildings to ensure that they are clean, safe and in useable condition and works with outside contractors and service oriented businesses, as necessary. The position conducts regular health and safety inspections of buildings and playgrounds and chairs the Head Start Safety Committee. Transportation is one part of a large system of services provided to children and families. It plays an important role in supporting the overall goals of the program. This position is responsible for the overall operation of the Head Start/Early Head Start transportation (agency vehicle) program ensuring the safe and efficient transport of children and parents/families between program activities and on field trips (where applicable). Responsibilities include overseeing the minor maintenance of the buses and/or agency vehicle, ensuring that they are kept clean and in safe repair at all times; ensuring licenses, insurance, inspections and other required permits are maintained to comply with all local, state and federal regulations. In addition, this position oversees any vehicle leasing and/or transportation contracts; cost-effective vehicle maintenance agreements with vendors.</p>
<h4>PRIMARY RESPONSIBILITIES:</h4>
<ol>
<li>Oversees the Head Start facilities and assures they meet all requirements.</li>
<li>Develops and implements a centralized purchasing system to support facilities with such items as equipment, supplies, repairs and maintenance.</li>
<li>Develops and implements systems for building security and maintenance.</li>
<li>Establishes and facilitates a Safety Committee to support safe and healthy environments of care at the centers, kitchens and offices.</li>
<li>Oversees Child Safety sections of Performance Standards to include fire drills, first aid kits.</li>
<li></li>
<li>Writes, reviews and revises the Transportation Work Plan annually. Develops a system for administering and monitoring the work plan. Monitors compliance with the Head Start/Early Head Start Work Plan, and the Head Start Performance Standards in the applicable content areas and sub-areas assigned.</li>
<li>Establishes policies and procedures for the transportation portion of the program with parents and staff that support the effective implementation of transportation services.</li>
</ol>
<p> </p>
<h4>EDUCATION AND EXPERIENCE:</h4>
<p>A minimum of high school diploma or G.E.D. with <strong>two (2) years related experience and demonstrated knowledge of general building maintenance, facilities management, transportation systems and food services management is required. Knowledge of local health/safety regulations, ADA and OSHA requirements preferred.</strong> Previous experience with lease management and contracting preferred. Associates’ degree preferred. </p>',
'post_date' => '2019-07-12 11:56:22',
'compensation' => '',
'craigslist_city' => 'cape cod / islands',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Massachusetts'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '46000',
'open' => '1',
'title' => 'Administrative Assistant Fiscal',
'unique_name' => '',
'description' => '<p>CDI HS has provided interim management services to over 200 programs in all 48 states, the District of Columbia, and Puerto Rico. CDI HS staff are recognized nationally as experts in providing Head Start and Early Head Start Training and Technical Assistance (TTA) services in the areas of administration and management, health and safety, fiscal operations, program quality, program governance, and staff development.</p>
<p>This position performs all duties as required to ensure accurate and timely processing of accounts payable, accounts receivable, payroll and other duties relating to fiscal operations. The position is responsible for monitoring program expenses, tracking activity in program budget lines and communicating any issues or overspending concerns.</p>
<p>Minimum requirements are a high school diploma or GED with <strong>two (2) years direct experience working with purchasing, accounts payable, accounts receivable and payroll.</strong> Must possess a basic understanding of accounting systems and have at least one year of direct experience working with an accounting system general ledger and budget. AA degree or higher in a related field preferred. The individual must possess a sound working knowledge of Microsoft Excel. The position must have the ability to manage numerous tasks, possess good organizational skills, communicate effectively with co-workers and the public, and work collaboratively in a team environment.</p>
<p>Bilingual preferred (English/Spanish or English and other languages present in the local area).</p>
<p> </p>
<p><strong>Please apply to our company website:</strong></p>
<p><strong> <a href="http://www.cdiheadstart.org/programs/jobpostings/jobs.aspx?prgid=325&prgname=Cape%20Cod,%20MA">http://www.cdiheadstart.org/programs/jobpostings/jobs.aspx?prgid=325&prgname=Cape%20Cod,%20MA</a></strong></p>
<p><strong> </strong></p>
<p><strong>$16.00 Hourly HS/GED | $17.00 hourly AA</strong></p>
<p>CDI Head Start is an Equal Opportunity Employer</p>',
'post_date' => '2019-07-07 05:02:29',
'compensation' => '',
'craigslist_city' => 'cape cod / islands',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Massachusetts'
)
)
)
$display_company_title = 'Jobs at Community Development Institute Head Sta'
$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>Community Development Institute Head Sta</h1>
<p class="text-muted">Hyannis, MA</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">July 12, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46017" job_id="46017" href="/jobs/view/46017" title="Facilities/Transportation Manager- We are hiring now!"><strong>Facilities/Transportation Manager- We are hiring now!</strong></a>
</h2>
<div class="job-location">Cape Cod / Islands</div>
</div>
<div class="col-xs-12">
<p class="description">Providing safe, healthy facilities that meets all local, state and federal regulations is crucial to the operation of a Head Start/Early Head Start program. This position is responsible for overall management of the Head Start/Early Head Start facilities by ensuring that all buildings meet federal,...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">July 06, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46000" job_id="46000" href="/jobs/view/46000" title="Administrative Assistant Fiscal"><strong>Administrative Assistant Fiscal</strong></a>
</h2>
<div class="job-location">Cape Cod / Islands</div>
</div>
<div class="col-xs-12">
<p class="description">CDI HS has provided interim management services to over 200 programs in all 48 states, the District of Columbia, and Puerto Rico. CDI HS staff are recognized nationally as experts in providing Head Start and Early Head Start Training and Technical Assistance (TTA) services in the areas of administration...</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
Providing safe, healthy facilities that meets all local, state and federal regulations is crucial to the operation of a Head Start/Early Head Start program. This position is responsible for overall management of the Head Start/Early Head Start facilities by ensuring that all buildings meet federal,...
CDI HS has provided interim management services to over 200 programs in all 48 states, the District of Columbia, and Puerto Rico. CDI HS staff are recognized nationally as experts in providing Head Start and Early Head Start Training and Technical Assistance (TTA) services in the areas of administration...
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` = 31112 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` = 31112 AND `EmployersJob`.`open` = 1 AND `EmployersJob`.`anonymous_post` = 0 GROUP BY `EmployersJob`.`id` ORDER BY `EmployersJob`.`post_date` DESC
2
2
1
3
SELECT `EmployerMobileImage`.`file_name` FROM `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` WHERE `EmployerMobileImage`.`employer_id` = 31112 LIMIT 1