*/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_53bf8f6db43c220e65df6237c5a5b7d1' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
$key = '_employer_first_53bf8f6db43c220e65df6237c5a5b7d1'
$value = array(
'version' => (int) 0,
'data' => array(
'Employer' => array(
'company_name' => 'Uva Enoteca',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '568 Haight Street',
'id' => '31030',
'about_us' => 'Welcome to Uva Enoteca. Our cuisine is focused on the Italian Enoteca experience. We serve Formaggi, Carne, Antipasti, Insalate, Pizza, Pasta and Gelato everyday.
We also feature an all Italian wine list showcasing small Italian producers and wine based cocktails. we look forward to serving you.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94117',
'yelp_page' => 'https://www.yelp.com/biz/uva-enoteca-san-francisco',
'facebook_page' => 'https://www.facebook.com/uvaenoteca/',
'website' => 'http://www.uvaenoteca.com',
'company_logo' => 'w15601886202111260701_small.jpg',
'twitter_name' => '@uvaenoteca'
),
'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_35989208c44eb889830c9d20dc875a56' 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_1ec7c66bf924da683714dc61454fcea9' 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 Uva Enoteca 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 Uva Enoteca in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Uva Enoteca in San Francisco, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Uva Enoteca',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '568 Haight Street',
'id' => '31030',
'about_us' => 'Welcome to Uva Enoteca. Our cuisine is focused on the Italian Enoteca experience. We serve Formaggi, Carne, Antipasti, Insalate, Pizza, Pasta and Gelato everyday.
We also feature an all Italian wine list showcasing small Italian producers and wine based cocktails. we look forward to serving you.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94117',
'yelp_page' => 'https://www.yelp.com/biz/uva-enoteca-san-francisco',
'facebook_page' => 'https://www.facebook.com/uvaenoteca/',
'website' => 'http://www.uvaenoteca.com',
'company_logo' => 'w15601886202111260701_small.jpg',
'twitter_name' => '@uvaenoteca'
),
'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 Uva Enoteca',
'employers_own_page' => false,
'mobile_image' => '',
'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="Uva Enoteca" alt="Uva Enoteca" src="https://d2qez73695kjfi.cloudfront.net/w15601886202111260701_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Uva Enoteca</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://www.uvaenoteca.com" target="_blank">http://www.uvaenoteca.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/uvaenoteca/" target="_new" title="Uva Enoteca Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
<li>
<a rel="nofollow" href="http://www.twitter.com/@uvaenoteca" target="_new" title="Uva Enoteca Twitter Page">
<img width="32" src="/css/images/twitter-round-large.png" alt="" />
</a>
</li>
<li>
<a rel="nofollow" href="https://www.yelp.com/biz/uva-enoteca-san-francisco" target="_new" title="https://www.yelp.com/biz/uva-enoteca-san-francisco Yelp Page">
<img width="30" src="/css/images/yelp-round-large.png" alt="" />
</a>
</li>
</ul>
</div>
</div>
</div>
</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">July 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45873" job_id="45873" href="/jobs/view/45873" title="Uva Enoteca is seeking experienced server!"><strong>Uva Enoteca is seeking experienced server!</strong></a>
</h2>
<div class="job-location">Lower Haight</div>
</div>
<div class="col-xs-12">
<p class="description">Uva Enoteca is located in the Lower Height and inspired by Italy's casual neighborhood enotecas, it features honest Italian food & a distinctive wine list that spans the range of Italian producers and regions. We are looking for an experienced server for 4 shifts. Qualified candidates must:...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Welcome to Uva Enoteca. Our cuisine is focused on the Italian Enoteca experience. We serve Formaggi, Carne, Antipasti, Insalate, Pizza, Pasta and Gelato everyday. <br />
We also feature an all Italian wine list showcasing small Italian producers and wine based cocktails. we look forward to serving you.</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 Uva Enoteca in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Uva Enoteca in San Francisco, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Uva Enoteca',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '568 Haight Street',
'id' => '31030',
'about_us' => 'Welcome to Uva Enoteca. Our cuisine is focused on the Italian Enoteca experience. We serve Formaggi, Carne, Antipasti, Insalate, Pizza, Pasta and Gelato everyday.
We also feature an all Italian wine list showcasing small Italian producers and wine based cocktails. we look forward to serving you.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94117',
'yelp_page' => 'https://www.yelp.com/biz/uva-enoteca-san-francisco',
'facebook_page' => 'https://www.facebook.com/uvaenoteca/',
'website' => 'http://www.uvaenoteca.com',
'company_logo' => 'w15601886202111260701_small.jpg',
'twitter_name' => '@uvaenoteca'
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '45873',
'open' => '1',
'title' => 'Uva Enoteca is seeking experienced server!',
'unique_name' => '',
'description' => '<p>Uva Enoteca is located in the Lower Height and inspired by Italy's casual neighborhood enotecas, it features honest Italian food & a distinctive wine list that spans the range of Italian producers and regions.</p>
<p>We are looking for an experienced server for 4 shifts.</p>
<p>Qualified candidates must:</p>
<p style="padding-left: 30px;">- Have 2+ years of serving experience.</p>
<p style="padding-left: 30px;">- Italian wine knowledge would be preferable</p>
<p style="padding-left: 30px;">- Experience with Aloha and OpenTable.</p>
<p style="padding-left: 30px;">- Able to work nights weekends and holidays.</p>
<p style="padding-left: 30px;"> </p>
<p>Please include your resume in your response.</p>
<p> </p>
<p>Thank you and good luck!</p>',
'post_date' => '2019-07-19 17:34:03',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'lower haight',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Uva Enoteca'
$employers_own_page = false
$mobile_image = ''
$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="Uva Enoteca" alt="Uva Enoteca" src="https://d2qez73695kjfi.cloudfront.net/w15601886202111260701_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Uva Enoteca</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://www.uvaenoteca.com" target="_blank">http://www.uvaenoteca.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/uvaenoteca/" target="_new" title="Uva Enoteca Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
<li>
<a rel="nofollow" href="http://www.twitter.com/@uvaenoteca" target="_new" title="Uva Enoteca Twitter Page">
<img width="32" src="/css/images/twitter-round-large.png" alt="" />
</a>
</li>
<li>
<a rel="nofollow" href="https://www.yelp.com/biz/uva-enoteca-san-francisco" target="_new" title="https://www.yelp.com/biz/uva-enoteca-san-francisco Yelp Page">
<img width="30" src="/css/images/yelp-round-large.png" alt="" />
</a>
</li>
</ul>
</div>
</div>
</div>
</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">July 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45873" job_id="45873" href="/jobs/view/45873" title="Uva Enoteca is seeking experienced server!"><strong>Uva Enoteca is seeking experienced server!</strong></a>
</h2>
<div class="job-location">Lower Haight</div>
</div>
<div class="col-xs-12">
<p class="description">Uva Enoteca is located in the Lower Height and inspired by Italy's casual neighborhood enotecas, it features honest Italian food & a distinctive wine list that spans the range of Italian producers and regions. We are looking for an experienced server for 4 shifts. Qualified candidates must:...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Welcome to Uva Enoteca. Our cuisine is focused on the Italian Enoteca experience. We serve Formaggi, Carne, Antipasti, Insalate, Pizza, Pasta and Gelato everyday. <br />
We also feature an all Italian wine list showcasing small Italian producers and wine based cocktails. we look forward to serving you.</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
Uva Enoteca is located in the Lower Height and inspired by Italy's casual neighborhood enotecas, it features honest Italian food & a distinctive wine list that spans the range of Italian producers and regions. We are looking for an experienced server for 4 shifts. Qualified candidates must:...
About Us
Welcome to Uva Enoteca. Our cuisine is focused on the Italian Enoteca experience. We serve Formaggi, Carne, Antipasti, Insalate, Pizza, Pasta and Gelato everyday.
We also feature an all Italian wine list showcasing small Italian producers and wine based cocktails. we look forward to serving you.
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` = 31030 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` = 31030 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` = 31030 LIMIT 1