*/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_a8142b764502ddf79f2f3af82cb5c43b' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
$key = '_employer_first_a8142b764502ddf79f2f3af82cb5c43b'
$value = array(
'version' => (int) 0,
'data' => array(
'Employer' => array(
'company_name' => 'Benu',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.78680038',
'lon' => '-122.39600372',
'street_address' => '22 Hawthorne St, San Francisco, CA 94105',
'id' => '12186',
'about_us' => 'Located in the heart of San Francisco's SOMA district, Chef Corey Lee's debut restaurant, Benu, defines subtle sophistication, offering inspired progressive American cuisine in a space where urbanity and history elegantly coexist. Benu distills fine dining down to the salient elements that are most relevant to the modern dining audience: exquisite ingredients, unique flavors, precise technique and caring service.',
'company_benefits' => 'In addition to a competitive salary we offer medical and dental benefits, paid time off, and educational programs to promote advancement in food, wine, and service.',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are looking for motivated individuals who are wish to pursue a career in hospitality. Qualified applicants should have a strong attention to detail, are able to work in a fast paced environment, and possess a willingness to learn.',
'zipcode' => '94105',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://benusf.com',
'company_logo' => 'w1395963346522179080_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
)
$config = 'default'
$settings = array(
'prefix' => '*****',
'engine' => 'Memcache',
'duration' => (int) 3600,
'probability' => (int) 100,
'servers' => array(
(int) 0 => 'proven-cache.kmvdqz.cfg.use1.cache.amazonaws.com:11211'
),
'compress' => false,
'persistent' => true,
'groups' => array()
)
$success = false
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_cb6301790db919578747f9dd9c53c630' 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_18a2dedd5b88110208ab108db63c9228' 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 Benu 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 Benu in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Benu in San Francisco, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Benu',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.78680038',
'lon' => '-122.39600372',
'street_address' => '22 Hawthorne St, San Francisco, CA 94105',
'id' => '12186',
'about_us' => 'Located in the heart of San Francisco's SOMA district, Chef Corey Lee's debut restaurant, Benu, defines subtle sophistication, offering inspired progressive American cuisine in a space where urbanity and history elegantly coexist. Benu distills fine dining down to the salient elements that are most relevant to the modern dining audience: exquisite ingredients, unique flavors, precise technique and caring service.',
'company_benefits' => 'In addition to a competitive salary we offer medical and dental benefits, paid time off, and educational programs to promote advancement in food, wine, and service.',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are looking for motivated individuals who are wish to pursue a career in hospitality. Qualified applicants should have a strong attention to detail, are able to work in a fast paced environment, and possess a willingness to learn.',
'zipcode' => '94105',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://benusf.com',
'company_logo' => 'w1395963346522179080_small.png',
'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 Benu',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w14433432041953168324_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="Benu" alt="Benu" src="https://d2qez73695kjfi.cloudfront.net/w1395963346522179080_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Benu</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>
<p class="voffset1"><a class="blue-link" href="http://benusf.com" target="_blank">http://benusf.com</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Benu" alt="Benu" src="http://proven-employer-mobile-images.s3.amazonaws.com/w14433432041953168324_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 13, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="13207" job_id="13207" href="/jobs/view/13207" title="Server / Captain Position at Benu Restaurant"><strong>Server / Captain Position at Benu Restaurant</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">We are looking for motivated and enthusiastic individuals to be a part of our dining room team. With three Michelin stars, Benu is an outstanding restaurant to work, progress, and learn in. This is a great career opportunity for those seeking advancement in fine dining. Previous service experience...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Located in the heart of San Francisco's SOMA district, Chef Corey Lee's debut restaurant, Benu, defines subtle sophistication, offering inspired progressive American cuisine in a space where urbanity and history elegantly coexist. Benu distills fine dining down to the salient elements that are most relevant to the modern dining audience: exquisite ingredients, unique flavors, precise technique and caring service.</p>
</div>
</div>
<div id="looking_for">
<h3>What We Look For</h3>
<div class="content-panel ui-box-shadow">
<p>We are looking for motivated individuals who are wish to pursue a career in hospitality. Qualified applicants should have a strong attention to detail, are able to work in a fast paced environment, and possess a willingness to learn.</p>
</div>
</div>
<div id="company_benefits">
<h3>Benefits</h3>
<div class="content-panel ui-box-shadow">
<p>In addition to a competitive salary we offer medical and dental benefits, paid time off, and educational programs to promote advancement in food, wine, and service.</p>
</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 Benu in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Benu in San Francisco, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Benu',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.78680038',
'lon' => '-122.39600372',
'street_address' => '22 Hawthorne St, San Francisco, CA 94105',
'id' => '12186',
'about_us' => 'Located in the heart of San Francisco's SOMA district, Chef Corey Lee's debut restaurant, Benu, defines subtle sophistication, offering inspired progressive American cuisine in a space where urbanity and history elegantly coexist. Benu distills fine dining down to the salient elements that are most relevant to the modern dining audience: exquisite ingredients, unique flavors, precise technique and caring service.',
'company_benefits' => 'In addition to a competitive salary we offer medical and dental benefits, paid time off, and educational programs to promote advancement in food, wine, and service.',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are looking for motivated individuals who are wish to pursue a career in hospitality. Qualified applicants should have a strong attention to detail, are able to work in a fast paced environment, and possess a willingness to learn.',
'zipcode' => '94105',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://benusf.com',
'company_logo' => 'w1395963346522179080_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '13207',
'open' => '1',
'title' => 'Server / Captain Position at Benu Restaurant',
'unique_name' => 'benu-seeks-host-barista-and-food-runners-san-francisco-california',
'description' => '<p>We are looking for motivated and enthusiastic individuals to be a part of our dining room team. With three Michelin stars, Benu is an outstanding restaurant to work, progress, and learn in. This is a great career opportunity for those seeking advancement in fine dining.</p>
<p>Previous service experience or a culinary school degree is required along with a willingness to learn, the dedication to constantly improve service standards, and a strong sense of commitment to working as a team. Experience in Michelin recognized restaurants is preferred.</p>
<p>Benu provides a comprehensive benefits package in addition to a competitive hourly salary. This is a full-time position – Tuesday through Saturday (with Sunday and Monday off). <br /> <br />To apply, please respond with both a cover letter and resume.</p>',
'post_date' => '2019-08-13 22:30:39',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'bypass this step',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Benu'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w14433432041953168324_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="Benu" alt="Benu" src="https://d2qez73695kjfi.cloudfront.net/w1395963346522179080_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Benu</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>
<p class="voffset1"><a class="blue-link" href="http://benusf.com" target="_blank">http://benusf.com</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Benu" alt="Benu" src="http://proven-employer-mobile-images.s3.amazonaws.com/w14433432041953168324_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 13, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="13207" job_id="13207" href="/jobs/view/13207" title="Server / Captain Position at Benu Restaurant"><strong>Server / Captain Position at Benu Restaurant</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">We are looking for motivated and enthusiastic individuals to be a part of our dining room team. With three Michelin stars, Benu is an outstanding restaurant to work, progress, and learn in. This is a great career opportunity for those seeking advancement in fine dining. Previous service experience...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Located in the heart of San Francisco's SOMA district, Chef Corey Lee's debut restaurant, Benu, defines subtle sophistication, offering inspired progressive American cuisine in a space where urbanity and history elegantly coexist. Benu distills fine dining down to the salient elements that are most relevant to the modern dining audience: exquisite ingredients, unique flavors, precise technique and caring service.</p>
</div>
</div>
<div id="looking_for">
<h3>What We Look For</h3>
<div class="content-panel ui-box-shadow">
<p>We are looking for motivated individuals who are wish to pursue a career in hospitality. Qualified applicants should have a strong attention to detail, are able to work in a fast paced environment, and possess a willingness to learn.</p>
</div>
</div>
<div id="company_benefits">
<h3>Benefits</h3>
<div class="content-panel ui-box-shadow">
<p>In addition to a competitive salary we offer medical and dental benefits, paid time off, and educational programs to promote advancement in food, wine, and service.</p>
</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
We are looking for motivated and enthusiastic individuals to be a part of our dining room team. With three Michelin stars, Benu is an outstanding restaurant to work, progress, and learn in. This is a great career opportunity for those seeking advancement in fine dining. Previous service experience...
About Us
Located in the heart of San Francisco's SOMA district, Chef Corey Lee's debut restaurant, Benu, defines subtle sophistication, offering inspired progressive American cuisine in a space where urbanity and history elegantly coexist. Benu distills fine dining down to the salient elements that are most relevant to the modern dining audience: exquisite ingredients, unique flavors, precise technique and caring service.
What We Look For
We are looking for motivated individuals who are wish to pursue a career in hospitality. Qualified applicants should have a strong attention to detail, are able to work in a fast paced environment, and possess a willingness to learn.
Benefits
In addition to a competitive salary we offer medical and dental benefits, paid time off, and educational programs to promote advancement in food, wine, and 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` = 12186 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` = 12186 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` = 12186 LIMIT 1