*/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_3b837c7865c9615ab6441d9ce13a18da' 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_1dfe178190d9682e8225dcb14699ecca' 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_63c6832042e8429ca1155a2c55cfa728' 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 BEStstaff Inc in Albuquerque, NMWarning (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 BEStstaff Inc in <span class='locality'>Albuquerque</span>, <span class='region'>New Mexico</span>.',
'title_for_layout' => 'Work for BEStstaff Inc in Albuquerque, NM',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'BEStstaff Inc',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Albuquerque',
'state' => 'NM',
'lat' => '35.10749817',
'lon' => '-106.57599640',
'street_address' => '',
'id' => '31233',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '87110',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New Mexico'
),
'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 BEStstaff Inc',
'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>BEStstaff Inc</h1>
<p class="text-muted">Albuquerque, NM</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
</div>
</div>
<hr />
<div class="open-positions">
<h3>Open Positions</h3>
<div class="job-listing ui-box-shadow">
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 28, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46205" job_id="46205" href="/jobs/view/46205" title="Mechanical Drafter/Designer - Solidworks"><strong>Mechanical Drafter/Designer - Solidworks</strong></a>
</h2>
<div class="job-location">Albuquerque</div>
</div>
<div class="col-xs-12">
<p class="description">Mechanical Drafter/Designer 2 - 3 Month Temp Assignment Immediate Need!!! Job responsibilities include, but are not limited to: Modeling mechanical components and electro-mechanical systems using SolidWorks and PDMWorks at an expert level. Drafting and developing integrated full up simulation...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 08, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46174" job_id="46174" href="/jobs/view/46174" title="Tier 1 Technical Support (Helpdesk)"><strong>Tier 1 Technical Support (Helpdesk)</strong></a>
</h2>
<div class="job-location">Albuquerque</div>
</div>
<div class="col-xs-12">
<p class="description">Customer Success Specialist (Tier 1 Helpdesk) KEY OBJECTIVES WE WILL ASK OF YOU Provide timely support to external and internal customers via phone, e-mail, chat, or other form of communication. Assist multiple clients across different ticketing systems. Quickly and efficiently identify the customer’s...</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 BEStstaff Inc in <span class='locality'>Albuquerque</span>, <span class='region'>New Mexico</span>.'
$title_for_layout = 'Work for BEStstaff Inc in Albuquerque, NM'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'BEStstaff Inc',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Albuquerque',
'state' => 'NM',
'lat' => '35.10749817',
'lon' => '-106.57599640',
'street_address' => '',
'id' => '31233',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '87110',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New Mexico'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '46205',
'open' => '1',
'title' => 'Mechanical Drafter/Designer - Solidworks',
'unique_name' => '',
'description' => '<h1><strong>Mechanical Drafter/Designer</strong></h1>
<div>2 - 3 Month Temp Assignment</div>
<div><strong>Immediate Need!!!</strong></div>
<div> </div>
<div><strong>Job responsibilities include, but are not limited to:</strong></div>
<ul>
<li>
<div>Modeling mechanical components and electro-mechanical systems using SolidWorks and PDMWorks at an expert level.</div>
</li>
<li>
<div>Drafting and developing integrated full up simulation systems, motion seat systems, and simulated gun recoil systems.</div>
</li>
<li>
<div>Creating models and drawings for efficient fabrication and assembly.</div>
</li>
<li>
<div>Working in a team environment with engineers, project managers, and executives.</div>
</li>
<li>
<div>Developing design presentations to present to management for project approval.</div>
</li>
<li>
<div>Executing tasks with minimal direction and possessing the ability to recognize when to ask questions.</div>
</li>
</ul>
<div> </div>
<div><strong>Education or Equivalent Experience: </strong>Associate Degree, Computer Drafting and Design, plus 5 years experience or equivalent desired.</div>
<div> </div>
<div>Anticipated Pay Rate: $25 - $28/hr.</div>
<p><br />For complete job descriptions please visit our website at <a href="http://www.BEStstaffJobs.com/job-seekers">www.BEStstaffJobs.com/job-seekers</a> and click on “Click Here to View Open Jobs and Apply”..<br /><br />It is the policy of <strong>BEStstaff, Inc.</strong> not to discriminate against any employee or any applicant for employment because of age, race, religion, color, handicap, sex, physical condition, developmental disability, sexual orientation, or national origin.<br /><br /><strong>"Positively changing lives through Trust, Care and Commitment based staffing"</strong></p>',
'post_date' => '2019-08-28 16:32:17',
'compensation' => '',
'craigslist_city' => 'albuquerque',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New Mexico'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '46174',
'open' => '1',
'title' => 'Tier 1 Technical Support (Helpdesk)',
'unique_name' => '',
'description' => '<h1><strong>Customer Success Specialist (Tier 1 Helpdesk)</strong></h1>
<p><strong>KEY OBJECTIVES WE WILL ASK OF YOU</strong></p>
<ul>
<li>Provide timely support to external and internal customers via phone, e-mail, chat, or other form of communication.</li>
<li>Assist multiple clients across different ticketing systems.</li>
<li>Quickly and efficiently identify the customer’s specific information.</li>
<li>Resolve technical P.C. software and hardware problems by utilizing logical problem solving skills and referencing documented processes and procedures. (Microsoft Office, Win7, VPN, Active Directory, customer specific software applications, laptops, desktops, printers, VOIP telephony etc.).</li>
<li>Effectively escalate unresolved tickets to the appropriate team to ensure that the customer issue gets resolved.</li>
<li>Using the client-based requirements within the ITIL framework, correctly assign Urgency and Impact to tickets.</li>
<li>Provide End-User Electronic Health Record (EHR) usability assistance to clinicians including, but not limited to doctors, nurses, and therapists.</li>
<li>Create an exceptional customer service experience by bringing your polished communications, patience and empathy for the customer calling.</li>
<li>Capacity to work independently and effectively while maintaining good team interactions.</li>
<li>Partner with team members to ensure that the phones are covered during breaks, lunch, etc.</li>
<li>Flexibility to work off schedule when needed.</li>
</ul>
<p> </p>
<p><strong>REQUIREMENTS YOU WILL NEED</strong></p>
<ul>
<li>High School diploma or G.E.D equivalent/and or experience.</li>
<li>Working knowledge of PC operations </li>
<li>Excellent verbal and written communication skills.</li>
<li>Ability to excel at problem solving – if you like logic puzzles, this is the job for you!</li>
<li>CompTIA A+ Certification preferred, <strong>but not required</strong></li>
<li>Knowledge of medical-based terms and phrases <strong>are a definite advantage</strong>.</li>
<li>Electronic Health Record – EHR experience – <strong>working within the EHR a plus</strong></li>
</ul>
<p> </p>
<p><strong>WORK CONDITIONS</strong></p>
<ul>
<li>Required to sit for extended periods of time.</li>
<li>Ability to operate a computer keyboard, mouse and to handle other computer components</li>
<li>May be asked to lift/transport moderately heavy objects, such as computers, devices and peripherals.</li>
<li>Ability to work between the hours of 6:00 am to 6:00 pm (unless After Hours then the scheduled hours will vary from 6:00 pm to 6:00 am and may include weekend shifts.</li>
<li>Maintain a logged in and ready state 100% of the total time for the shift assigned not including lunches, breaks or assigned special projects.</li>
<li>Must keep THE COMPANY, patient, and client information confidential.</li>
</ul>
<p><br /><strong>DAYS & EVENING POSITIONS AVAILABLE</strong><br /><br />Anticipated starting rate of pay: $14.00/hr</p>',
'post_date' => '2019-08-08 21:56:05',
'compensation' => '',
'craigslist_city' => 'albuquerque',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New Mexico'
)
)
)
$display_company_title = 'Jobs at BEStstaff Inc'
$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>BEStstaff Inc</h1>
<p class="text-muted">Albuquerque, NM</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
</div>
</div>
<hr />
<div class="open-positions">
<h3>Open Positions</h3>
<div class="job-listing ui-box-shadow">
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 28, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46205" job_id="46205" href="/jobs/view/46205" title="Mechanical Drafter/Designer - Solidworks"><strong>Mechanical Drafter/Designer - Solidworks</strong></a>
</h2>
<div class="job-location">Albuquerque</div>
</div>
<div class="col-xs-12">
<p class="description">Mechanical Drafter/Designer 2 - 3 Month Temp Assignment Immediate Need!!! Job responsibilities include, but are not limited to: Modeling mechanical components and electro-mechanical systems using SolidWorks and PDMWorks at an expert level. Drafting and developing integrated full up simulation...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 08, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="46174" job_id="46174" href="/jobs/view/46174" title="Tier 1 Technical Support (Helpdesk)"><strong>Tier 1 Technical Support (Helpdesk)</strong></a>
</h2>
<div class="job-location">Albuquerque</div>
</div>
<div class="col-xs-12">
<p class="description">Customer Success Specialist (Tier 1 Helpdesk) KEY OBJECTIVES WE WILL ASK OF YOU Provide timely support to external and internal customers via phone, e-mail, chat, or other form of communication. Assist multiple clients across different ticketing systems. Quickly and efficiently identify the customer’s...</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
Mechanical Drafter/Designer 2 - 3 Month Temp Assignment Immediate Need!!! Job responsibilities include, but are not limited to: Modeling mechanical components and electro-mechanical systems using SolidWorks and PDMWorks at an expert level. Drafting and developing integrated full up simulation...
Customer Success Specialist (Tier 1 Helpdesk) KEY OBJECTIVES WE WILL ASK OF YOU Provide timely support to external and internal customers via phone, e-mail, chat, or other form of communication. Assist multiple clients across different ticketing systems. Quickly and efficiently identify the customer’s...
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` = 31233 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` = 31233 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` = 31233 LIMIT 1