*/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_089fb65734aaa9810cd5c159040c283a' 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_14174d05dfb27e6554fb9dcfdb2b60e6' 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_cfab841057252d1da97317ac4c0b81df' 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 Amici's - Dublin in Dublin, 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 Amici's - Dublin in <span class='locality'>Dublin</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Amici's - Dublin in Dublin, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Amici's - Dublin',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Dublin',
'state' => 'CA',
'lat' => '37.71419907',
'lon' => '-121.93099976',
'street_address' => '4640 Tassajara Road',
'id' => '12121',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94568',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://www.amicis.com/location_details.asp?id=3&d=Dublin',
'company_logo' => 'w1391827300325375758_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 Amici's - Dublin',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/12121.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="Amici's - Dublin" alt="Amici's - Dublin" src="https://d2qez73695kjfi.cloudfront.net/w1391827300325375758_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Amici's - Dublin</h1>
<p class="text-muted">Dublin, 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.amicis.com/location_details.asp?id=3&d=Dublin" target="_blank">http://www.amicis.com/location_details.asp?id=3&d=Dublin</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Amici's - Dublin" alt="Amici's - Dublin" src="http://proven-employer-mobile-images.s3.amazonaws.com/12121.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">October 01, 2015</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="17274" job_id="17274" href="/jobs/view/17274" title="Servers - NO Tipping Out & FREE MEALS!"><strong>Servers - NO Tipping Out & FREE MEALS!</strong></a>
</h2>
<div class="job-location">East Bay Area</div>
</div>
<div class="col-xs-12">
<p class="description">Are you ready to UPGRADE from an ordinary job to a GREAT CAREER?AMICI'S PROMOTES FROM WITHIN, OFFERING EXCELLENT OPPORTUNITIES FOR ADVANCEMENT. Our wages are among the best in the industry, and we offer flexible schedules in a FUN working environment. =====================We are currently taking applications...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">October 01, 2015</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="14598" job_id="14598" href="/jobs/view/14598" title="Hiring KITCHEN STAFF- Free meals and top pay!"><strong>Hiring KITCHEN STAFF- Free meals and top pay!</strong></a>
</h2>
<div class="job-location">East Bay Area</div>
</div>
<div class="col-xs-12">
<p class="description">Hiring for FT/PT Pizza Cooks, Dishwashers & Line Cooks Where: Amici’s @ 4640 Tassajara Rd. in Dublin On-the-spot interviews will be conducted. Candidates may be asked to demonstrate cooking skills. Ideal candidates will have a great attitude, be customer-focused, work...</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 Amici's - Dublin in <span class='locality'>Dublin</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Amici's - Dublin in Dublin, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Amici's - Dublin',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Dublin',
'state' => 'CA',
'lat' => '37.71419907',
'lon' => '-121.93099976',
'street_address' => '4640 Tassajara Road',
'id' => '12121',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94568',
'yelp_page' => '',
'facebook_page' => '',
'website' => 'http://www.amicis.com/location_details.asp?id=3&d=Dublin',
'company_logo' => 'w1391827300325375758_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '17274',
'open' => '1',
'title' => 'Servers - NO Tipping Out & FREE MEALS!',
'unique_name' => 'servers---no-tipping-out--free-meals-dublin-california',
'description' => '<p>Are you ready to UPGRADE from an ordinary job to a GREAT CAREER?<br /><br />AMICI'S PROMOTES FROM WITHIN, OFFERING EXCELLENT OPPORTUNITIES FOR ADVANCEMENT. <br /><br />Our wages are among the best in the industry, and we offer flexible schedules in a FUN working environment. <br /><br /><br />=====================<br />We are currently taking applications for: <br /><br />FOOD SERVERS (full- and part-time) to provide attentive and friendly service to guests. Duties include taking orders, serving food, bussing tables (Amici's servers DON'T TIP OUT!), stocking, light cleaning and restaurant setup and breakdown.<br /><br />The RIGHT CANDIDATES will be HONEST, OUTGOING, UPBEAT, and TEAM ORIENTED, as well as able to prioritize simultaneous tasks. Candidates should also be able to move with urgency, have a positive attitude and possess a friendly SMILE. Highly prefer food servers with experience in high volume restaurants. <br /><br />***** HIGH VOLUME + NO TIPPING OUT = GREAT EARNING POTENTIAL!! *****<br /><br />=====================<br /><br />Must be at least 21 years old to apply.<br /><br />Night & weekend availability a must. </p>
<p>Please apply in person at 4640 Tassajara Road in Dublin.</p>',
'post_date' => '2015-10-01 19:31:11',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'east bay area',
'craigslist_sub_sub_city' => 'bypass this step',
'craigslist_state' => 'California'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '14598',
'open' => '1',
'title' => 'Hiring KITCHEN STAFF- Free meals and top pay!',
'unique_name' => 'amicis-job-fair--hiring-pizza-makers-line-cooks--dishwashers-dublin-california',
'description' => '<p><strong>Hiring for FT/PT </strong>Pizza Cooks, Dishwashers & Line Cooks</p>
<p> </p>
<p><strong>Where:</strong> Amici’s @ 4640 Tassajara Rd. in Dublin</p>
<p> </p>
<p><strong>On-the-spot interviews will be conducted.</strong> Candidates may be asked to demonstrate cooking skills.</p>
<p> </p>
<p>Ideal candidates will have a great attitude, be customer-focused, work hard and take pride in his/her work.</p>
<p> </p>
<p><strong>Great Pay! Flexible Schedules! Free Meals!</strong></p>',
'post_date' => '2015-10-01 19:30:35',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'east bay area',
'craigslist_sub_sub_city' => 'bypass this step',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Amici's - Dublin'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/12121.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="Amici's - Dublin" alt="Amici's - Dublin" src="https://d2qez73695kjfi.cloudfront.net/w1391827300325375758_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Amici's - Dublin</h1>
<p class="text-muted">Dublin, 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.amicis.com/location_details.asp?id=3&d=Dublin" target="_blank">http://www.amicis.com/location_details.asp?id=3&d=Dublin</a></p>
</div>
</div>
<hr />
<div class="company-image">
<img title="Amici's - Dublin" alt="Amici's - Dublin" src="http://proven-employer-mobile-images.s3.amazonaws.com/12121.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">October 01, 2015</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="17274" job_id="17274" href="/jobs/view/17274" title="Servers - NO Tipping Out & FREE MEALS!"><strong>Servers - NO Tipping Out & FREE MEALS!</strong></a>
</h2>
<div class="job-location">East Bay Area</div>
</div>
<div class="col-xs-12">
<p class="description">Are you ready to UPGRADE from an ordinary job to a GREAT CAREER?AMICI'S PROMOTES FROM WITHIN, OFFERING EXCELLENT OPPORTUNITIES FOR ADVANCEMENT. Our wages are among the best in the industry, and we offer flexible schedules in a FUN working environment. =====================We are currently taking applications...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">October 01, 2015</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="14598" job_id="14598" href="/jobs/view/14598" title="Hiring KITCHEN STAFF- Free meals and top pay!"><strong>Hiring KITCHEN STAFF- Free meals and top pay!</strong></a>
</h2>
<div class="job-location">East Bay Area</div>
</div>
<div class="col-xs-12">
<p class="description">Hiring for FT/PT Pizza Cooks, Dishwashers & Line Cooks Where: Amici’s @ 4640 Tassajara Rd. in Dublin On-the-spot interviews will be conducted. Candidates may be asked to demonstrate cooking skills. Ideal candidates will have a great attitude, be customer-focused, work...</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
Are you ready to UPGRADE from an ordinary job to a GREAT CAREER?AMICI'S PROMOTES FROM WITHIN, OFFERING EXCELLENT OPPORTUNITIES FOR ADVANCEMENT. Our wages are among the best in the industry, and we offer flexible schedules in a FUN working environment. =====================We are currently taking applications...
Hiring for FT/PT Pizza Cooks, Dishwashers & Line Cooks Where: Amici’s @ 4640 Tassajara Rd. in Dublin On-the-spot interviews will be conducted. Candidates may be asked to demonstrate cooking skills. Ideal candidates will have a great attitude, be customer-focused, work...
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` = 12121 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` = 12121 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` = 12121 LIMIT 1