*/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_bf267ccfc8be1607f6d16a122a2d8541' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
$key = '_employer_first_bf267ccfc8be1607f6d16a122a2d8541'
$value = array(
'version' => (int) 0,
'data' => array(
'Employer' => array(
'company_name' => 'Tranquility Massage',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Dallas',
'state' => 'TX',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '1919 McKinney Ave',
'id' => '30111',
'about_us' => 'Tranquility Massage is a network of massage therapists throughout the United States that all believe in one thing, that the healing process of any ailment starts with the power of touch.
Our massage therapists are one of a kind and are trained at the top schools for massage therapy.
At Tranquility Massage our therapists keep progress notes in our system on each and every Client they see, we do this so that you can move around the Country or visit other Cities and continue with your therapy progress without having to skip a session or see another therapist who hasn't seen you before which in turn breaks the continuity of care, which can be the most detrimental to your health care.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '75201',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/tranquilitymassage2',
'website' => 'https://TranquilityMassage.services',
'company_logo' => 'w15418722891149965444_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'Texas'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
)
$config = 'default'
$settings = array(
'prefix' => '*****',
'engine' => 'Memcache',
'duration' => (int) 3600,
'probability' => (int) 100,
'servers' => array(
(int) 0 => 'proven-cache.kmvdqz.cfg.use1.cache.amazonaws.com:11211'
),
'compress' => false,
'persistent' => true,
'groups' => array()
)
$success = false
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_744aecbaa715c1a0b1730737e25013d1' 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_602ed547484979e5f989ae8e2f779493' 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 Tranquility Massage in Dallas, 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 Tranquility Massage in <span class='locality'>Dallas</span>, <span class='region'>Texas</span>.',
'title_for_layout' => 'Work for Tranquility Massage in Dallas, TX',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Tranquility Massage',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Dallas',
'state' => 'TX',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '1919 McKinney Ave',
'id' => '30111',
'about_us' => 'Tranquility Massage is a network of massage therapists throughout the United States that all believe in one thing, that the healing process of any ailment starts with the power of touch.
Our massage therapists are one of a kind and are trained at the top schools for massage therapy.
At Tranquility Massage our therapists keep progress notes in our system on each and every Client they see, we do this so that you can move around the Country or visit other Cities and continue with your therapy progress without having to skip a session or see another therapist who hasn't seen you before which in turn breaks the continuity of care, which can be the most detrimental to your health care.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '75201',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/tranquilitymassage2',
'website' => 'https://TranquilityMassage.services',
'company_logo' => 'w15418722891149965444_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'Texas'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Tranquility Massage',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w1541872451501015936_small.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="Tranquility Massage" alt="Tranquility Massage" src="https://d2qez73695kjfi.cloudfront.net/w15418722891149965444_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Tranquility Massage</h1>
<p class="text-muted">Dallas, TX</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="https://TranquilityMassage.services" target="_blank">https://TranquilityMassage.services</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/tranquilitymassage2" target="_new" title="Tranquility Massage 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="Tranquility Massage" alt="Tranquility Massage" src="http://proven-employer-mobile-images.s3.amazonaws.com/w1541872451501015936_small.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">November 10, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44557" job_id="44557" href="/jobs/view/44557" title="Licensed Massage Therapist"><strong>Licensed Massage Therapist</strong></a>
</h2>
<div class="job-location">Reno / Tahoe</div>
</div>
<div class="col-xs-12">
<p class="description">Seeking massage therapists who believe in the power of healing through touch. Tranquility offers two types of services to our Clients, office and mobile. We are seeking therapists who either have their own office or the power to make the power of massage happen on the field through mobile services....</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Tranquility Massage is a network of massage therapists throughout the United States that all believe in one thing, that the healing process of any ailment starts with the power of touch.<br />
<br />
Our massage therapists are one of a kind and are trained at the top schools for massage therapy.<br />
<br />
At Tranquility Massage our therapists keep progress notes in our system on each and every Client they see, we do this so that you can move around the Country or visit other Cities and continue with your therapy progress without having to skip a session or see another therapist who hasn't seen you before which in turn breaks the continuity of care, which can be the most detrimental to your health care.</p>
</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 Tranquility Massage in <span class='locality'>Dallas</span>, <span class='region'>Texas</span>.'
$title_for_layout = 'Work for Tranquility Massage in Dallas, TX'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Tranquility Massage',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Dallas',
'state' => 'TX',
'lat' => '0.00000000',
'lon' => '0.00000000',
'street_address' => '1919 McKinney Ave',
'id' => '30111',
'about_us' => 'Tranquility Massage is a network of massage therapists throughout the United States that all believe in one thing, that the healing process of any ailment starts with the power of touch.
Our massage therapists are one of a kind and are trained at the top schools for massage therapy.
At Tranquility Massage our therapists keep progress notes in our system on each and every Client they see, we do this so that you can move around the Country or visit other Cities and continue with your therapy progress without having to skip a session or see another therapist who hasn't seen you before which in turn breaks the continuity of care, which can be the most detrimental to your health care.',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '75201',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/tranquilitymassage2',
'website' => 'https://TranquilityMassage.services',
'company_logo' => 'w15418722891149965444_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'Texas'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '44557',
'open' => '1',
'title' => 'Licensed Massage Therapist',
'unique_name' => '',
'description' => '<p>Seeking massage therapists who believe in the power of healing through touch. Tranquility offers two types of services to our Clients, office and mobile. We are seeking therapists who either have their own office or the power to make the power of massage happen on the field through mobile services. The average pay is between $37 to $63 per hour.</p>',
'post_date' => '2018-11-10 17:59:32',
'compensation' => '',
'craigslist_city' => 'reno / tahoe',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Nevada'
)
)
)
$display_company_title = 'Jobs at Tranquility Massage'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w1541872451501015936_small.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="Tranquility Massage" alt="Tranquility Massage" src="https://d2qez73695kjfi.cloudfront.net/w15418722891149965444_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Tranquility Massage</h1>
<p class="text-muted">Dallas, TX</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="https://TranquilityMassage.services" target="_blank">https://TranquilityMassage.services</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/tranquilitymassage2" target="_new" title="Tranquility Massage 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="Tranquility Massage" alt="Tranquility Massage" src="http://proven-employer-mobile-images.s3.amazonaws.com/w1541872451501015936_small.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">November 10, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44557" job_id="44557" href="/jobs/view/44557" title="Licensed Massage Therapist"><strong>Licensed Massage Therapist</strong></a>
</h2>
<div class="job-location">Reno / Tahoe</div>
</div>
<div class="col-xs-12">
<p class="description">Seeking massage therapists who believe in the power of healing through touch. Tranquility offers two types of services to our Clients, office and mobile. We are seeking therapists who either have their own office or the power to make the power of massage happen on the field through mobile services....</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Tranquility Massage is a network of massage therapists throughout the United States that all believe in one thing, that the healing process of any ailment starts with the power of touch.<br />
<br />
Our massage therapists are one of a kind and are trained at the top schools for massage therapy.<br />
<br />
At Tranquility Massage our therapists keep progress notes in our system on each and every Client they see, we do this so that you can move around the Country or visit other Cities and continue with your therapy progress without having to skip a session or see another therapist who hasn't seen you before which in turn breaks the continuity of care, which can be the most detrimental to your health care.</p>
</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
Seeking massage therapists who believe in the power of healing through touch. Tranquility offers two types of services to our Clients, office and mobile. We are seeking therapists who either have their own office or the power to make the power of massage happen on the field through mobile services....
About Us
Tranquility Massage is a network of massage therapists throughout the United States that all believe in one thing, that the healing process of any ailment starts with the power of touch.
Our massage therapists are one of a kind and are trained at the top schools for massage therapy.
At Tranquility Massage our therapists keep progress notes in our system on each and every Client they see, we do this so that you can move around the Country or visit other Cities and continue with your therapy progress without having to skip a session or see another therapist who hasn't seen you before which in turn breaks the continuity of care, which can be the most detrimental to your health care.
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` = 30111 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` = 30111 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` = 30111 LIMIT 1