*/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_535665e3a66b0b5632cd675face7a5be' 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_51d42eb7e6ea30cff332587a7cbae8c8' 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_028e394f6da52b8c770f710304821cb8' 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 U-Tech Electronics in Newark, NJWarning (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 U-Tech Electronics in <span class='locality'>Newark</span>, <span class='region'>New Jersey</span>.',
'title_for_layout' => 'Work for U-Tech Electronics in Newark, NJ',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'U-Tech Electronics',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Newark',
'state' => 'NJ',
'lat' => '40.72209930',
'lon' => '-74.14099884',
'street_address' => '',
'id' => '30793',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '07105',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New Jersey'
),
'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 U-Tech Electronics',
'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>U-Tech Electronics</h1>
<p class="text-muted">Newark, NJ</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">April 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45568" job_id="45568" href="/jobs/view/45568" title="Phone Repair Technician"><strong>Phone Repair Technician</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">Phone repair technician for phone repair shop We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">April 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45567" job_id="45567" href="/jobs/view/45567" title="Sales Assistant"><strong>Sales Assistant</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">Sales Assistant for phone repair shop We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological...</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 U-Tech Electronics in <span class='locality'>Newark</span>, <span class='region'>New Jersey</span>.'
$title_for_layout = 'Work for U-Tech Electronics in Newark, NJ'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'U-Tech Electronics',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Newark',
'state' => 'NJ',
'lat' => '40.72209930',
'lon' => '-74.14099884',
'street_address' => '',
'id' => '30793',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '07105',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New Jersey'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '45568',
'open' => '1',
'title' => 'Phone Repair Technician',
'unique_name' => '',
'description' => '<p><strong>Phone repair technician for phone repair shop</strong></p>
<p>We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological field.</p>
<p><strong>Duties & Responsibilities:</strong></p>
<ul>
<li>Perform routine inspection, testing, and repair of smart phones and other mobile devices.</li>
<li>Accurately document repairs and parts information on repair tracking documents / work orders and in point of sale computer tracking system.</li>
<li>Perform high quality repairs and refurbishment of electronic devices: phones/tablets/laptops/etc.</li>
<li>Monitor parts inventories and inform management of status.</li>
<li>Dismantle old electronic devices for OEM parts.</li>
<li>Interact with customers as needed, providing exceptional customer service.</li>
<li>Keep work area clean, organized and sterile.</li>
<li>Performs other duties as required by management, including cleaning of work areas, bathrooms and office environment.</li>
</ul>
<p><strong>Skills/Qualifications:</strong></p>
<ul>
<li>Honesty and Integrity -- the number one requirement for the job</li>
<li>Must have iPhone and/or iPad repair experience!! Do not apply if you do not have this background.</li>
<li>Enjoy working on electronic gadgets -- we will train you on the procedures and processes.</li>
<li>Passion for working with electronic gadgets!! Positive personality!</li>
<li>Reliable and timely -- strong work ethic.</li>
<li>Strong focus on quality repairs.</li>
<li>The ability to read, write and communicate in English in order to read and comprehend assembly manuals and process documentation.</li>
<li>Oral and written communication proficiency.</li>
<li>Troubleshooting and assembly skills.</li>
<li>Basic computer skills.</li>
<li>High School diploma or GED/equivalent certification required.</li>
</ul>',
'post_date' => '2019-04-22 19:22:27',
'compensation' => '',
'craigslist_city' => 'north jersey',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New Jersey'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '45567',
'open' => '1',
'title' => 'Sales Assistant',
'unique_name' => '',
'description' => '<p><strong>Sales Assistant for phone repair shop</strong></p>
<p>We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological field.</p>
<p>We are looking for a competitive retail Sales Assistant to help customers identify and purchase products they desire. Sales assistant duties include selling, restocking and merchandising. The goal is to provide high class customer service and to increase company’s growth and revenue through sales maximization.</p>
<p><strong>Responsibilities</strong></p>
<ul>
<li>Ensure high levels of customer satisfaction through excellent sales service</li>
<li>Assess customers needs and provide assistance and information on product features</li>
<li>Welcome customers to the store and answer their queries</li>
<li>Follow and achieve department’s sales goals on a monthly, quarterly and yearly basis</li>
<li>“Go the extra mile” to drive sales</li>
<li>Maintain in-stock and presentable condition assigned areas</li>
<li>Actively seek out customers in store</li>
<li>Remain knowledgeable on products offered and discuss available options</li>
<li>Process POS (point of sale) purchases</li>
<li>Cross sell products</li>
<li>Handle returns of merchandise</li>
<li>Team up with co-workers to ensure proper customer service</li>
<li>Build productive trust relationships with customers</li>
</ul>
<p><strong>Requirements</strong></p>
<ul>
<li>Proven work experience as a Retail Sales associate, Sales representativeor similar role</li>
<li>Basic understanding of sales principles and customer service practices</li>
<li>Proficiency in English</li>
<li>Basic Math skills</li>
<li>Working knowledge of customer and market dynamics and requirements</li>
<li>Track record of over-achieving sales quota</li>
<li>Hands-on experience with POS transactions</li>
<li>Familiarity with inventory procedures</li>
<li>Solid communication and interpersonal skills</li>
<li>A friendly and energetic personality with customer service focus</li>
<li>Ability to perform under pressure and address complaints in a timely manner</li>
<li>Availability to work flexible shifts</li>
<li>High school degree</li>
</ul>
<p>Interested applicants please submit application.</p>
<p> </p>',
'post_date' => '2019-04-22 19:14:04',
'compensation' => '',
'craigslist_city' => 'north jersey',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New Jersey'
)
)
)
$display_company_title = 'Jobs at U-Tech Electronics'
$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>U-Tech Electronics</h1>
<p class="text-muted">Newark, NJ</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">April 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45568" job_id="45568" href="/jobs/view/45568" title="Phone Repair Technician"><strong>Phone Repair Technician</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">Phone repair technician for phone repair shop We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">April 22, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45567" job_id="45567" href="/jobs/view/45567" title="Sales Assistant"><strong>Sales Assistant</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">Sales Assistant for phone repair shop We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological...</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
Phone repair technician for phone repair shop We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological...
Sales Assistant for phone repair shop We are a local phone repair shop and we have been in business for about 5 years. We pride ourselves in our excellent customer service and quality of products and services provided. You will be joining a team full of enthusiasm and passion for the technological...
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` = 30793 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` = 30793 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` = 30793 LIMIT 1