*/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_90beb37d75699e13b032b2e9a38ec43e' 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_1a245f0288c04b6bb58217a1257f52ef' 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_46a93c9adacd57b7108a6ce3b7004dd9' 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 Custer McDermott Animal Hospital in Plano, 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 Custer McDermott Animal Hospital in <span class='locality'>Plano</span>, <span class='region'>Texas</span>.',
'title_for_layout' => 'Work for Custer McDermott Animal Hospital in Plano, TX',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Custer McDermott Animal Hospital',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Plano',
'state' => 'TX',
'lat' => '33.08290100',
'lon' => '-96.75209808',
'street_address' => '',
'id' => '31152',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '75025',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'Texas'
),
'User' => array(
'email_validated' => '0',
'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 Custer McDermott Animal Hospital',
'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">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Custer McDermott Animal Hospital</h1>
<p class="text-muted">Plano, 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">July 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46053" job_id="46053" href="/jobs/view/46053" title="Veterinary Technician"><strong>Veterinary Technician</strong></a>
</h2>
<div class="job-location">North Dfw</div>
</div>
<div class="col-xs-12">
<p class="description"> Veterinary technicians must have a broad knowledge of animal science, medicine, and husbandry, including a basic knowledge of pharmacology and sufficient mathematical skills to ensure the administration of accurate drug and fluid doses. They must be able to successfully restrain animals,...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">July 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46052" job_id="46052" href="/jobs/view/46052" title="Receptionist"><strong>Receptionist</strong></a>
</h2>
<div class="job-location">North Dfw</div>
</div>
<div class="col-xs-12">
<p class="description"> Receptionists are the customer-relations experts in our veterinary practice. They are the clients’ first impression of the practice, on the phone or in person. Receptionists must possess strong organizational skills, excellent telephone and in-person communication skills, and the ability to...</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 Custer McDermott Animal Hospital in <span class='locality'>Plano</span>, <span class='region'>Texas</span>.'
$title_for_layout = 'Work for Custer McDermott Animal Hospital in Plano, TX'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Custer McDermott Animal Hospital',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Plano',
'state' => 'TX',
'lat' => '33.08290100',
'lon' => '-96.75209808',
'street_address' => '',
'id' => '31152',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '75025',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'Texas'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46053',
'open' => '1',
'title' => 'Veterinary Technician',
'unique_name' => '',
'description' => '<p> Veterinary technicians must have a broad knowledge of animal science, medicine, and husbandry, including a basic knowledge of pharmacology and sufficient mathematical skills to ensure the administration of accurate drug and fluid doses. They must be able to successfully restrain animals, complete clinical laboratory tests, use multiple radiology techniques, administer and monitor animals under anesthesia, assist in surgery, and perform dental procedures. Technicians must also deliver compassionate nursing care.</p>
<p> </p>',
'post_date' => '2019-07-19 22:35:38',
'compensation' => '',
'craigslist_city' => 'dallas / fort worth',
'craigslist_sub_city' => 'north DFW',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Texas'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '46052',
'open' => '1',
'title' => 'Receptionist',
'unique_name' => '',
'description' => '<p> Receptionists are the customer-relations experts in our veterinary practice. They are the clients’ first impression of the practice, on the phone or in person. Receptionists must possess strong organizational skills, excellent telephone and in-person communication skills, and the ability to remain calm under pressure. Receptionists must have compassion for animals and their owners and understand the stress that patients and clients endure. <br /> Receptionists are responsible for greeting clients; differentiating routine cases from emergency cases; scheduling appointments; entering client, patient, and financial data into the computer; generating invoices and explaining them to clients; processing payments; and managing the retrieval and storage of medical records. <br />Receptionists should expect to spend nearly all of their workdays at the front desk. The position requires the completion of a high-school degree or further education, competence in the English language, patience, and a pleasant manner.</p>
<p><br />General Knowledge<br />· Know the range of services the practice provides and the species it treats.<br />· Be reasonably familiar with breeds and coat colors.<br />· Follow OSHA standards. Be able to find Material Safety Data Sheets quickly.<br />· Know standard medical and business abbreviations.<br />· Use proper medical terminology when speaking and writing.<br />· Competently speak and write the English language.<br />· Understand the life cycle and pathology of common parasites (intestinal parasites, heartworms, fleas, ticks), and know the names of most common preventatives, recommended treatments, and diagnostics.<br />· Be familiar with zoonotic (contagious) diseases, including their prevention and steps to reduce or eliminate transmission.<br />· Communicate with clients about the various pet-identification systems available, including tags, tattoos, and microchips.<br />· Know the policies regarding provision of veterinary care, treatment of stray animals, deposits for hospitalized patients, payments, credit, pet health insurance, and finance fees.</p>
<p> </p>
<p>General Tasks</p>
<p>· Always be in position and prepared to work by the start of each scheduled shift.<br />· Maintain accurate personal time cards.<br />· Enter the practice through the front door so that you see what clients see. Routinely pick up trash or feces from the parking lot, sidewalks, or entryway.· Maintain a professional appearance while at work, including clean and pressed uniforms or clothes. Change clothes daily as necessary to look professional and avoid carrying odors.<br />· Smile and maintain an even, friendly demeanor while on the job. <br />· Perform job tasks efficiently without rushing. <br />· Handle stress and pressure with poise and tact.<br />· Show respect for clients, team members, and animals (alive or deceased) at all times.<br />· Prioritize tasks to maximize client satisfaction and patient health.<br />· Maintain a list of tasks and engage in productive work during slow periods.<br />· Assist other employees as needed. Take over for colleagues when they are called away to another priority.<br />· Read and refer to the personnel policy manual for answers to staff policy questions before asking the owner(s) or manager(s).<br />· Participate in your performance appraisal, and, as requested, in those of others.<br />· Participate in all staff and training meetings.<br />· Conduct tours of the practice and/or kennel. Before each tour, ensure that the facility is orderly and that staff and patients are prepared for tours.<br />· Maintain constant vigilance regarding open doorways that could allow pets to escape from the facility.<br />· Maintain strict confidentiality regarding clients and patients for whom the practice provides veterinary services.<br />· Be prepared to handle any facility emergency that may arise, including facility fire or weather-related emergencies. Follow contingency plans.<br />· Follow established closing procedures to ensure the security of patients, staff, data, revenue, inventory, and the facility.</p>',
'post_date' => '2019-07-19 22:25:22',
'compensation' => '',
'craigslist_city' => 'dallas / fort worth',
'craigslist_sub_city' => 'north DFW',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Texas'
)
)
)
$display_company_title = 'Jobs at Custer McDermott Animal Hospital'
$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">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Custer McDermott Animal Hospital</h1>
<p class="text-muted">Plano, 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">July 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46053" job_id="46053" href="/jobs/view/46053" title="Veterinary Technician"><strong>Veterinary Technician</strong></a>
</h2>
<div class="job-location">North Dfw</div>
</div>
<div class="col-xs-12">
<p class="description"> Veterinary technicians must have a broad knowledge of animal science, medicine, and husbandry, including a basic knowledge of pharmacology and sufficient mathematical skills to ensure the administration of accurate drug and fluid doses. They must be able to successfully restrain animals,...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">July 19, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46052" job_id="46052" href="/jobs/view/46052" title="Receptionist"><strong>Receptionist</strong></a>
</h2>
<div class="job-location">North Dfw</div>
</div>
<div class="col-xs-12">
<p class="description"> Receptionists are the customer-relations experts in our veterinary practice. They are the clients’ first impression of the practice, on the phone or in person. Receptionists must possess strong organizational skills, excellent telephone and in-person communication skills, and the ability to...</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
Veterinary technicians must have a broad knowledge of animal science, medicine, and husbandry, including a basic knowledge of pharmacology and sufficient mathematical skills to ensure the administration of accurate drug and fluid doses. They must be able to successfully restrain animals,...
Receptionists are the customer-relations experts in our veterinary practice. They are the clients’ first impression of the practice, on the phone or in person. Receptionists must possess strong organizational skills, excellent telephone and in-person communication skills, and the ability to...
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` = 31152 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` = 31152 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` = 31152 LIMIT 1