*/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_aa21058a248567f04d18c7682923b96a' 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_e9fa002b71040bd54369bca4834735fd' 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_389bd16f6af0c04bbffa0b69f3b0dd01' 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 Presidio Social Club 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 Presidio Social Club in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Presidio Social Club in San Francisco, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Presidio Social Club',
'founded_date' => '2006-01-01 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.79539871',
'lon' => '-122.46399689',
'street_address' => '563 Ruger Street',
'id' => '12269',
'about_us' => 'We are a full service restaurant and bar serving Lunch, Dinner, Brunch and Special Events.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94129',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://www.presidiosocialclub.com',
'company_logo' => 'w13994790741523870734_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]
)
),
(int) 1 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Presidio Social Club',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/12269.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="Presidio Social Club" alt="Presidio Social Club" src="https://d2qez73695kjfi.cloudfront.net/w13994790741523870734_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Presidio Social Club</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.presidiosocialclub.com" target="_blank">http://www.presidiosocialclub.com</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Presidio Social Club" alt="Presidio Social Club" src="http://proven-employer-mobile-images.s3.amazonaws.com/12269.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">July 24, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="26806" job_id="26806" href="/jobs/view/26806" title="Experienced Host"><strong>Experienced Host</strong></a>
</h2>
<div class="job-location">Laurel Hts / Presidio</div>
</div>
<div class="col-xs-12">
<p class="description">Presidio Social Club is looking for an experienced Host We are a 10 year old restaurant in San Francisco, and are currently looking for a host. This is a full-time position. We will appreciate candidates with prior experience, hospitality professionals with a good work ethic and a thorough understanding...</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 24, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45951" job_id="45951" href="/jobs/view/45951" title="Manager / Special Events Background"><strong>Manager / Special Events Background</strong></a>
</h2>
<div class="job-location">Laurel Hts / Presidio</div>
</div>
<div class="col-xs-12">
<p class="description">Serving up a classic Northern California vibe, attentive hospitality, and a comforting seasonal menu, San Francisco’s iconic Presidio Social Club is open every day for all your social gatherings. Nestled within the beautiful Presidio National Park, PSC is at once an inviting urban oasis and...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>We are a full service restaurant and bar serving Lunch, Dinner, Brunch and Special Events.</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 Presidio Social Club in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Presidio Social Club in San Francisco, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Presidio Social Club',
'founded_date' => '2006-01-01 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.79539871',
'lon' => '-122.46399689',
'street_address' => '563 Ruger Street',
'id' => '12269',
'about_us' => 'We are a full service restaurant and bar serving Lunch, Dinner, Brunch and Special Events.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94129',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://www.presidiosocialclub.com',
'company_logo' => 'w13994790741523870734_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '26806',
'open' => '1',
'title' => 'Experienced Host',
'unique_name' => '',
'description' => '<p><strong>Presidio Social Club is looking for an experienced Host </strong></p>
<p>We are a 10 year old restaurant in San Francisco, and are currently looking for a host. This is a full-time position. We will appreciate candidates with prior experience, hospitality professionals with a good work ethic and a thorough understanding of the flow of a busy fine dining restaurant. </p>
<p>We will reward your loyalty with competitive pay, a good benefit package, and a fun work environment where we are all here for the same thing - our guests.</p>
<p><br /> Applicant must have:<br /> • Minimum of 2 years high volume or fine dining experience<br /> • Punctuality<br /> • Must be self-motivating<br /> • Thorough knowledge of Open Table<br /> • Understanding of busy restaurant flow, and maximizing table usage<br /> • A friendly outgoing and hospitable personality<br /> • A responsible, organized, positive attitude and be able to multitask <br /> • Phone and reservationist experience<br /> • A passion for Food & Hospitality</p>
<p>The applicant must be well groomed, patient, work well under pressure, and above all be gracious.</p>
<p>You must be available for evening shifts and some brunch shifts</p>
<p>Please attach resume and references to your response email. <br /> We look forward to hearing from you.</p>',
'post_date' => '2019-07-25 02:15:22',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'laurel hts / presidio',
'craigslist_state' => 'California'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '45951',
'open' => '1',
'title' => 'Manager / Special Events Background',
'unique_name' => '',
'description' => '<p>Serving up a classic Northern California vibe, attentive hospitality, and a comforting seasonal menu, San Francisco’s iconic Presidio Social Club is open every day for all your social gatherings. Nestled within the beautiful Presidio National Park, PSC is at once an inviting urban oasis and a lively destination fit for an intimate dinner for two or a celebratory venue for large groups. Erected in 1903 as a military barracks, the historical building has been converted into a modern eatery sure to put anyone “at-ease” featuring contemporary twists on San Francisco staples and artfully crafted cocktails.<br /><br />PSC is looking for someone with Restaraunt Floor & Special Events experience. We are a 12-year-old restaurant in San Francisco, with a busy SE department. This is a full-time position. We will appreciate candidates who are hospitality professionals with a good work ethic.<br /><br />We will reward your loyalty with competitive pay, a good benefits package, and a fun work environment where we are all here for the same thing - our guests.<br /><br />1. Management and Supervision in our two Presidio locations, Presidio Social Club and Presidio Palms Café.<br />2. Time would be spent in both locations.<br />3. Assist Events Department in selling, marketing, planning, setup, execution and breakdown of events.<br />4. Some Floor Management will be required. <br />5. Staff and Product Management<br />6. Guest relations<br /><br />We are looking forward to receiving your resume. Thanks!</p>',
'post_date' => '2019-07-25 02:14:33',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'laurel hts / presidio',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Presidio Social Club'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/12269.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="Presidio Social Club" alt="Presidio Social Club" src="https://d2qez73695kjfi.cloudfront.net/w13994790741523870734_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Presidio Social Club</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.presidiosocialclub.com" target="_blank">http://www.presidiosocialclub.com</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Presidio Social Club" alt="Presidio Social Club" src="http://proven-employer-mobile-images.s3.amazonaws.com/12269.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">July 24, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="26806" job_id="26806" href="/jobs/view/26806" title="Experienced Host"><strong>Experienced Host</strong></a>
</h2>
<div class="job-location">Laurel Hts / Presidio</div>
</div>
<div class="col-xs-12">
<p class="description">Presidio Social Club is looking for an experienced Host We are a 10 year old restaurant in San Francisco, and are currently looking for a host. This is a full-time position. We will appreciate candidates with prior experience, hospitality professionals with a good work ethic and a thorough understanding...</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 24, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45951" job_id="45951" href="/jobs/view/45951" title="Manager / Special Events Background"><strong>Manager / Special Events Background</strong></a>
</h2>
<div class="job-location">Laurel Hts / Presidio</div>
</div>
<div class="col-xs-12">
<p class="description">Serving up a classic Northern California vibe, attentive hospitality, and a comforting seasonal menu, San Francisco’s iconic Presidio Social Club is open every day for all your social gatherings. Nestled within the beautiful Presidio National Park, PSC is at once an inviting urban oasis and...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>We are a full service restaurant and bar serving Lunch, Dinner, Brunch and Special Events.</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
Presidio Social Club is looking for an experienced Host We are a 10 year old restaurant in San Francisco, and are currently looking for a host. This is a full-time position. We will appreciate candidates with prior experience, hospitality professionals with a good work ethic and a thorough understanding...
Serving up a classic Northern California vibe, attentive hospitality, and a comforting seasonal menu, San Francisco’s iconic Presidio Social Club is open every day for all your social gatherings. Nestled within the beautiful Presidio National Park, PSC is at once an inviting urban oasis and...
About Us
We are a full service restaurant and bar serving Lunch, Dinner, Brunch and Special Events.
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` = 12269 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` = 12269 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` = 12269 LIMIT 1