*/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_16ffd6e117a1e5913f00fe9702c465b6' 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_967fa07c9f7cca924bdd8963d497027e' 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_a476c03b8b3a335fb85cd5ce08ec8961' 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 APEX Piping Systems, Inc. in Wilmington, DEWarning (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 APEX Piping Systems, Inc. in <span class='locality'>Wilmington</span>, <span class='region'>Delaware</span>.',
'title_for_layout' => 'Work for APEX Piping Systems, Inc. in Wilmington, DE',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'APEX Piping Systems, Inc.',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Wilmington',
'state' => 'DE',
'lat' => '39.72000122',
'lon' => '-75.61499786',
'street_address' => '',
'id' => '30493',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '19804',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/apexpipingsystems/',
'website' => 'http://www.apexpiping.com',
'company_logo' => 'w1549468233319589966_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'Delaware'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at APEX Piping Systems, Inc.',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w15494681861235256755_small.jpg',
'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">
<img title="APEX Piping Systems, Inc." alt="APEX Piping Systems, Inc." src="https://d2qez73695kjfi.cloudfront.net/w1549468233319589966_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>APEX Piping Systems, Inc.</h1>
<p class="text-muted">Wilmington, DE</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
<p class="voffset1"><a class="blue-link" href="http://www.apexpiping.com" target="_blank">http://www.apexpiping.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/apexpipingsystems/" target="_new" title="APEX Piping Systems, Inc. Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="APEX Piping Systems, Inc." alt="APEX Piping Systems, Inc." src="http://proven-employer-mobile-images.s3.amazonaws.com/w15494681861235256755_small.jpg" class="img-responsive center-block" />
</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">February 06, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45072" job_id="45072" href="/jobs/view/45072" title="Pipe Welder"><strong>Pipe Welder</strong></a>
</h2>
<div class="job-location">Delaware</div>
</div>
<div class="col-xs-12">
<p class="description">APEX Piping Systems is recognized as the leader in process pipe and specialty metal fabrications, including ASME Code work. Apex Piping Systems serves the chemical, petrochemical, pharmaceutical, food and beverage, pulp and paper, power, and marine industries. We are a “World Class” fabricator...</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 APEX Piping Systems, Inc. in <span class='locality'>Wilmington</span>, <span class='region'>Delaware</span>.'
$title_for_layout = 'Work for APEX Piping Systems, Inc. in Wilmington, DE'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'APEX Piping Systems, Inc.',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Wilmington',
'state' => 'DE',
'lat' => '39.72000122',
'lon' => '-75.61499786',
'street_address' => '',
'id' => '30493',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '19804',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/apexpipingsystems/',
'website' => 'http://www.apexpiping.com',
'company_logo' => 'w1549468233319589966_small.png',
'twitter_name' => ''
),
'State' => array(
'name' => 'Delaware'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '45072',
'open' => '1',
'title' => 'Pipe Welder',
'unique_name' => '',
'description' => '<p>APEX Piping Systems is recognized as the leader in process pipe and specialty metal fabrications, including ASME Code work. Apex Piping Systems serves the chemical, petrochemical, pharmaceutical, food and beverage, pulp and paper, power, and marine industries. We are a “World Class” fabricator offering a superior product line including Jacketed Piping Systems, Pipe Coils, Skid Mounted Modular Process Systems, and ASME Code Pressure Vessels. In addition, we provide experienced mechanical, boiler maintenance and repair services. We are currently hiring Pipe Welders for our Mechanical Services Division.</p>
<p><strong>POSITION SUMMARY: </strong>Use hand-welding and flame-cutting equipment to cut, fit and weld or join metal components including structural steel, pipes, and sheet metal.</p>
<p><strong>ESSENTIAL JOB FUNCTIONS</strong>:</p>
<p><strong>Safety</strong></p>
<ul>
<li>You are responsible for your safety!</li>
<li>Work safely in accordance with the APEX Safety Management System and adhere to all Company rules and regulations.</li>
<li>Immediately report any unsafe conditions, injuries, illness and near misses or acts to a supervisor.</li>
<li>Review and understand JSA, permits, site conditions and job hazards prior to starting any work and check that the work to be performed is safe. If work appears unsafe, report to supervisor and do not proceed until conditions are safe.</li>
<li>Review and understand the job and be physically and mentally fit to perform the job.</li>
<li>Attend and actively participate in all safety meetings as required including daily toolbox meetings and skill training.</li>
</ul>
<p><strong>Pipe Welding</strong></p>
<ul>
<li>Broad knowledge and experience working in industrial petro/chemical and commercial environments.</li>
<li>Interpret blueprints and schematic drawings to determine work procedures.</li>
<li>Lay out, position, align, and secure parts and assemblies prior to assembly, using straightedges, combination squares, calipers, and rulers.</li>
<li>Weld components in flat, vertical, horizontal, and overhead positions.</li>
<li>Ignites torches and start power supplies and strikes arcs by touching electrodes to metals being welded, completing electrical circuits.</li>
<li>Detect faulty operation of equipment or defective materials and notify supervisors.</li>
<li>Clamp, hold, tack-weld, heat-bend, grind or bolt component parts to obtain required configurations and positions for welding.</li>
<li>Operate manual or semi-automatic welding equipment to fuse metal segments, using processes such as gas tungsten arc, shielded metal arc, gas metal arc, flux-cored arc, plasma arc, resistance welding, and submerged arc welding.</li>
<li>Monitor the fitting, burning, and welding processes to avoid overheating parts, warping, shrinking, distortion, and expansion of materials.</li>
<li>Examine work pieces for defects and measure work pieces with straightedges or templates to ensure conformity with specifications.</li>
<li>Set up and operate hand and power tools common to the welding trade, such as shielded metal arc and gas metal arc welding equipment, hand grinders, and portable saws.</li>
<li>Observe tests on welded surfaces, such as hydrostatic, x-ray, and dimension tolerance to evaluate weld quality and conformance to specifications.</li>
<li>Inspect grooves, angles, and gap allowances, using micrometer, caliper, and precision measuring instruments.</li>
<li>Remove rough spots from work pieces, using portable grinders, hand files, and scrapers.</li>
</ul>
<p><strong>EDUCATION, SKILLS AND EXPERIENCE REQUIREMENTS:</strong></p>
<ul>
<li>High School Education or Equivalent.</li>
<li>Certification(s) from Trade School pipe welding or ability to pass similar skills assessment testing</li>
<li>Ability to pass weld tests in accordance with ASME Section IX.</li>
<li>At least five years experience working in pipe welding or in a pipe welding apprenticeship in the petrochemical or industrial enterprises.</li>
<li>Ability to work alone or in a team environment and to follow directions and or instructions.</li>
<li>Good communication and problem solving skills</li>
</ul>
<p><strong>PHYSICAL DEMANDS:</strong></p>
<ul>
<li>Able to lift and carry up to 50 lbs.</li>
<li>Able to exert physical force</li>
<li>Able to talk and hear and use their hands and fingers, to handle or feel.</li>
<li>Able to frequently to stand, walk, reach with arms and hands, climb or balance, and to stoop, kneel, crouch or crawl.</li>
<li>Must be able to work with and must use PPE such as personal fall protection, safety glasses, goggles, face shields, welding hoods, gloves, hard hats, steel tip shoes and respirators when required by the job or site.</li>
</ul>
<p><strong>WORK ENVIRONMENT: </strong>This job typically requires work in industrial and commercial petro-chemical plants, refineries, terminals, power houses, mechanical rooms. Working conditions may be hot or cold and require movement in cramped spaces, climbing, crawling, stooping, and reaching. Must handle oil, grease, and sharp pieces of metal and heavy objects.</p>
<p><strong>CONCLUSION: </strong>This job description is intended to convey information essential to understanding the scope of the job and the general nature and level of work performed by job holders within this job. But, this job description is not intended to be an exhaustive list of qualifications, skills, efforts, duties, responsibilities or working conditions associated with the position.</p>
<p>Job Type: Full-time</p>
<p>Experience:</p>
<ul>
<li>Pipe Welding: 1 year (Preferred)</li>
</ul>
<p>Benefits offered:</p>
<ul>
<li>Paid time off</li>
<li>Health insurance</li>
<li>Dental insurance</li>
<li>Healthcare spending or reimbursement accounts such as HSAs or FSAs</li>
<li>Other types of insurance</li>
<li>Retirement benefits or accounts</li>
<li>Education assistance or tuition reimbursement</li>
</ul>',
'post_date' => '2019-02-06 15:32:22',
'compensation' => '',
'craigslist_city' => 'delaware',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Delaware'
)
)
)
$display_company_title = 'Jobs at APEX Piping Systems, Inc.'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w15494681861235256755_small.jpg'
$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">
<img title="APEX Piping Systems, Inc." alt="APEX Piping Systems, Inc." src="https://d2qez73695kjfi.cloudfront.net/w1549468233319589966_small.png" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>APEX Piping Systems, Inc.</h1>
<p class="text-muted">Wilmington, DE</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
<p class="voffset1"><a class="blue-link" href="http://www.apexpiping.com" target="_blank">http://www.apexpiping.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/apexpipingsystems/" target="_new" title="APEX Piping Systems, Inc. Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="APEX Piping Systems, Inc." alt="APEX Piping Systems, Inc." src="http://proven-employer-mobile-images.s3.amazonaws.com/w15494681861235256755_small.jpg" class="img-responsive center-block" />
</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">February 06, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="45072" job_id="45072" href="/jobs/view/45072" title="Pipe Welder"><strong>Pipe Welder</strong></a>
</h2>
<div class="job-location">Delaware</div>
</div>
<div class="col-xs-12">
<p class="description">APEX Piping Systems is recognized as the leader in process pipe and specialty metal fabrications, including ASME Code work. Apex Piping Systems serves the chemical, petrochemical, pharmaceutical, food and beverage, pulp and paper, power, and marine industries. We are a “World Class” fabricator...</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
APEX Piping Systems is recognized as the leader in process pipe and specialty metal fabrications, including ASME Code work. Apex Piping Systems serves the chemical, petrochemical, pharmaceutical, food and beverage, pulp and paper, power, and marine industries. We are a “World Class” fabricator...
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` = 30493 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` = 30493 AND `EmployersJob`.`open` = 1 AND `EmployersJob`.`anonymous_post` = 0 GROUP BY `EmployersJob`.`id` ORDER BY `EmployersJob`.`post_date` DESC
1
1
1
3
SELECT `EmployerMobileImage`.`file_name` FROM `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` WHERE `EmployerMobileImage`.`employer_id` = 30493 LIMIT 1