*/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_7f9ba0b42a9083d62bb05e62241849ac' 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_678a8419754697df6b83007e3a71990b' 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_d7ee70c56917d8f17686ae79ba2a563e' 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 Flores Corte Madera in Corte Madera, 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 Flores Corte Madera in <span class='locality'>Corte Madera</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Flores Corte Madera in Corte Madera, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Flores Corte Madera',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Corte Madera',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '301 Corte Madera Town Center',
'id' => '29320',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94925',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => 'w1534194605768447194_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'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 Flores Corte Madera',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w15341946171190526996_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="Flores Corte Madera" alt="Flores Corte Madera" src="https://d2qez73695kjfi.cloudfront.net/w1534194605768447194_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Flores Corte Madera</h1>
<p class="text-muted">Corte Madera, 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="Flores Corte Madera" alt="Flores Corte Madera" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15341946171190526996_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="44263" job_id="44263" href="/jobs/view/44263" title="Flores Restaurant at Corte Madera looking for Bartenders & Servers!"><strong>Flores Restaurant at Corte Madera looking for Bartenders & Servers!</strong></a>
</h2>
<div class="job-location">Novato</div>
</div>
<div class="col-xs-12">
<p class="description">We are seeking energetic, passionate, and experienced Bartenders for our Flores location serving Mexican cuisine in the Corte Madera Town Center. We’re San Francisco’s first contemporary Mexican restaurant serving traditional Mexican food and inspired cocktails. Flores is looking for...</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 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="25489" job_id="25489" href="/jobs/view/25489" title="Flores Corte Madera location seeking Sous Chef"><strong>Flores Corte Madera location seeking Sous Chef</strong></a>
</h2>
<div class="job-location">Corte Madera</div>
</div>
<div class="col-xs-12">
<p class="description">Back of The House, the restaurant group behind some of San Francisco's most unique concepts and favorite neighborhood spots, such as Beretta, Lolinda, Delarosa, Starbelly, El Techo, Uno Dos Tacos, Belga, Amano, Barvale, and Super Duper Burgers, creates concept-driven restaurants that encompass the...</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 Flores Corte Madera in <span class='locality'>Corte Madera</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Flores Corte Madera in Corte Madera, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Flores Corte Madera',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Corte Madera',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '301 Corte Madera Town Center',
'id' => '29320',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94925',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => 'w1534194605768447194_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '44263',
'open' => '1',
'title' => 'Flores Restaurant at Corte Madera looking for Bartenders & Servers!',
'unique_name' => '',
'description' => '<p>We are seeking energetic, passionate, and experienced Bartenders for our Flores location serving Mexican cuisine in the Corte Madera Town Center.</p>
<p>We’re San Francisco’s first contemporary Mexican restaurant serving traditional Mexican food and inspired cocktails. </p>
<p>Flores is looking for experienced and energetic team members that are passionate about hospitality and enjoy working with people. Approachability and a passion for working with people is key in this position.</p>
<p>2 years minimum experience in a similar setting and open availability required.</p>
<p>Company Perks</p>
<ul>
<li>Competitive Pay</li>
<li>401k Options</li>
<li>Health, vision, and dental available for employees averaging 26 hours per week. </li>
<li>Dining Privileges at 11 of San Francisco's Best Restaurants </li>
<li>Annual Company Wide Holiday Party</li>
<li>$1,000 Manager Referral Bonus </li>
<li>Employee Portal with access to digital pay-stubs, W2, and your insurance information </li>
<li>Transportation and Commuter Benefits </li>
<li>Dedicated Career Development </li>
</ul>',
'post_date' => '2019-08-05 22:14:57',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'north bay / marin',
'craigslist_sub_sub_city' => 'novato',
'craigslist_state' => 'California'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '25489',
'open' => '1',
'title' => 'Flores Corte Madera location seeking Sous Chef',
'unique_name' => '',
'description' => '<p>Back of The House, the restaurant group behind some of San Francisco's most unique concepts and favorite neighborhood spots, such as Beretta, Lolinda, Delarosa, Starbelly, El Techo, Uno Dos Tacos, Belga, Amano, Barvale, and Super Duper Burgers, creates concept-driven restaurants that encompass the spirit of their San Francisco neighborhoods.</p>
<p>We are seeking an energetic, passionate, and experienced Sous Chef for our Flores Corte Madera location.</p>
<p><strong>From the Kitchen:</strong></p>
<p>Traditional Mexican dishes and flavors, sourced from family recipes that originated in Mexican states from The Gulf, to The Pacific, will not just be the inspiration–they’ll be the rule. Committed to honoring Mexican tradition, ours is a San Francisco.-based Mexican restaurant, thought about in a different way. </p>
<p><strong> </strong>One of our star ingredients will be masa—the dough used in making the fresh corn tortillas found on our menu. To guarantee quality, corn will be ground by hand on site using the ancient metate.</p>
<p> On the menu, you’ll find sharable starters, salads, snacks and mains. An assortment of roasted meats available by the pound (for sharing!), and small plates (think sopes, guacamole, tostadas and empanadas), made using the traditional recipes passed down by mothers and fathers, grandfathers and grandmothers, will be the stars.</p>
<p> Order the crab tostadas, salad, carnitas (they come with a side of fresh, steaming tortillas), mole, and maybe a whole-roasted fish (you’re with a few friends, after all), and you’re well on your way to a memorable night out. A cocktail (or two) is all that’s missing. </p>
<p> Candidates must possess the following qualities:</p>
<p>-Classical training and experience in Mexican cuisine</p>
<p>-Experienced in menu concept development</p>
<p>-Manages all aspects of the kitchen</p>
<p>-Cost control; responsible for the financial results of the kitchen</p>
<p>-Genuine enjoyment of working with people</p>
<p>-Passionate, energetic, and detail oriented</p>
<p>-Ability to successfully lead and manage a team</p>
<p>-2 Years of relevant experience</p>
<p>-Open Availability</p>
<p><strong>Company Perks</strong></p>
<ul>
<li>Competitive Salary/Pay</li>
<li>401k Options</li>
<li>We cover 100% of Health Insurance, Vision, & Dental for our Chef positions </li>
<li>Dining Privileges at 9 of San Francisco's Best Restaurants </li>
<li>Bonus Structure (Paid out monthly) </li>
<li>$1,000 Manager Referral Bonus (Applies to all 15 Restaurants in the group!) </li>
<li>Employee Portal with access to digital pay-stubs, W2, and your insurance information </li>
<li>Group gym membership rates</li>
<li>Monthly Management Happy Hours </li>
<li>Transportation and Commuter Benefits </li>
<li>Paid Vacation</li>
<li>Dedicated Career Development</li>
</ul>',
'post_date' => '2019-07-22 17:39:31',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'north bay / marin',
'craigslist_sub_sub_city' => 'corte madera',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Flores Corte Madera'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w15341946171190526996_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="Flores Corte Madera" alt="Flores Corte Madera" src="https://d2qez73695kjfi.cloudfront.net/w1534194605768447194_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Flores Corte Madera</h1>
<p class="text-muted">Corte Madera, 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="Flores Corte Madera" alt="Flores Corte Madera" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15341946171190526996_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="44263" job_id="44263" href="/jobs/view/44263" title="Flores Restaurant at Corte Madera looking for Bartenders & Servers!"><strong>Flores Restaurant at Corte Madera looking for Bartenders & Servers!</strong></a>
</h2>
<div class="job-location">Novato</div>
</div>
<div class="col-xs-12">
<p class="description">We are seeking energetic, passionate, and experienced Bartenders for our Flores location serving Mexican cuisine in the Corte Madera Town Center. We’re San Francisco’s first contemporary Mexican restaurant serving traditional Mexican food and inspired cocktails. Flores is looking for...</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 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="25489" job_id="25489" href="/jobs/view/25489" title="Flores Corte Madera location seeking Sous Chef"><strong>Flores Corte Madera location seeking Sous Chef</strong></a>
</h2>
<div class="job-location">Corte Madera</div>
</div>
<div class="col-xs-12">
<p class="description">Back of The House, the restaurant group behind some of San Francisco's most unique concepts and favorite neighborhood spots, such as Beretta, Lolinda, Delarosa, Starbelly, El Techo, Uno Dos Tacos, Belga, Amano, Barvale, and Super Duper Burgers, creates concept-driven restaurants that encompass the...</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
We are seeking energetic, passionate, and experienced Bartenders for our Flores location serving Mexican cuisine in the Corte Madera Town Center. We’re San Francisco’s first contemporary Mexican restaurant serving traditional Mexican food and inspired cocktails. Flores is looking for...
Back of The House, the restaurant group behind some of San Francisco's most unique concepts and favorite neighborhood spots, such as Beretta, Lolinda, Delarosa, Starbelly, El Techo, Uno Dos Tacos, Belga, Amano, Barvale, and Super Duper Burgers, creates concept-driven restaurants that encompass the...
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` = 29320 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` = 29320 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` = 29320 LIMIT 1