*/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_3022badf39b4f44bd857285473f9eb6e' 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_1e5786e3451ca2958c2b8609d85b1937' 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_3e8193af29278a42dbec787c03972f6e' 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 Piatti - Quarry in San Antonio, TXWarning (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 Piatti - Quarry in <span class='locality'>San Antonio</span>, <span class='region'>Texas</span>.',
'title_for_layout' => 'Work for Piatti - Quarry in San Antonio, TX',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Piatti - Quarry',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Antonio',
'state' => 'TX',
'lat' => '29.48769951',
'lon' => '-98.45649719',
'street_address' => '',
'id' => '14997',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '78209',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w14587694931031717370_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'Texas'
),
'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 Piatti - Quarry',
'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="Piatti - Quarry" alt="Piatti - Quarry" src="https://d2qez73695kjfi.cloudfront.net/w14587694931031717370_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Piatti - Quarry</h1>
<p class="text-muted">San Antonio, TX</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">August 07, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46170" job_id="46170" href="/jobs/view/46170" title="Line Cooks - We're Interviewing Now at Piatti - Quarry!"><strong>Line Cooks - We're Interviewing Now at Piatti - Quarry!</strong></a>
</h2>
<div class="job-location">San Antonio</div>
</div>
<div class="col-xs-12">
<p class="description">Come Join our Team at Piatti - Quarry! Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 07, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46169" job_id="46169" href="/jobs/view/46169" title="*Now Hiring* DISHWASHERS at Piatti - Alamo Quarry Market!!"><strong>*Now Hiring* DISHWASHERS at Piatti - Alamo Quarry Market!!</strong></a>
</h2>
<div class="job-location">San Antonio</div>
</div>
<div class="col-xs-12">
<p class="description">Come Join our Team at Piatti - Quarry! Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which...</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 Piatti - Quarry in <span class='locality'>San Antonio</span>, <span class='region'>Texas</span>.'
$title_for_layout = 'Work for Piatti - Quarry in San Antonio, TX'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Piatti - Quarry',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Antonio',
'state' => 'TX',
'lat' => '29.48769951',
'lon' => '-98.45649719',
'street_address' => '',
'id' => '14997',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '78209',
'yelp_page' => '',
'facebook_page' => '',
'website' => '',
'company_logo' => 'w14587694931031717370_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'Texas'
),
'User' => array(
'email_validated' => '1',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46170',
'open' => '1',
'title' => 'Line Cooks - We're Interviewing Now at Piatti - Quarry!',
'unique_name' => '',
'description' => '<h2 style="text-align: center;"><strong>Come Join our Team at Piatti - Quarry!</strong></h2>
<div>Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which are served via our barrel-to-table program - a comprehensive offering of craft beers and unique, artisan cocktails.</div>
<p>Piatti is nestled among a fabulous collection of unique boutiques and retail shops in the hip Alamo Quarry Market, a brief 10 minutes from downtown and the popular San Antonio River Walk. The uniqueness of this vibrant area also translates on our menu where you’ll find market-inspired, rustic Italian cuisine coupled with incredibly friendly, inviting service in a warm and welcoming environment.</p>
<p>Piatti's Management accommodates flexible schedules for School, provides free Shift Meals, and have a strong focus on food and beverage training.</p>
<p>If joining a team of talented and passionate hospitality and culinary professionals is attractive to you – this just might be the place for you!</p>
<div style="text-align: left;">
<div> </div>
</div>
<div style="text-align: left;"><strong>We are currently interviewing for fast, dependable Line Cooks to join our growing kitchen team!</strong></div>
<div style="text-align: left;">
<div> </div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<p><strong>The Line Cook</strong> will set up their workstation with required tools, equipment and supplies according to standards. You will prepare and produce menu items for the restaurant following recipes and yield guides, and proper plate presentation and garnish for all dishes you produce. You will maintain the organization, cleanliness and sanitation of your work areas and equipment.</p>
<div>
<div> </div>
</div>
<p><strong>MINIMUM QUALIFICATIONS:</strong></p>
<ul>
<li>Two years’ restaurant experience, but will train the right person</li>
<li>Two years’ experience in a food preparation position, or similar experience. </li>
<li>Food Handler Certification</li>
</ul>
</div>
<div>
<div> </div>
</div>
</div>
<div>Piatti is part of Moana Restaurant Group’s collection of restaurants and hotels, one of the West's leading restaurant companies, operating over 30 unique restaurants and hotels with opportunities for career growth and advancement.</div>
<div> </div>',
'post_date' => '2019-08-08 00:03:05',
'compensation' => '',
'craigslist_city' => 'san antonio',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Texas'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '46169',
'open' => '1',
'title' => '*Now Hiring* DISHWASHERS at Piatti - Alamo Quarry Market!!',
'unique_name' => '',
'description' => '<h2 style="text-align: center;"><strong>Come Join our Team at Piatti - Quarry!</strong></h2>
<div>Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which are served via our barrel-to-table program - a comprehensive offering of craft beers and unique, artisan cocktails.</div>
<p>Piatti is nestled among a fabulous collection of unique boutiques and retail shops in the hip Alamo Quarry Market, a brief 10 minutes from downtown and the popular San Antonio River Walk. The uniqueness of this vibrant area also translates on our menu where you’ll find market-inspired, rustic Italian cuisine coupled with incredibly friendly, inviting service in a warm and welcoming environment.</p>
<p>Piatti's Management accommodates flexible schedules for School, provides free Shift Meals, and have a strong focus on food and beverage training.</p>
<p>If joining a team of talented and passionate hospitality and culinary professionals is attractive to you – this just might be the place for you!</p>
<div style="text-align: left;">
<div> </div>
</div>
<div style="text-align: left;"><strong>We are currently interviewing for fast, dependable Dishwashers to join our growing kitchen team!</strong></div>
<div style="text-align: left;">
<div> </div>
</div>
<div style="text-align: left;">
<p><strong>Responsibilities include</strong>:</p>
<ul>
<li>Keeping service and cookware clean</li>
<li>Maintaining cleanliness of floors and surfaces</li>
<li>Assisting cooks with food prep</li>
<li>Other maintenance tasks</li>
</ul>
<p>Must be able to communicate and comprehend instructions in English. The dishwasher should be able to work a flexible schedule.</p>
<div>
<div> </div>
</div>
</div>
<div>Piatti is part of Moana Restaurant Group’s collection of restaurants and hotels, one of the West's leading restaurant companies, operating over 30 unique restaurants and hotels with opportunities for career growth and advancement.</div>
<div> </div>',
'post_date' => '2019-08-07 23:44:50',
'compensation' => '',
'craigslist_city' => 'san antonio',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Texas'
)
)
)
$display_company_title = 'Jobs at Piatti - Quarry'
$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="Piatti - Quarry" alt="Piatti - Quarry" src="https://d2qez73695kjfi.cloudfront.net/w14587694931031717370_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Piatti - Quarry</h1>
<p class="text-muted">San Antonio, TX</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">August 07, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46170" job_id="46170" href="/jobs/view/46170" title="Line Cooks - We're Interviewing Now at Piatti - Quarry!"><strong>Line Cooks - We're Interviewing Now at Piatti - Quarry!</strong></a>
</h2>
<div class="job-location">San Antonio</div>
</div>
<div class="col-xs-12">
<p class="description">Come Join our Team at Piatti - Quarry! Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 07, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46169" job_id="46169" href="/jobs/view/46169" title="*Now Hiring* DISHWASHERS at Piatti - Alamo Quarry Market!!"><strong>*Now Hiring* DISHWASHERS at Piatti - Alamo Quarry Market!!</strong></a>
</h2>
<div class="job-location">San Antonio</div>
</div>
<div class="col-xs-12">
<p class="description">Come Join our Team at Piatti - Quarry! Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which...</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
Come Join our Team at Piatti - Quarry! Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which...
Come Join our Team at Piatti - Quarry! Piatti features Italian-inspired, seasonally-dictated cuisine with an emphasis on local farms and producers. Our philosophy is simple: combine rustic, flavorful cuisine with simple, unpretentious design, an approachable and interesting wine list - many of which...
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` = 14997 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` = 14997 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` = 14997 LIMIT 1