*/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_6fce9c948c2fd8bcb25fa84327523e93' 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_188c22e646563b7a9d890ba75bb2f4f1' 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_f59b164fffe7b45a3611755642fdfaaf' 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 Mission Cheese LLC 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 Mission Cheese LLC in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Mission Cheese LLC in San Francisco, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Mission Cheese LLC',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.74819946',
'lon' => '-122.41600037',
'street_address' => '',
'id' => '10621',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94110',
'yelp_page' => '',
'facebook_page' => 'http://www.facebook.com/pages/Mission-Cheese/163537183664350',
'website' => 'http://www.missioncheese.net',
'company_logo' => 'w13620826391386297730_small.png',
'twitter_name' => '@missioncheese'
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Mission Cheese LLC',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/10621.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="Mission Cheese LLC" alt="Mission Cheese LLC" src="https://d2qez73695kjfi.cloudfront.net/w13620826391386297730_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Mission Cheese LLC</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.missioncheese.net" target="_blank">http://www.missioncheese.net</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="http://www.facebook.com/pages/Mission-Cheese/163537183664350" target="_new" title="Mission Cheese LLC Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
<li>
<a rel="nofollow" href="http://www.twitter.com/@missioncheese" target="_new" title="Mission Cheese LLC Twitter Page">
<img width="32" src="/css/images/twitter-round-large.png" alt="" />
</a>
</li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="Mission Cheese LLC" alt="Mission Cheese LLC" src="http://proven-employer-mobile-images.s3.amazonaws.com/10621.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 17, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46037" job_id="46037" href="/jobs/view/46037" title="Director of Events & Cheesemonger"><strong>Director of Events & Cheesemonger</strong></a>
</h2>
<div class="job-location">Mission District</div>
</div>
<div class="col-xs-12">
<p class="description">Job Summary Mission Cheese is looking for someone to join our team as Director of Events & Cheesemonger. The ideal candidate would have some combination of cheese, wine, beer, and pairing experience and is looking to take their passion to the next level by joining our dynamic team! We pride ourselves...</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 Mission Cheese LLC in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Mission Cheese LLC in San Francisco, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Mission Cheese LLC',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '37.74819946',
'lon' => '-122.41600037',
'street_address' => '',
'id' => '10621',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94110',
'yelp_page' => '',
'facebook_page' => 'http://www.facebook.com/pages/Mission-Cheese/163537183664350',
'website' => 'http://www.missioncheese.net',
'company_logo' => 'w13620826391386297730_small.png',
'twitter_name' => '@missioncheese'
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46037',
'open' => '1',
'title' => 'Director of Events & Cheesemonger',
'unique_name' => '',
'description' => '<p><strong>Job Summary</strong></p>
<p>Mission Cheese is looking for someone to join our team as Director of Events & Cheesemonger. The ideal candidate would have some combination of cheese, wine, beer, and pairing experience and is looking to take their passion to the next level by joining our dynamic team! We pride ourselves on offering educational and fun events that dazzle taste buds, and you will be playing a key roll in keeping that dream alive.</p>
<p> </p>
<p><strong>About Mission Cheese</strong></p>
<p>Mission Cheese focuses on celebrating American artisan cheese in a format that merges retail cheese shop, café, wine/beer bar concepts. More specifically, Mission Cheese is focused on celebrating the artisan and farmstead cheese movement that has blossomed in the US over the last decade. We source and serve only delicious domestic cheeses for our cheese flights, pressed sandwiches, mac and cheese, etc. A key component of the business is the education of our customers about the cheeses they are eating, including the farmers and cheesemakers that make Mission Cheese possible.</p>
<p>We are passionate about good food and exceptional service. The work atmosphere is fast-paced, positive, and fun. The ability to hustle is required, as is the desire to be a part of an established team. We value employees that are excited about helping to evolve and grow this dynamic food business, and want to learn about the American artisanal food and beverage industries.</p>
<p> </p>
<p><strong>What makes Mission Cheese special?</strong></p>
<ul>
<li>Entrepreneurial & collaborative environment</li>
<li>Passionate about finding, developing, and serving responsibly-produced artisan goods</li>
<li>Regular visits to farms, creameries, wineries, breweries</li>
<li>Potential for growth within a small, family owned, dynamic business</li>
<li>Opportunities for profit sharing</li>
</ul>
<p style="text-align: center;"> <strong>ESSENTIAL JOB FUNCTIONS & RESPONSIBILITIES</strong></p>
<p><strong>Event Requirements</strong></p>
<ul>
<li>Assume primary responsibility for planning, coordinating, and executing events</li>
<li>Work with buying team to manage product selection and acquisition</li>
<li>Manage all physical production of relevant marketing and operational materials</li>
<li>Track and report revenue forecasts and actuals, ensuring numbers are ready for each Curdle</li>
<li>Keep detailed event schedule updated on Google Calendar</li>
<li>Communicate event staffing needs to Schedule Manager</li>
</ul>
<p><strong> </strong></p>
<p><strong>Operations Requirements</strong></p>
<ul>
<li>Artistically plates, runs, and describes cheese flights</li>
<li>Assists customers in selecting retail cheese</li>
<li>Provides food and beverage service in a professional manner</li>
<li>Curates an experience for customers at the register, providing suggestions and guidance through the menu</li>
<li>Retains an updated knowledge of all cheese, wine, beer, and food products</li>
<li>Efficiently prepares a variety of foods prior to opening</li>
<li>Cleans and resets for the next day in the closing shift</li>
<li>Keeps the kitchen tidy and sanitary, washing dishes and sanitizing in real time</li>
</ul>
<p> </p>
<p><strong>General Requirements</strong></p>
<ul>
<li>Passionate about good food, especially cheese</li>
<li>Able and excited to curate a culinary experience</li>
<li>Experience working in a fast-paced environment where hustle is required</li>
<li>Handle numerous food tickets in an organized manner</li>
<li>Experience in the artisanal cheese industry is desireable</li>
<li>Hospitality/kitchen/service experience is desireable</li>
<li>Able to lift up to 40 lbs</li>
<li>Must be fluent in English</li>
</ul>
<p> </p>
<p><strong>Interpersonal Requirements</strong></p>
<ul>
<li>Listens and communicates well with staff, managers, and guests</li>
<li>Accepts constructive criticism and makes adjustments accordingly</li>
<li>Is able to perform under pressure</li>
<li>Maintains a positive attitude and productive energy-level</li>
<li>Displays professionalism when assisting guests and communicating with co-workers</li>
<li>Demonstrates a sense of urgency and a commitment to providing excellent product and service to our guests. </li>
</ul>
<p> </p>
<p>We look forward to your application!</p>',
'post_date' => '2019-07-17 19:47:02',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'mission district',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Mission Cheese LLC'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/10621.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="Mission Cheese LLC" alt="Mission Cheese LLC" src="https://d2qez73695kjfi.cloudfront.net/w13620826391386297730_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Mission Cheese LLC</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.missioncheese.net" target="_blank">http://www.missioncheese.net</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="http://www.facebook.com/pages/Mission-Cheese/163537183664350" target="_new" title="Mission Cheese LLC Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
<li>
<a rel="nofollow" href="http://www.twitter.com/@missioncheese" target="_new" title="Mission Cheese LLC Twitter Page">
<img width="32" src="/css/images/twitter-round-large.png" alt="" />
</a>
</li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="Mission Cheese LLC" alt="Mission Cheese LLC" src="http://proven-employer-mobile-images.s3.amazonaws.com/10621.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 17, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46037" job_id="46037" href="/jobs/view/46037" title="Director of Events & Cheesemonger"><strong>Director of Events & Cheesemonger</strong></a>
</h2>
<div class="job-location">Mission District</div>
</div>
<div class="col-xs-12">
<p class="description">Job Summary Mission Cheese is looking for someone to join our team as Director of Events & Cheesemonger. The ideal candidate would have some combination of cheese, wine, beer, and pairing experience and is looking to take their passion to the next level by joining our dynamic team! We pride ourselves...</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
Job Summary Mission Cheese is looking for someone to join our team as Director of Events & Cheesemonger. The ideal candidate would have some combination of cheese, wine, beer, and pairing experience and is looking to take their passion to the next level by joining our dynamic team! We pride ourselves...
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` = 10621 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` = 10621 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` = 10621 LIMIT 1