*/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_fdf72eedba7baa4bbee755d6968c5fd8' 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_da2a440f11b0611c3ad360e3f1f6679e' 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_da3242e85994931449f511830c2aaf84' 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 Creative Thinker LLC in Syosset, NYWarning (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 Creative Thinker LLC in <span class='locality'>Syosset</span>, <span class='region'>New York</span>.',
'title_for_layout' => 'Work for Creative Thinker LLC in Syosset, NY',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Creative Thinker LLC',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Syosset',
'state' => 'NY',
'lat' => '40.81380081',
'lon' => '-73.50279999',
'street_address' => '',
'id' => '29880',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '11791',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New York'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Creative Thinker LLC',
'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>Creative Thinker LLC</h1>
<p class="text-muted">Syosset, NY</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">October 07, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44197" job_id="44197" href="/jobs/view/44197" title="Mathematics Teacher"><strong>Mathematics Teacher</strong></a>
</h2>
<div class="job-location">Long Island</div>
</div>
<div class="col-xs-12">
<p class="description">Love math? Together, let’s spark Creative Thinkers. Come work with us! ABOUT US We are a leading after school, Singapore Mathematics Enrichment Center, located in Long Island, NY. We believe that every child is a hero, a Future Leader and has an infinite capacity to learn. We approach mathematics...</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 Creative Thinker LLC in <span class='locality'>Syosset</span>, <span class='region'>New York</span>.'
$title_for_layout = 'Work for Creative Thinker LLC in Syosset, NY'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Creative Thinker LLC',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Syosset',
'state' => 'NY',
'lat' => '40.81380081',
'lon' => '-73.50279999',
'street_address' => '',
'id' => '29880',
'about_us' => '',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '11791',
'yelp_page' => '',
'facebook_page' => '',
'website' => null,
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'New York'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '44197',
'open' => '1',
'title' => 'Mathematics Teacher',
'unique_name' => '',
'description' => '<p><strong>Love math? Together, let’s spark Creative Thinkers. Come work with us!</strong></p>
<p><strong>ABOUT US</strong></p>
<p>We are a leading <strong>after school, Singapore Mathematics Enrichment Center, located in Long Island, NY. </strong>We believe that every child is a hero, a Future Leader and has an infinite capacity to learn. We approach mathematics teaching and learning differently in a fun, energetic and inspirational environment. Our approach to teaching the foundations of math makes learning math more meaningful and relatable. It involves critical thinking, logical reasoning, metacognition, word problems and modeling techniques. Our students range from age 3 to 14 years old. Our proven method of teaching helps with problem solving, encourages thinking process and most importantly interpret mathematics in real world applications through problem solving. Our goal is to make their mathematical journey meaningful and joyful. Let’s Make our Kids, “Creative Thinkers”.</p>
<p><strong>We have multiple </strong>openings for a Center Director and skilled instructors who love teaching math, love working with kids, and have the ability to motivate students to succeed. Our students work through their customized Singapore Math learning plans so there is no lesson planning required, and instructors apply the teaching methods presented during training.</p>
<p><strong>JOB SUMMARY</strong></p>
<p>We are looking for dynamic and creative Math Teachers who will teach through the conceptualization of mathematical content. As a Math Teacher, we want you to maximize student mastery of mathematics by going beyond simply teaching computational math by enabling your scholars to conceptualize math concepts and show them how to apply math content to their everyday lives!</p>
<p>This is an opportunity to shape our children’s future. Each of our scholars has the potential to do great things. All they need is YOU to help show them how they can succeed!</p>
<p><strong>Our Learning Center Instructor will:</strong></p>
<p>Provide effective math instruction using our preferred teaching methods <strong>*</strong>Assist in tracking the progress of each student <strong>*</strong> Complete administrative tasks as they are assigned <strong>*</strong> Contribute to the creation of an engaging and productive learning environment <strong>*</strong> Engage in initial and on-going training.</p>
<p> </p>
<p><strong>JOB DESCRIPTION/RESPONSIBILITIES</strong></p>
<ul>
<li><strong>Private and Semi-Private Singapore Math Enrichment Teaching </strong>with highest integrity.</li>
<li>Coach lower grades and/or middle school mathematics to build core skills and instill a love of mathematical thinking.</li>
<li>Execute lesson plans that meet core learning goals with effective mathematical thinking and problem solving.</li>
<li>Maintain complete and accurate records of each student’s progress. Use student data to reflect on effectiveness of lessons and student achievement progress in order to improve instruction and personal practice.</li>
<li>Practice professionalism through ongoing professional development, reflection and continuous improvement. Willing to attend workshops if necessary to enhance education and actively seek professional development.</li>
<li>Collaborate with colleagues in innovative ongoing development.</li>
<li>Communicate with parents in formal and informal written correspondence, meetings, and overall positive collaboration.</li>
<li>Other minor duties as assigned.</li>
</ul>
<p><strong>KEY COMPETENCIES/SUCCESS FACTORS</strong></p>
<ul>
<li><strong>PASSION</strong> for mathematics and building 21st Century Skills that will inspire the next generation of mathematicians</li>
<li>Be able to explain fundamental mathematical concepts</li>
<li>Ability to break down a complex problem into a simple explanation. It is not enough to know, you must be able to explain</li>
<li>Must <strong>love children</strong>, team player, compassionate, committed and dedicated towards improving children education. Ability to build and maintain rapport with students</li>
<li>Differentiate instruction effectively to meet the individual needs of students</li>
<li>Identify students who are academically at risk and initiate effective teaching strategies</li>
<li>Top notch interpersonal skills, communications skills AND training skills. A passion for being part of a team-oriented, mission-driven culture.</li>
<li>Be able to effectively <strong>communicate</strong> with Parents and Children.</li>
<li>Contribute to a climate where students are actively engaged in a meaningful learning experience. Must believe in, and be able to uphold the quality of our training pedagogy to students. Training will be provided.</li>
</ul>
<p><strong> </strong></p>
<p><strong>REQUIRED QUALIFICATION:</strong></p>
<ul>
<li>The ideal candidate is outgoing, well organized, competent in basic computer skills, and is an individual who is eager to work in a highly dynamic, energetic setting</li>
<li>Preferred New York State Math teaching certification or eligibility to be certified (not mandatory)</li>
<li>Preferred at least 2 year experience in the enrichment education industry for young children. Teaching credentials are a plus but are not mandatory.</li>
<li>Aptitude in Math. Candidates will be given an aptitude test</li>
<li>Ability to organize and manage multiple responsibilities successfully</li>
<li>Ability to do light physical activities such as bending, reaching and lifting</li>
</ul>
<p><strong>EMPLOYMENT BENEFITS/RATE</strong></p>
<ul>
<li>Competitive! Compensation ($15-$25/hr) is commensurate with experience and availability.</li>
</ul>
<p><strong>JOB TYPE:</strong></p>
<ul>
<li><strong>PART-TIME.</strong> Hours may vary, but could include Monday-Thursday between 3:00 pm-8:00 pm, Saturdays between 10:00 am-3:30 pm. Approximately 2 -25 hours/week (flexible)</li>
<li>To be considered, interested applicants please <strong>submit a cover letter (preferred) and resume (mandatory)</strong>. In your cover letter, include details about your math competency, experience teaching or working with students, and availability</li>
<li>Great opportunity for retired teachers, active teachers (to supplement their income), college students, grad students, or recent graduates looking for part time work and/or teaching experience</li>
<li>Knowledge of smart board and other technology to enhance the learning experience (preferred but not mandatory)</li>
<li>Paid training provided</li>
<li>English (Required)</li>
</ul>
<p><strong>SHIFTS:</strong></p>
<p>Consistent and scheduled, yet flexible. Available a minimum of two days/week during after-school or weekend hours.</p>
<p><strong>Job Type: Part-time</strong></p>
<p> </p>
<p><strong>Salary:</strong> $15.00 to $25.00 /hour</p>
<p><strong>Experience:</strong></p>
<ul>
<li>Teaching: 2+ year (Preferred)</li>
</ul>
<p> </p>',
'post_date' => '2018-10-08 05:02:45',
'compensation' => '',
'craigslist_city' => 'long island',
'craigslist_sub_city' => '',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'New York'
)
)
)
$display_company_title = 'Jobs at Creative Thinker LLC'
$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>Creative Thinker LLC</h1>
<p class="text-muted">Syosset, NY</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">October 07, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44197" job_id="44197" href="/jobs/view/44197" title="Mathematics Teacher"><strong>Mathematics Teacher</strong></a>
</h2>
<div class="job-location">Long Island</div>
</div>
<div class="col-xs-12">
<p class="description">Love math? Together, let’s spark Creative Thinkers. Come work with us! ABOUT US We are a leading after school, Singapore Mathematics Enrichment Center, located in Long Island, NY. We believe that every child is a hero, a Future Leader and has an infinite capacity to learn. We approach mathematics...</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
Love math? Together, let’s spark Creative Thinkers. Come work with us! ABOUT US We are a leading after school, Singapore Mathematics Enrichment Center, located in Long Island, NY. We believe that every child is a hero, a Future Leader and has an infinite capacity to learn. We approach mathematics...
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` = 29880 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` = 29880 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` = 29880 LIMIT 1