*/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_0cc6e75790c5b1a409b53551a7828e48' 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_3e8ce5cbcb61d3a13c0aef0b31583ba2' 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_287a55cb7b2f3bc08957ab6ac5389050' 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 H&M International Transportation in Jersey City, 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 H&M International Transportation in <span class='locality'>Jersey City</span>, <span class='region'>New Jersey</span>.',
'title_for_layout' => 'Work for H&M International Transportation in Jersey City, NJ',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'H&M International Transportation',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Jersey City',
'state' => 'NJ',
'lat' => '40.74769974',
'lon' => '-74.04989624',
'street_address' => '',
'id' => '29809',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '07307',
'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 H&M International Transportation',
'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>H&M International Transportation</h1>
<p class="text-muted">Jersey City, 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">September 21, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44050" job_id="44050" href="/jobs/view/44050" title="Chassis Container Mechanic"><strong>Chassis Container Mechanic</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">H&M International Transportation- a World Class provider of Inter-modal Services is looking for full time Chassis/Container Mechanics at our Jersey City location. Responsibilities: Conducting routine/scheduled maintenance on railroad leased/owned containers and chassis Repairing of equipment...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">September 21, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44049" job_id="44049" href="/jobs/view/44049" title="Hostler Truck Operator"><strong>Hostler Truck Operator</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">Job Summary H & M International Transportation, a leader in Intermodal Industry through the US, is seeking successful candidates to operate hostler trucks to move trailers and containers to and from parking areas, to and from tracks, in premises. Also moving bare chassis to unload containers...</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 H&M International Transportation in <span class='locality'>Jersey City</span>, <span class='region'>New Jersey</span>.'
$title_for_layout = 'Work for H&M International Transportation in Jersey City, NJ'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'H&M International Transportation',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Jersey City',
'state' => 'NJ',
'lat' => '40.74769974',
'lon' => '-74.04989624',
'street_address' => '',
'id' => '29809',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '07307',
'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' => '44050',
'open' => '1',
'title' => 'Chassis Container Mechanic',
'unique_name' => '',
'description' => '<p>H&M International Transportation- a World Class provider of Inter-modal Services is looking for full time <strong>Chassis/Container Mechanics</strong> at our Jersey City location.</p>
<p><strong>Responsibilities:</strong></p>
<ul>
<li>Conducting routine/scheduled maintenance on railroad leased/owned containers and chassis</li>
<li>Repairing of equipment in accordance with Railroad, manufacturer, and FMCSA guidelines</li>
<li>Documenting all repairs according to an established reporting system; verbally and in writing</li>
<li>Maintaining safe work habits and utilizing time wisely and efficiently.</li>
<li>Utilizing various company-implemented training programs to upgrade technical skills</li>
</ul>
<p><strong>Qualifications:</strong></p>
<ul>
<li>Ability to work independently, in a safe and efficient manner</li>
<li>Ability to perform work in all types of weather conditions</li>
<li>Solid written and verbal skills for documentation of repair orders</li>
<li>Must have own hand tools</li>
<li>Must hold a valid driver’s license</li>
<li>Ability to lift in excess of 50 lbs.</li>
<li>Minimum of 1 year verifiable mechanic experience in <strong>ANY</strong> industry</li>
</ul>
<p><strong>We offer COMPETITIVE pay depending on experience with excellent benefits! Join the NML Team (National Maintenance League) and win with our incentive program!</strong></p>
<p>H&M is recognized and accepted as a leader in the Inter-modal Industry for one reason-- our people. Our employees have set us apart for generations and they continue to do so today. For more than 40 years we have been in the forefront of our industry because we invest in our people and we commit to the processes, service, and technology that will support their efforts. Our high level of customer satisfaction is the result of exceptional service and our people embrace that philosophy every day in every way.</p>
<p>Job Type: Full-time</p>
<p>Experience:</p>
<ul>
<li>Container or Chassis Mechanic: 1 year (Required)</li>
<li>ability to lift 50lbs: 1 year (Required)</li>
<li>Mechanic: 1 year (Required)</li>
</ul>
<p>License:</p>
<ul>
<li>Driver (Required)</li>
</ul>',
'post_date' => '2018-09-21 14:43:08',
'compensation' => '',
'craigslist_city' => 'north jersey',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New Jersey'
)
),
(int) 1 => array(
'EmployersJob' => array(
'id' => '44049',
'open' => '1',
'title' => 'Hostler Truck Operator',
'unique_name' => '',
'description' => '<p><strong>Job Summary</strong></p>
<p>H & M International Transportation, a leader in Intermodal Industry through the US, is seeking successful candidates to operate hostler trucks to move trailers and containers to and from parking areas, to and from tracks, in premises. Also moving bare chassis to unload containers on inbound freight. We operate 24/7 days a week all year round.</p>
<p><strong>Duties & Responsibilities</strong></p>
<ul>
<li>Spot units/chassis next to assigned railcars for loading/unloading trains.</li>
<li>Lock and unlock containers to chassis for TOFC or COFC movement</li>
<li>Perform all necessary computer functions to maintain accurate inventory.</li>
<li>Assist outside drivers as needed to retrieve trailers and containers.</li>
<li>Performs other duties as requested or required by supervisor</li>
<li>May be required to perform the duties of the ground man as needed, along with any other duty assigned by the supervisor.</li>
<li>Will be required to raise hitches on railcars as needed.</li>
<li>Required to perform duties on all types of weather conditions.</li>
</ul>
<p>*Knowledge, Skills and Abilities</p>
<ul>
<li>Ability to understand and carry out detailed written and verbal instructions.</li>
<li>Ability to see well enough to read operating and maintenance instructions, gauges and dials on precision measuring tools.</li>
<li>Ability to read and comprehend safety manuals, test materials, and procedure manuals.</li>
<li>Ability to acquire and maintain a valid drivers' license to operate company vehicles</li>
<li>Must be able to hear and talk well enough to communicate with co-workers, supervisors and yard workers via radio communication.</li>
</ul>
<p><strong>Qualification:</strong></p>
<p>High school graduate or general education development (GED).</p>
<p>We offer great pay and excellent benefits! EOE</p>
<p>***Qualified applicants will have to pass a Background check and Drug test before being hired.</p>
<p>Job Type: Full-time</p>
<p>Experience:</p>
<ul>
<li>commercial driving: 1 year (Preferred)</li>
<li>Driving: 2 years (Preferred)</li>
</ul>
<p>License:</p>
<ul>
<li>CDL Class A or B (Preferred)</li>
</ul>
<p> </p>',
'post_date' => '2018-09-21 14:38:58',
'compensation' => '',
'craigslist_city' => 'north jersey',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New Jersey'
)
)
)
$display_company_title = 'Jobs at H&M International Transportation'
$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>H&M International Transportation</h1>
<p class="text-muted">Jersey City, 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">September 21, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44050" job_id="44050" href="/jobs/view/44050" title="Chassis Container Mechanic"><strong>Chassis Container Mechanic</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">H&M International Transportation- a World Class provider of Inter-modal Services is looking for full time Chassis/Container Mechanics at our Jersey City location. Responsibilities: Conducting routine/scheduled maintenance on railroad leased/owned containers and chassis Repairing of equipment...</p>
</div>
</div>
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">September 21, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44049" job_id="44049" href="/jobs/view/44049" title="Hostler Truck Operator"><strong>Hostler Truck Operator</strong></a>
</h2>
<div class="job-location">North Jersey</div>
</div>
<div class="col-xs-12">
<p class="description">Job Summary H & M International Transportation, a leader in Intermodal Industry through the US, is seeking successful candidates to operate hostler trucks to move trailers and containers to and from parking areas, to and from tracks, in premises. Also moving bare chassis to unload containers...</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
H&M International Transportation- a World Class provider of Inter-modal Services is looking for full time Chassis/Container Mechanics at our Jersey City location. Responsibilities: Conducting routine/scheduled maintenance on railroad leased/owned containers and chassis Repairing of equipment...
Job Summary H & M International Transportation, a leader in Intermodal Industry through the US, is seeking successful candidates to operate hostler trucks to move trailers and containers to and from parking areas, to and from tracks, in premises. Also moving bare chassis to unload containers...
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` = 29809 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` = 29809 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` = 29809 LIMIT 1