*/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_3f5d1301053106d43e46c07cf2aa3752' 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_13460c7d536f382b4874612bcac4fa25' 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_614b0430e67cc148b670ed2262e71f0e' 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 Guardian Hospice in Winnetka, ILWarning (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 Guardian Hospice in <span class='locality'>Winnetka</span>, <span class='region'>Illinois</span>.',
'title_for_layout' => 'Work for Guardian Hospice in Winnetka, IL',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Guardian Hospice',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Winnetka',
'state' => 'IL',
'lat' => '42.10110092',
'lon' => '-87.75759888',
'street_address' => '',
'id' => '30328',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '60093',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'Illinois'
),
'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 Guardian Hospice',
'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>Guardian Hospice</h1>
<p class="text-muted">Winnetka, IL</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">January 09, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44887" job_id="44887" href="/jobs/view/44887" title="Customer Service Representative - We are hiring now!"><strong>Customer Service Representative - We are hiring now!</strong></a>
</h2>
<div class="job-location">City Of Chicago</div>
</div>
<div class="col-xs-12">
<p class="description">A Customer Service Representative will be primarily responsible for customer phone support, processing of requests, researching and analyzing problems to determine accurate and prompt resolution of any issues that arise, and relaying necessary information to the customers, reps or Client by both verbal...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">January 08, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44866" job_id="44866" href="/jobs/view/44866" title="Registered Nurse"><strong>Registered Nurse</strong></a>
</h2>
<div class="job-location">City Of Chicago</div>
</div>
<div class="col-xs-12">
<p class="description">At Guardian Hospice, we are always looking for dedicated people to become members of our caring team. The majority of our staff stay with our organization for a very long time, for they appreciate the way they are treated. We have created a family environment that promotes respect, support, understanding,...</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 Guardian Hospice in <span class='locality'>Winnetka</span>, <span class='region'>Illinois</span>.'
$title_for_layout = 'Work for Guardian Hospice in Winnetka, IL'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Guardian Hospice',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Winnetka',
'state' => 'IL',
'lat' => '42.10110092',
'lon' => '-87.75759888',
'street_address' => '',
'id' => '30328',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '60093',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'Illinois'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '44887',
'open' => '1',
'title' => 'Customer Service Representative - We are hiring now!',
'unique_name' => '',
'description' => '<p>A Customer Service Representative will be primarily responsible for customer phone support, processing of requests, researching and analyzing problems to determine accurate and prompt resolution of any issues that arise, and relaying necessary information to the customers, reps or Client by both verbal and written communication.<br /><br />Responsibilities:<br />• Phone support of customers, by answering questions and responding to needs<br />• Accurately and timely process customer requests that are received by mail, phone, fax or email<br />• Researches and analyses issues to ensure successful outcomes and resolution<br />• Develops relationships with clients and customers by becoming a dedicated resource<br />Ensure quality and consistent processing and service<br />• Develops broad understanding of products, services, policies, procedures, regulations and laws for effective service delivery<br /><br />Job Requirements<br />Qualifications:<br /><br />High school diploma or equivalent required college degree and prior financial service experience preferred.<br /><br />Experience providing customer service and transaction processing support to clients<br /><br />Work history which demonstrates personal growth and aptitude for advancement<br /><br />Strong PC and keyboarding skills and the ability to use Microsoft Office products and auxiliary equipment and software<br /><br />Incumbents must be able to work required overtime</p>',
'post_date' => '2019-01-10 01:19:31',
'compensation' => '',
'craigslist_city' => 'chicago',
'craigslist_sub_city' => 'city of chicago',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Illinois'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '44866',
'open' => '1',
'title' => 'Registered Nurse',
'unique_name' => '',
'description' => '<p>At Guardian Hospice, we are always looking for dedicated people to become members of our caring team. The majority of our staff stay with our organization for a very long time, for they appreciate the way they are treated. We have created a family environment that promotes respect, support, understanding, high ethical values, and love. These same principles are the foundation of our program for the people we serve.<br /><br />Responsibilities<br /><br />The nurse provides skilled professional nursing care to the patient as prescribed by the physician and maintains compliance with regulations and standards established by CMS, CHAP; and standards of professional practice established by the State Board of Nursing, and the American Nursing Association. Follows agency policies and procedures at all times.<br /><br />Essential Job Expectations and Procedural Responsibilities:<br /><br />1. Initial and ongoing comprehensive assessments of the client’s needs, including Outcome and Assessment Information Set (OASIS) assessments at appropriate time points.<br /><br />2. Initiating the plan of care and revising as necessary<br /><br />3. Providing those services and/or treatments requiring substantial and specialized nursing skill<br /><br />4. Counseling the patient and family in meeting nursing related needs<br /><br />5. Initiating appropriate preventative and rehabilitative nursing procedures<br /><br />6. Preparing clinical progress notes<br /><br />7. Coordination of services including on-call rotation, week days, weekends and holidays<br /><br />8. Referral to other services as needed<br /><br />9. Informing the physician and other staff of changes in the patient’s needs<br /><br />10. Evaluating and appropriately documenting outcomes of care<br /><br />11. Supervising LVN/LPN and paraprofessionals providing services at appropriate time frames.<br /><br />12. Assessing client needs and assigning, preparing POC for home health aide specific for patients.<br /><br />13. Participating in in-service programs, mandatory meetings, and training programs as required by Agency<br /><br />14. Planning for the discharge/recert from service<br /><br />15. Utilizes the Clinical Supervisor as the first resource when problems or questions occur in the field, including charting guidelines, coordination of disciplines, and supervision of home health aide services.<br /><br />16. Participates in quarterly utilization review and chart audits (peer and self) for OBQI/OBQM as requested by Agency.<br /><br />17. Maintains Agency property, supplies and equipment in a manner that demonstrates ownership and accountability.<br /><br />18. Demonstrates infection control per Medicare/CHAP/OSHA guidelines and Agency<br /><br />policies.<br /><br />19. Maintains a professional appearance and treats others with care and respect. Works toward resolution of interpersonal conflicts as they arise.<br /><br />20. Possess and maintains a current license, CPR certificate and Tuberculin testing. Remains current for all other Agency mandatories.<br /><br />21. Follows-up timely with physician regarding lab results<br /><br />22. Confirms all orders with the physician<br /><br />23. Assures maintenance of office and medical supplies, forms and inventories<br /><br />24. Builds community and customer perception of the Agency as a high quality provider of services.<br /><br />25. Continuously analyzes work processes and makes suggestion for improvement.<br /><br />26. Recommends and/or supports changes to Agency policies and procedures.<br /><br />27. Maintains Agency property, supplies and equipment in a manner that demonstrates ownership and accountability.<br /><br />28. Is a team player: recognizing the influence of beliefs and cultures on behaviors and accepting strengths and limitations in others; works towards the resolution of interpersonal conflicts as they arise; attends and contributes during meetings; demonstrates initiative to meet the needs of the Agency by assisting coworkers when workload permits; provides assistance in a courteous manner and treats others with care and respect.<br /><br />29. May assist with new employee orientation<br /><br />30. Maintains a professional appearance.<br /><br />31. Performs other duties as required.<br /><br />Qualifications<br /><br />Graduate of an accredited School of Nursing. Current RN licensure in the State of employment. One year recent experience in Medical-Surgical care of the adult patient preferred. Two years Home Care experience preferred.<br /><br />Possesses excellent observational and assessment skills and nursing judgment. Possesses good verbal and written skills. Must be a licensed driver with an insured automobile in good working order</p>',
'post_date' => '2019-01-08 13:51:49',
'compensation' => '',
'craigslist_city' => 'chicago',
'craigslist_sub_city' => 'city of chicago',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Illinois'
)
)
)
$display_company_title = 'Jobs at Guardian Hospice'
$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>Guardian Hospice</h1>
<p class="text-muted">Winnetka, IL</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">January 09, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44887" job_id="44887" href="/jobs/view/44887" title="Customer Service Representative - We are hiring now!"><strong>Customer Service Representative - We are hiring now!</strong></a>
</h2>
<div class="job-location">City Of Chicago</div>
</div>
<div class="col-xs-12">
<p class="description">A Customer Service Representative will be primarily responsible for customer phone support, processing of requests, researching and analyzing problems to determine accurate and prompt resolution of any issues that arise, and relaying necessary information to the customers, reps or Client by both verbal...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">January 08, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44866" job_id="44866" href="/jobs/view/44866" title="Registered Nurse"><strong>Registered Nurse</strong></a>
</h2>
<div class="job-location">City Of Chicago</div>
</div>
<div class="col-xs-12">
<p class="description">At Guardian Hospice, we are always looking for dedicated people to become members of our caring team. The majority of our staff stay with our organization for a very long time, for they appreciate the way they are treated. We have created a family environment that promotes respect, support, understanding,...</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
A Customer Service Representative will be primarily responsible for customer phone support, processing of requests, researching and analyzing problems to determine accurate and prompt resolution of any issues that arise, and relaying necessary information to the customers, reps or Client by both verbal...
At Guardian Hospice, we are always looking for dedicated people to become members of our caring team. The majority of our staff stay with our organization for a very long time, for they appreciate the way they are treated. We have created a family environment that promotes respect, support, understanding,...
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` = 30328 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` = 30328 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` = 30328 LIMIT 1