*/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_2e8c396d091a50be577379cb9d96f210' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
$key = '_employer_first_2e8c396d091a50be577379cb9d96f210'
$value = array(
'version' => (int) 0,
'data' => array(
'Employer' => array(
'company_name' => 'Bierhaus',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Oakland',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '360 40th St',
'id' => '30043',
'about_us' => 'Opening Soon, Bierhaus will offer a carefully cultivated selection of great European and Local Beers, along with a German influenced menu of truly delicious food.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => 'The employee culture of Bierhaus is centered around teamwork, accountability, and self-management. Members of our team support each other and are accountable to each other, and over time our team members come into work already knowing how to manage their time and achieve strong results. ',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are seeking conscientious, reliable, friendly people who share a genuine desire to take care of our guests to join our dynamic team.',
'zipcode' => '94609',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://www.bierha.us',
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'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_6667e33df4d2f3fe0c86f1f31fd70034' 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_26e4768aa0bfdcfc74abb228c393f1e8' 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 Bierhaus in Oakland, 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 Bierhaus in <span class='locality'>Oakland</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Bierhaus in Oakland, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Bierhaus',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Oakland',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '360 40th St',
'id' => '30043',
'about_us' => 'Opening Soon, Bierhaus will offer a carefully cultivated selection of great European and Local Beers, along with a German influenced menu of truly delicious food.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => 'The employee culture of Bierhaus is centered around teamwork, accountability, and self-management. Members of our team support each other and are accountable to each other, and over time our team members come into work already knowing how to manage their time and achieve strong results. ',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are seeking conscientious, reliable, friendly people who share a genuine desire to take care of our guests to join our dynamic team.',
'zipcode' => '94609',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://www.bierha.us',
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Bierhaus',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w1540763450428280710_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">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Bierhaus</h1>
<p class="text-muted">Oakland, 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://www.bierha.us" target="_blank">http://www.bierha.us</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Bierhaus" alt="Bierhaus" src="http://proven-employer-mobile-images.s3.amazonaws.com/w1540763450428280710_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">June 15, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45907" job_id="45907" href="/jobs/view/45907" title="Temescal Restaurant Hiring Servers/Bartenders - Apply in person!"><strong>Temescal Restaurant Hiring Servers/Bartenders - Apply in person!</strong></a>
</h2>
<div class="job-location">Oakland North / Temescal</div>
</div>
<div class="col-xs-12">
<p class="description">Bierhaus is a social German-inspired biergarten restaurant/gastropub in the growing Temescal neighborhood. Our culture is positive, friendly, and team-oriented, and our front of house team are all cross-trained as cashiers, bartenders, servers, and runner/bussers. We are looking for a new member to...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Opening Soon, Bierhaus will offer a carefully cultivated selection of great European and Local Beers, along with a German influenced menu of truly delicious food.</p>
</div>
</div>
<div id="cultural_description">
<h3>Company Culture</h3>
<div class="content-panel ui-box-shadow">
<p>The employee culture of Bierhaus is centered around teamwork, accountability, and self-management. Members of our team support each other and are accountable to each other, and over time our team members come into work already knowing how to manage their time and achieve strong results. </p>
</div>
</div>
<div id="looking_for">
<h3>What We Look For</h3>
<div class="content-panel ui-box-shadow">
<p>We are seeking conscientious, reliable, friendly people who share a genuine desire to take care of our guests to join our dynamic team.</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 Bierhaus in <span class='locality'>Oakland</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Bierhaus in Oakland, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Bierhaus',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Oakland',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '360 40th St',
'id' => '30043',
'about_us' => 'Opening Soon, Bierhaus will offer a carefully cultivated selection of great European and Local Beers, along with a German influenced menu of truly delicious food.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => 'The employee culture of Bierhaus is centered around teamwork, accountability, and self-management. Members of our team support each other and are accountable to each other, and over time our team members come into work already knowing how to manage their time and achieve strong results. ',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are seeking conscientious, reliable, friendly people who share a genuine desire to take care of our guests to join our dynamic team.',
'zipcode' => '94609',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://www.bierha.us',
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '45907',
'open' => '1',
'title' => 'Temescal Restaurant Hiring Servers/Bartenders - Apply in person!',
'unique_name' => '',
'description' => '<p>Bierhaus is a social German-inspired biergarten restaurant/gastropub in the growing Temescal neighborhood. Our culture is positive, friendly, and team-oriented, and our front of house team are all cross-trained as cashiers, bartenders, servers, and runner/bussers. We are looking for a new member to join our team as we continue to grow! Full or part time applicants will be considered.<br /><br />Candidates must be motivated and responsible team players with the following qualifications:<br />- Customer service and detail-oriented, hard working and able to think quickly on your feet<br />- Natural friendliness and generosity with customers and coworkers<br />- Good understanding or a strong willingness to learn about beer, wine, and food<br />- Must be available to work nights and weekends<br />- Must have an up-to-date food handlers card before starting<br />- Candidates with a minimum of 1 year in the service industry will be more strongly considered</p>
<p><strong>Please apply in person during our open interview sessions:</strong> Tuesday 6/18 2pm-5pm and Thursday 6/20 2pm-5pm. Please bring a copy of your resume. Hiring decisions made on the spot! We are located at 360 40th St, Oakland CA 94609. </p>',
'post_date' => '2019-06-16 03:34:34',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'east bay area',
'craigslist_sub_sub_city' => 'oakland north / temescal',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Bierhaus'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w1540763450428280710_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">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Bierhaus</h1>
<p class="text-muted">Oakland, 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://www.bierha.us" target="_blank">http://www.bierha.us</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Bierhaus" alt="Bierhaus" src="http://proven-employer-mobile-images.s3.amazonaws.com/w1540763450428280710_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">June 15, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45907" job_id="45907" href="/jobs/view/45907" title="Temescal Restaurant Hiring Servers/Bartenders - Apply in person!"><strong>Temescal Restaurant Hiring Servers/Bartenders - Apply in person!</strong></a>
</h2>
<div class="job-location">Oakland North / Temescal</div>
</div>
<div class="col-xs-12">
<p class="description">Bierhaus is a social German-inspired biergarten restaurant/gastropub in the growing Temescal neighborhood. Our culture is positive, friendly, and team-oriented, and our front of house team are all cross-trained as cashiers, bartenders, servers, and runner/bussers. We are looking for a new member to...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Opening Soon, Bierhaus will offer a carefully cultivated selection of great European and Local Beers, along with a German influenced menu of truly delicious food.</p>
</div>
</div>
<div id="cultural_description">
<h3>Company Culture</h3>
<div class="content-panel ui-box-shadow">
<p>The employee culture of Bierhaus is centered around teamwork, accountability, and self-management. Members of our team support each other and are accountable to each other, and over time our team members come into work already knowing how to manage their time and achieve strong results. </p>
</div>
</div>
<div id="looking_for">
<h3>What We Look For</h3>
<div class="content-panel ui-box-shadow">
<p>We are seeking conscientious, reliable, friendly people who share a genuine desire to take care of our guests to join our dynamic team.</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
Bierhaus is a social German-inspired biergarten restaurant/gastropub in the growing Temescal neighborhood. Our culture is positive, friendly, and team-oriented, and our front of house team are all cross-trained as cashiers, bartenders, servers, and runner/bussers. We are looking for a new member to...
About Us
Opening Soon, Bierhaus will offer a carefully cultivated selection of great European and Local Beers, along with a German influenced menu of truly delicious food.
Company Culture
The employee culture of Bierhaus is centered around teamwork, accountability, and self-management. Members of our team support each other and are accountable to each other, and over time our team members come into work already knowing how to manage their time and achieve strong results.
What We Look For
We are seeking conscientious, reliable, friendly people who share a genuine desire to take care of our guests to join our dynamic team.
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` = 30043 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` = 30043 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` = 30043 LIMIT 1