*/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_2cedbcfaabc806a072488d00110beb17' 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_eeadc3f62af6e3601b196e74c3ac8b0b' 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_27cfc46730c234a9d9672952783b5488' 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 Alamo Drafthouse Cinema - Yonkers in Yonkers, 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 Alamo Drafthouse Cinema - Yonkers in <span class='locality'>Yonkers</span>, <span class='region'>New York</span>.',
'title_for_layout' => 'Work for Alamo Drafthouse Cinema - Yonkers in Yonkers, NY',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Alamo Drafthouse Cinema - Yonkers',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Yonkers',
'state' => 'NY',
'lat' => '40.96580124',
'lon' => '-73.84590149',
'street_address' => '2548 Central Park Avenue',
'id' => '14026',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '10710',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w15603528961693137202_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'New York'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Alamo Drafthouse Cinema - Yonkers',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w15603529211447759701_small.jpg',
'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">
<img title="Alamo Drafthouse Cinema - Yonkers" alt="Alamo Drafthouse Cinema - Yonkers" src="https://d2qez73695kjfi.cloudfront.net/w15603528961693137202_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Alamo Drafthouse Cinema - Yonkers</h1>
<p class="text-muted">Yonkers, 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="company-image">
<img title="Alamo Drafthouse Cinema - Yonkers" alt="Alamo Drafthouse Cinema - Yonkers" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15603529211447759701_small.jpg" class="img-responsive center-block" />
</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">August 05, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46151" job_id="46151" href="/jobs/view/46151" title="Shift Supervisor at Alamo Drafthouse (FOH)"><strong>Shift Supervisor at Alamo Drafthouse (FOH)</strong></a>
</h2>
<div class="job-location">Westchester</div>
</div>
<div class="col-xs-12">
<p class="description">The Shift Supervisor position is an integral part of the management team and is responsible for running daily operations as well as providing leadership to our staff members. Key responsibilities include managing the staff by upholding standards of presentation, food quality, excellent guest service...</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 Alamo Drafthouse Cinema - Yonkers in <span class='locality'>Yonkers</span>, <span class='region'>New York</span>.'
$title_for_layout = 'Work for Alamo Drafthouse Cinema - Yonkers in Yonkers, NY'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Alamo Drafthouse Cinema - Yonkers',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Yonkers',
'state' => 'NY',
'lat' => '40.96580124',
'lon' => '-73.84590149',
'street_address' => '2548 Central Park Avenue',
'id' => '14026',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '10710',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w15603528961693137202_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'New York'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46151',
'open' => '1',
'title' => 'Shift Supervisor at Alamo Drafthouse (FOH)',
'unique_name' => '',
'description' => '<p>The Shift Supervisor position is an integral part of the management team and is responsible for running daily operations as well as providing leadership to our staff members. Key responsibilities include managing the staff by upholding standards of presentation, food quality, excellent guest service and maintaining a positive “can do” attitude. The Shift Supervisor is a brand representative for the Alamo Drafthouse Cinemas and is responsible for delivering on the company goals, visions and mission statement at all times.<br /><br /><strong>REPORTS TO:</strong> Venue Managers<br /><br /><strong>LOCATION:</strong> <a href="http://maps.google.com/maps?q=2548+Central+Park+Avenue%2C+Yonkers%2C+NY%2C+10710%2C+US">2548 Central Park Avenue Yonkers, NY 10710</a></p>
<p><strong>SALARY / GRADE LEVEL:</strong> Hourly / Non-Exempt<br /><br /><strong>DUTIES / RESPONSIBILITIES:</strong></p>
<ul>
<li>Ensures that ALL GUESTS have an AWESOME EXPERIENCE, and are EXCITED to come back.</li>
<li class="ms-hover">Manages operations of the venue, which includes daily decision-making, flexibility, staff support, guest interaction, scheduling, and effective planning while upholding standards, product quality, and cleanliness.</li>
<li class="ms-hover">Actively listens to server/guest interaction and effectively directs and develops the staff</li>
<li class="ms-hover">Scheduling: Maintains staffing at standard labor ratios and ensures the venue is properly staffed to par, at all times by utilizing labor management tools.</li>
<li class="ms-hover">Posts and communicates schedules in a timely manner.</li>
<li class="ms-hover">Actively engages with the guests during every shift.</li>
<li class="ms-hover">Expects and leads strong communication with all areas of the venue (management, trainers, tickets, runners, servers, bar, kitchen, etc.) including daily shift meetings with all staff members.</li>
<li class="ms-hover">Maintains an upbeat presence on the floor during operations and away from the office.</li>
<li class="ms-hover">Maintains the expected ambiance (lighting/sound/temperature levels/presentation) and coaches all staff members to hold that standard at all times.</li>
<li class="ms-hover">Promotes a distraction-free guest experience by enforcing our no-talk/texting policy.</li>
<li class="ms-hover">Conducts staff and keeps staff informed on new developments and upcoming events.</li>
<li class="ms-hover">Ensures all staff members adhere to the Company’s uniform standards.</li>
<li class="ms-hover">Accurately performs staff and department checkouts, following company expectations of proper/safe money handling and cleanliness standards.</li>
<li class="ms-hover">Ensures all payments are accounted for (cash and credit vouchers), all comps are verified and staff has been properly developed on tip declaration.</li>
<li class="ms-hover">Maintains proper cash handling procedures are followed, including preparing and balancing cash drawers, completing End of Day Reports and cash drops.</li>
<li class="ms-hover">Effectively opens and closes the venue ensuring all departments have completed required duties and incoming team is set up for success.</li>
</ul>
<p><strong>QUALIFICATIONS:</strong></p>
<ul>
<li class="ms-hover">High School Diploma/GED or equivalent combination of education and experience.</li>
<li class="ms-hover">One (1) year minimum of high volume venue experience (prior Alamo Drafthouse experience will be considered in lieu of venue experience and previous theater management is beneficial).</li>
<li class="ms-hover">ServSafe Certification, local Health Cards (as required) and TABC Certification are required.</li>
<li class="ms-hover">Must be positive, fun, coachable and open-minded.</li>
<li class="ms-hover">Strong verbal and written communication skills.</li>
<li class="ms-hover">Excellent guest relation skills with focus on meeting high guest satisfaction expectations.</li>
<li class="ms-hover">Resourceful problem-solving skills.</li>
<li class="ms-hover">Consistently maintain high-performance standards.</li>
<li class="ms-hover">Expected workweek of 30-45 hours minimum; higher volume seasons and heavier work weeks are expected.</li>
<li class="ms-hover">Basic computer knowledge (Microsoft Office) and office skills required.</li>
</ul>
<p><strong>WORKING CONDITIONS: </strong>Work is typically performed in the venue. The noise level in the work environment is usually moderate. The work involves a majority of standing, bending, stooping, twisting, climbing and some lifting up to 50 lbs.<br /><br /><strong>HAZARDS: </strong>Only those present in a normal restaurant setting; no known significant hazards.</p>
<div id="descriptionReview">
<p> </p>
<p>OUR MISSION</p>
<p>Ensure every guest has an Awesome Experience and is excited to come back.</p>
<p> </p>
<p>OUR CORE VALUES</p>
<p>Do the Right Thing</p>
<p>We strive to be a force for good and stand up for our beliefs in our company, in our industry, and in the world.</p>
<p>Foster Community</p>
<p>We apply our values inside and outside our four walls, creating neighborhood theaters that are deeply tied to the local community.</p>
<p>Give a Sh!t</p>
<p>We take pride in our work because we know it makes all the difference to our guests and teammates.</p>
<p>Boldly Go</p>
<p>Like the crew of a certain Starship, we seek out new experiences and pursue innovation in all of our work.</p>
</div>',
'post_date' => '2019-08-05 18:53:28',
'compensation' => '',
'craigslist_city' => 'new york city',
'craigslist_sub_city' => 'westchester',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New York'
)
)
)
$display_company_title = 'Jobs at Alamo Drafthouse Cinema - Yonkers'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w15603529211447759701_small.jpg'
$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">
<img title="Alamo Drafthouse Cinema - Yonkers" alt="Alamo Drafthouse Cinema - Yonkers" src="https://d2qez73695kjfi.cloudfront.net/w15603528961693137202_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Alamo Drafthouse Cinema - Yonkers</h1>
<p class="text-muted">Yonkers, 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="company-image">
<img title="Alamo Drafthouse Cinema - Yonkers" alt="Alamo Drafthouse Cinema - Yonkers" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15603529211447759701_small.jpg" class="img-responsive center-block" />
</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">August 05, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46151" job_id="46151" href="/jobs/view/46151" title="Shift Supervisor at Alamo Drafthouse (FOH)"><strong>Shift Supervisor at Alamo Drafthouse (FOH)</strong></a>
</h2>
<div class="job-location">Westchester</div>
</div>
<div class="col-xs-12">
<p class="description">The Shift Supervisor position is an integral part of the management team and is responsible for running daily operations as well as providing leadership to our staff members. Key responsibilities include managing the staff by upholding standards of presentation, food quality, excellent guest service...</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
The Shift Supervisor position is an integral part of the management team and is responsible for running daily operations as well as providing leadership to our staff members. Key responsibilities include managing the staff by upholding standards of presentation, food quality, excellent guest service...
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` = 14026 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` = 14026 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` = 14026 LIMIT 1