*/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_5d9a20ce458b8ca3a2f8ced9e4f13dd3' 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_5b73e3711d7e27e6e6f81f613f172071' 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_b9b0517968e255bb96e09a1a394a8391' 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 The Slanted Door Group 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 The Slanted Door Group in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for The Slanted Door Group in San Francisco, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'The Slanted Door Group',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.74819946',
'lon' => '-122.41600037',
'street_address' => '',
'id' => '15157',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94110',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w1459979735840357711_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 The Slanted Door Group',
'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="The Slanted Door Group" alt="The Slanted Door Group" src="https://d2qez73695kjfi.cloudfront.net/w1459979735840357711_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>The Slanted Door Group</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>
</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 18, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46041" job_id="46041" href="/jobs/view/46041" title="Accounting Clerk"><strong>Accounting Clerk</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">If you are hard-working, energetic, creative, positive and forward-thinking individual; then we want YOU to join our team. The Slanted Door Group is offering a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 years of solid clerical and...</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 18, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46039" job_id="46039" href="/jobs/view/46039" title="Staff Accountant"><strong>Staff Accountant</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">The Slanted Door Group is hiring a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 to 3 years of solid accounting experience, preferably in hospitality or in a restaurant industry. Responsibilities include but not limited to: Manages...</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 The Slanted Door Group in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for The Slanted Door Group in San Francisco, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'The Slanted Door Group',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.74819946',
'lon' => '-122.41600037',
'street_address' => '',
'id' => '15157',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94110',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w1459979735840357711_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46041',
'open' => '1',
'title' => 'Accounting Clerk',
'unique_name' => '',
'description' => '<p>If you are hard-working, energetic, creative, positive and forward-thinking individual; then we want YOU to join our team. The Slanted Door Group is offering a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 years of solid clerical and accounting experience, preferably in hospitality or in a restaurant industry. </p>
<p><strong>Responsibilities include but not limited to:</strong></p>
<ul>
<li>Assist & Support Accounting team with Accts Payable & Accts Receivable functions & process including resolving disputes & discrepancies</li>
<li>Review and reconcile AP issues between external vendors and Company’s personnel.</li>
<li>Maintaining all A/P related matters: new accounts set up, creating invoices/purchase orders, responding to all inquiries</li>
<li>Assist Manager to review and reconcile bank statements</li>
<li>Manage daily incoming and outgoing mails</li>
<li>Maintain records and compliance documents</li>
<li>Review and reconcile monthly credit card purchases using Concur</li>
<li>Maintain accuracy of data in American Funds portal </li>
<li>Ad hoc projects requested by Controller</li>
</ul>
<p><br /> <strong>Requirements:</strong></p>
<ul>
<li>Minimum of 2 years of experience in clerical administration</li>
<li>Excellent interpersonal, written, oral, and phone communication skills</li>
<li>Excellent problem-solving skills</li>
<li>Strong PC skills, Microsoft Suite</li>
<li>Strong interpersonal leadership skills</li>
<li>Knowledge of QuickBooks is a plus</li>
<li>Detail oriented, and the ability to work independently and take initiatives in a team environment</li>
<li>Ability to handle sensitive and confidential information</li>
</ul>
<p> </p>
<p>**We participate in E-Verify. EOE, FCO compliant</p>',
'post_date' => '2019-07-18 23:53:02',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'bypass this step',
'craigslist_state' => 'California'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '46039',
'open' => '1',
'title' => 'Staff Accountant',
'unique_name' => '',
'description' => '<p>The Slanted Door Group is hiring a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 to 3 years of solid accounting experience, preferably in hospitality or in a restaurant industry. </p>
<p><strong>Responsibilities include but not limited to:</strong></p>
<ul>
<li>Manages full function of Accts Payable & Accts Receivable process including resolving disputes & discrepancies</li>
<li>Perform full functions of in house Payroll and Payroll Taxes</li>
<li>Reconciling daily sales, deposits, bank statements, updating the trial balance & profit and loss statement</li>
<li>Maintain compliance with Federal, State, and Local municipality reporting and payments</li>
<li>Audit, Review and Reconcile General Ledger/ Insurance policies</li>
<li>Facilitate, supervise and perform monthly closing for multiple books</li>
<li>Ensure all Financial, Payroll, Human Resources reporting are met timely</li>
<li>Oversight of Tip compensation with location managers payroll</li>
<li>Manage distribution of cash tips with Aline prepaid visa Portal</li>
<li>Assist Controller in facilitating information with the Accounting and Management Team</li>
</ul>
<p><br /><strong>Requirements:</strong></p>
<ul>
<li>Minimum of 2 years of experience in QuickBooks/Intuit (Full function experience)</li>
<li>Minimum of 2 years of experience in ADP</li>
<li>Minimum of 2 years of experience in full Bookkeeping ( A/R, A/P, Payroll, Closing)</li>
<li>Knowledge of systems: Toast, Micros, Plate IQ, Ctuit, Reciprofity, Concur etc...</li>
<li>Excellent interpersonal, written, oral, and phone communication skills</li>
<li>Excellent problem solving skills</li>
<li>Strong PC skills</li>
<li>Strong leadership skills</li>
<li>Detail oriented, and the ability to work independently and take initiative</li>
<li>Ability to handle sensitive and confidential information</li>
</ul>
<p> </p>
<p>If you are hard-working, energetic, creative, positive and forward thinking individual; then we want YOU to join our team!!! </p>
<p>**We participate in E-Verify. EOE, FCO compliant</p>',
'post_date' => '2019-07-18 19:51:22',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'bypass this step',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at The Slanted Door Group'
$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="The Slanted Door Group" alt="The Slanted Door Group" src="https://d2qez73695kjfi.cloudfront.net/w1459979735840357711_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>The Slanted Door Group</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>
</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 18, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46041" job_id="46041" href="/jobs/view/46041" title="Accounting Clerk"><strong>Accounting Clerk</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">If you are hard-working, energetic, creative, positive and forward-thinking individual; then we want YOU to join our team. The Slanted Door Group is offering a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 years of solid clerical and...</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 18, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46039" job_id="46039" href="/jobs/view/46039" title="Staff Accountant"><strong>Staff Accountant</strong></a>
</h2>
<div class="job-location">City Of San Francisco</div>
</div>
<div class="col-xs-12">
<p class="description">The Slanted Door Group is hiring a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 to 3 years of solid accounting experience, preferably in hospitality or in a restaurant industry. Responsibilities include but not limited to: Manages...</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
If you are hard-working, energetic, creative, positive and forward-thinking individual; then we want YOU to join our team. The Slanted Door Group is offering a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 years of solid clerical and...
The Slanted Door Group is hiring a full time, non- exempt position to join our multi-restaurant management company. Candidate must have minimum 2 to 3 years of solid accounting experience, preferably in hospitality or in a restaurant industry. Responsibilities include but not limited to: Manages...
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` = 15157 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` = 15157 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` = 15157 LIMIT 1