*/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_ff08c803d2ad502576eec7fd44481211' 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_f48a2bf035cda2fba35540a4f65dd844' 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_b810a5bf1d57c792f28e2410bc204eed' 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 - San Francisco in San Francisco, CAWarning (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 - San Francisco in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Alamo Drafthouse Cinema - San Francisco in San Francisco, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Alamo Drafthouse Cinema - San Francisco',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.74819946',
'lon' => '-122.41600037',
'street_address' => ' 2550 Mission St',
'id' => '14008',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94110',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w1560352715260234561_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'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 - San Francisco',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w15603527321838103411_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 - San Francisco" alt="Alamo Drafthouse Cinema - San Francisco" src="https://d2qez73695kjfi.cloudfront.net/w1560352715260234561_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 - San Francisco</h1>
<p class="text-muted">San Francisco, CA</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 - San Francisco" alt="Alamo Drafthouse Cinema - San Francisco" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15603527321838103411_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 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45530" job_id="45530" href="/jobs/view/45530" title="Hiring an Assistant Kitchen Manager at Alamo Drafthouse New Mission!!"><strong>Hiring an Assistant Kitchen Manager at Alamo Drafthouse New Mission!!</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">The Assistant Kitchen Manager is a fundamental part of the management team and is responsible for maximizing profits and controlling many factors such as product costs, inventory efficiencies, maximizing storage and space, labor cost, staffing levels, staff development, safety, sanitation practices/systems,...</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 - San Francisco in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Alamo Drafthouse Cinema - San Francisco in San Francisco, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Alamo Drafthouse Cinema - San Francisco',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.74819946',
'lon' => '-122.41600037',
'street_address' => ' 2550 Mission St',
'id' => '14008',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94110',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w1560352715260234561_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '45530',
'open' => '1',
'title' => 'Hiring an Assistant Kitchen Manager at Alamo Drafthouse New Mission!!',
'unique_name' => '',
'description' => '<p>The Assistant Kitchen Manager is a fundamental part of the management team and is responsible for maximizing profits and controlling many factors such as product costs, inventory efficiencies, maximizing storage and space, labor cost, staffing levels, staff development, safety, sanitation practices/systems, and productivity. The Assistant Kitchen Manager manages all kitchen operations and kitchen staff development. The main priority is to achieve optimal product, people and financial results, including the development of others to support this priority.<br /><br />DUTIES / RESPONSIBILITIES:<br /><br />-Ensures that ALL GUESTS have an AWESOME EXPERIENCE, and are EXCITED to come back.<br />-Manages operations of the kitchen, which includes daily decision-making, flexibility, staff support, guest interaction, scheduling, and effective planning while upholding standards, product quality, and cleanliness. Also responsible for cross training other managers in kitchen functions.<br />-Actively monitors inventory and reports results to the Kitchen Manager. Develops staff on the appropriate utilization of the inventory system.<br />-Sets high expectations in regard to food quality by maintaining and coaching pristine cleanliness, organization, appropriate food storage, and sanitation standards.<br />-Maintains, controls and develops staff on food cost by properly ordering and receiving products.<br />-Maintains appropriate staffing pars by actively tracking labor and maintaining budgeted staffing expectations.<br />-Understands how to utilize product mix as a tool to minimize waste and establish accurate pars.<br />-Prepares and coaches staff on daily prep lists, using proper inventory practices.<br />-Actively participates in menu rollouts, including planning necessary item rotation, depletion, and additions.<br />-Develops staff on the proper preparation and guidelines for new menus and special items.<br />-Verifies product consistency through constant recipe adherence, line checks, and appropriate portion control.<br />-Consistently reviews tickets times ensuring all food is promptly made and delivered.<br />-Maintains appropriate smallware supplies, ordering practices and utilizes declining budgets.<br />-Interviews and hires kitchen staff according to Alamo standards. Stays ahead of the seasonal needs by planning appropriately.<br />-Conducts thorough line checks in a timely manner, utilizing line checks as a coaching tool for staff members.<br />-Responsible for staff scheduling, using forecasting and labor proforma tools. Posts and communicates schedules in a timely manner.<br />-Cross-trains the staff to aid in the scheduling process.<br />-Encourages communication between all areas of the venue (management, ticket, servers, bar, kitchen, etc.).<br />-Maintains an upbeat, energetic presence throughout shift.<br />-Maintains the kitchen communications board and verifies staff knowledge and understanding of the information provided.<br />-Conducts kitchen meetings when necessary, shift meetings every day and keeps staff informed on new developments and upcoming events.<br />-Ensures all staff members adhere to the Company's uniform standards.<br />-Ensures a safe working and guest experience environment to reduce the risk of incident, injury and food handling related issues.<br />-Ensures proper security procedures are in place to protect staff members, guests and company assets. This includes security of all storage rooms and products.<br />-Follows the company standard interviewing and hiring procedures.<br />-Controls the inventory process by managing ordering/receiving and invoice accuracy.<br /><br />QUALIFICATIONS:<br />-A minimum of one (1) year of high volume venue experience. Prior<br />-Alamo Drafthouse experience will be considered in lieu of venue experience. Previous theater management is beneficial.<br />-ServSafe Certification, local Health Cards (as required) and TABC Certification are required.<br />-Must be positive, fun, coachable and open minded.<br />-Strong verbal and written communication skills.<br />-High guest satisfaction expectations and focus.<br />-Resourceful problem-solving skills.<br />-Consistently maintain high performance standards.<br />-Expected work week of 45 hours minimum; higher volume seasons and heavier work weeks are expected.<br />-Basic computer knowledge (Microsoft Office) and office skills required.<br />-Restaurant and hospitality industry. Must have a flexible schedule.<br />-Interested applicants ***please submit your resume.<br /><br />WORKING CONDITIONS: Work is typically performed in the restaurant environment. The noise level in the work environment is usually moderate. The work involves a majority of sitting, bending, stooping, twisting, climbing and some lifting up to 50 lbs.<br /><br />HAZARDS: Only those present in a normal restaurant setting; no known significant hazards. Work performed in the restaurant has minimal exposure to cleaning chemicals, cooking equipment along with minimal machinery with moving parts.</p>
<p> </p>
<p>Alamo Drafthouse is passionate and dedicated to ensuring our company’s mission and core values, every day, 365 days a year. Part of that is by training to and enforcing Alamo Drafthouse’s <a href="https://workable.com/nr?l=https%3A%2F%2Fdrafthouse.com%2Fcode-of-conduct">Code of Conduct</a> with all staff and vendors.</p>
<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>',
'post_date' => '2019-08-19 20:51:48',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Alamo Drafthouse Cinema - San Francisco'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w15603527321838103411_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 - San Francisco" alt="Alamo Drafthouse Cinema - San Francisco" src="https://d2qez73695kjfi.cloudfront.net/w1560352715260234561_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 - San Francisco</h1>
<p class="text-muted">San Francisco, CA</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 - San Francisco" alt="Alamo Drafthouse Cinema - San Francisco" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15603527321838103411_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 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45530" job_id="45530" href="/jobs/view/45530" title="Hiring an Assistant Kitchen Manager at Alamo Drafthouse New Mission!!"><strong>Hiring an Assistant Kitchen Manager at Alamo Drafthouse New Mission!!</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">The Assistant Kitchen Manager is a fundamental part of the management team and is responsible for maximizing profits and controlling many factors such as product costs, inventory efficiencies, maximizing storage and space, labor cost, staffing levels, staff development, safety, sanitation practices/systems,...</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 Assistant Kitchen Manager is a fundamental part of the management team and is responsible for maximizing profits and controlling many factors such as product costs, inventory efficiencies, maximizing storage and space, labor cost, staffing levels, staff development, safety, sanitation practices/systems,...
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` = 14008 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` = 14008 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` = 14008 LIMIT 1