*/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_bc440551c3f73435f22e6d1d44af15a4' 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_93f5988ccaba8ebae3b1e3a5a03dce13' 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_ff79daa1e9eedd96f75db6abde4ecf15' 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 Palm House 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 Palm House in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Palm House in San Francisco, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Palm House',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '2032 Union Street',
'id' => '22251',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94123',
'yelp_page' => '',
'facebook_page' => 'facebook.com/palmhousesf',
'website' => 'http://www.palmhousesf.com',
'company_logo' => 'w1509577676533197317_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Palm House',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w15095779971097232365_small.png',
'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="Palm House" alt="Palm House" src="https://d2qez73695kjfi.cloudfront.net/w1509577676533197317_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Palm House</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.palmhousesf.com" target="_blank">http://www.palmhousesf.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="http://facebook.com/palmhousesf" target="_new" title="Palm House Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="Palm House" alt="Palm House" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15095779971097232365_small.png" 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 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46062" job_id="46062" href="/jobs/view/46062" title="Servers and Bussers - We Are Hiring Now!"><strong>Servers and Bussers - We Are Hiring Now!</strong></a>
</h2>
<div class="job-location">Marina / Cow Hollow</div>
</div>
<div class="col-xs-12">
<p class="description">Looking for awesome and efficient Servers & Bussers to join our team!! Cocina amistosa que habla español! Palm House is the staycation destination of San Francisco serving tropical food and vacation drinks. Housed in the original 1854 dairy farmhouse where Cow Hollow derives its name...</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 Palm House in <span class='locality'>San Francisco</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Palm House in San Francisco, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Palm House',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'San Francisco',
'state' => 'CA',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '2032 Union Street',
'id' => '22251',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94123',
'yelp_page' => '',
'facebook_page' => 'facebook.com/palmhousesf',
'website' => 'http://www.palmhousesf.com',
'company_logo' => 'w1509577676533197317_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46062',
'open' => '1',
'title' => 'Servers and Bussers - We Are Hiring Now!',
'unique_name' => '',
'description' => '<p>Looking for awesome and efficient Servers & Bussers to join our team!!</p>
<p>Cocina amistosa que habla español! </p>
<p>Palm House is the staycation destination of San Francisco serving tropical food and vacation drinks. Housed in the original 1854 dairy farmhouse where Cow Hollow derives its name and situated behind the second oldest palm tree in San Francisco, Palm House evokes a bygone era of tropical leisure. Palm House invites you to experience its bold flavors, tropical eats, quixotic drinks and humble service in the spirit of the old adage, "It's happy hour somewhere”.</p>
<p>Our menus tap the spice trail, heat and vibe of the tropics while maintaining a California point of view. Anywhere there’s a palm tree is fair sights for our culinary adventures. Our beverage program is a playful exploration of vacation inspired cocktails designed to transport you to the beach.</p>
<p>We are looking for someone that is motivated, hospitable and fun to work with. You should be comfortable in a high-volume environment for our bustling lunch, dinner and bar scene. Someone who spreads good vibes is a must! :)</p>
<p><strong>Busser Job Overview: </strong>Clear dirty dishes from dining tables and reset tables. Remove all dirty wares to the dish station in the kitchen and rack accordingly. Maintain side stations in a clean, organized and stocked manner. Assist servers in any way possible to ensure proper, prompt and courteous service to all guests. Deliver food and beverage orders to restaurant, and bar areas. Assist in the maintenance and cleaning of the kitchen, restaurant, and bar areas.</p>
<p><strong>Server Job Overview: </strong>Take food and beverage orders, record orders in the POS system in a timely manner. Deliver food and beverage orders to restaurant and bar areas. Assist in the maintenance and cleaning of the restaurant and bar areas. Wait on tables promptly and courteously in adherence to standards of service. Provide guest service in accordance to company policy and standard. Assist in the control of beverage and operating supply costs. Deliver prompt, courteous service according to service and operating standards. </p>
<p> <strong>Busser Qualifications/Skills:</strong></p>
<p>Requirements are representative of minimum levels of knowledge, skills and /or abilities. To perform this job successfully, the employee will possess the abilities or aptitudes to perform each duty proficiently with or without reasonable accommodation.</p>
<p> Essential:</p>
<ul>
<li>Ability to satisfactorily communicate in English (speak, read, write) with guests, co-workers and management to their understanding.</li>
<li>Minimum of 18 years of age to serve alcoholic beverages </li>
<li>Previous experience in food and beverage.</li>
<li>Punctuality and regular and reliable attendance.</li>
<li>Ability to perform assigned duties with attention to detail, speed, accuracy, follow-through, courtesy, cooperation, and work with a minimum of supervision.</li>
<li>Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.</li>
<li>Ability to effectively deal with internal and external customers, some of whom will require high levels of patience, tact, and diplomacy to defuse anger.</li>
<li>Ability to work well under pressure and handle multiple tasks at once.</li>
<li>Ability to maintain concentration and a well organized work environment as well as the ability to think clearly.</li>
<li>Interpersonal skills and the ability to work well with co-workers and the public.</li>
</ul>
<p> Desirable:</p>
<ul>
<li>High School graduate</li>
<li>Food handling certificate/Serv-Safe certificate </li>
<li>Knowledge of American style service standards</li>
<li>Alcohol awareness certification (TIPS Training) </li>
</ul>
<p><strong>Server Qualifications/Skills:</strong></p>
<p>Requirements are representative of minimum levels of knowledge, skills and /or abilities. To perform this job successfully, the employee will possess the abilities or aptitudes to perform each duty proficiently with or without reasonable accommodation. </p>
<p> Essential:</p>
<ul>
<li>Ability to satisfactorily communicate in English (speak, read, write) with guests, co-workers and management to their understanding.</li>
<li>Minimum of 21 years of age to serve alcoholic beverages.</li>
<li>Two years experience in four- or five-star establishments with proven knowledge of fine wines, beer, and liquor.</li>
<li>Punctuality; regular and reliable attendance.</li>
<li>Ability to perform assigned duties with attention to detail, speed, accuracy, follow-through, courtesy, cooperation, and work with a minimum of supervision.</li>
<li>Ability to accurately compute and manipulate mathematical calculations.</li>
<li>Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.</li>
<li>Ability to effectively deal with internal and external customers, some of whom will require high levels of patience, tact and diplomacy to defuse anger.</li>
<li>Ability to work well under pressure and handle multiple tasks at once.</li>
<li>Ability to maintain concentration and a well organized work environment as well as the ability to think clearly.</li>
<li>Interpersonal skills and the ability to work well with co-workers and the public.</li>
<li>Ability to thoroughly describe and sell all menu items.</li>
<li>Ability to comfortably learn and communicate daily menu specials</li>
<li>Understanding of menu ingredients and cooking techniques </li>
</ul>
<p> Desirable:</p>
<ul>
<li>High School graduate</li>
<li>Food handling certification/Serv-Safe certificate.</li>
<li>Alcohol awareness certification (TIPS Training)</li>
<li>Knowledge of P.O.S. system, preferably Micros</li>
<li>Extensive experience in a fine dining environment</li>
</ul>
<p><strong>Essential Physical Abilities:</strong></p>
<ul>
<li>Endure various physical actions throughout the work areas, such as reaching, bending and stooping.</li>
<li>Ability to stand and/or walk continuously throughout the shift to perform essential job functions.</li>
<li>Sufficient manual dexterity to be able to grasp, load, and carry trays.</li>
<li>Ability to endure repetitive motions for extended periods of time.</li>
<li>Ability to maintain good coordination while serving orders quickly.</li>
<li>Ability to grasp, bend, and stoop; push or pull heavy loads weighing up to 50 lbs.; and lift and/or carry or otherwise move packages, and boxes.</li>
</ul>
<p> </p>',
'post_date' => '2019-07-22 07:28:48',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'city of san francisco',
'craigslist_sub_sub_city' => 'marina / cow hollow',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Palm House'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w15095779971097232365_small.png'
$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="Palm House" alt="Palm House" src="https://d2qez73695kjfi.cloudfront.net/w1509577676533197317_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Palm House</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.palmhousesf.com" target="_blank">http://www.palmhousesf.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="http://facebook.com/palmhousesf" target="_new" title="Palm House Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="Palm House" alt="Palm House" src="http://proven-employer-mobile-images.s3.amazonaws.com/w15095779971097232365_small.png" 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 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46062" job_id="46062" href="/jobs/view/46062" title="Servers and Bussers - We Are Hiring Now!"><strong>Servers and Bussers - We Are Hiring Now!</strong></a>
</h2>
<div class="job-location">Marina / Cow Hollow</div>
</div>
<div class="col-xs-12">
<p class="description">Looking for awesome and efficient Servers & Bussers to join our team!! Cocina amistosa que habla español! Palm House is the staycation destination of San Francisco serving tropical food and vacation drinks. Housed in the original 1854 dairy farmhouse where Cow Hollow derives its name...</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
Looking for awesome and efficient Servers & Bussers to join our team!! Cocina amistosa que habla español! Palm House is the staycation destination of San Francisco serving tropical food and vacation drinks. Housed in the original 1854 dairy farmhouse where Cow Hollow derives its name...
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` = 22251 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` = 22251 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` = 22251 LIMIT 1