<!-- list_by_city.php -->
<!-- SELECT statename FROM `localjobboard_com_-_site`.tblState WHERE stateabbr LIKE 'MO' LIMIT 1 -->

<!-- findByParamsRN( { city : 'Scott City', state : 'Missouri', zipcode : NULL, category : NULL, onlyFeatured : false, onlyNotFeatured : false, zipcodeNearby : false }, 0, 25, false ) -->

<!-- SELECT cities_id AS val FROM portland_site.cities WHERE prettycity LIKE 'Scott City' -->

<!-- 0 rows in 0.001 seconds -->

<!-- SELECT
            'RecNet' AS `source`,
            j.alpha AS `id`,
            CONCAT('http://www.', j.city, 'recruiter.com', j.seo_url) AS `url`,
            j.title AS `title`,
            j.maintext AS `description`,
            j.company AS `company`,
            j.editdate AS `postdate`,
            i.state AS `state`,
            i.prettycity `city`,
            i.first_zipcode AS `zipcode`,
            c.category AS `category`,
            j.deleted AS deleted,
            j.seo_url AS seo_url
        FROM `portland_site`.jobs_searchable s
        LEFT JOIN `portland_site`.jobs j ON j.alpha = s.job_alpha
        LEFT JOIN `portland_site`.cities i ON s.cities_id = i.cities_id
        LEFT JOIN `portland_site`.categories c ON j.category_alpha = c.alpha
        WHERE s.editdate > now() - INTERVAL 3 DAY
         AND false 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

<!-- 0 rows in 0 seconds -->

<!-- findByParamsRN( { city : 'Scott City', state : 'Missouri', zipcode : NULL, category : NULL, onlyFeatured : false, onlyNotFeatured : false, zipcodeNearby : false }, 0, 25, true ) -->

<!-- SELECT cities_id AS val FROM portland_site.cities WHERE prettycity LIKE 'Scott City' -->

<!-- 0 rows in 0 seconds -->

<!-- SELECT cityIDNearby FROM cities_distance WHERE cityIDSearchable = '' ORDER BY distance LIMIT 40 -->

<!-- 0 rows in 0 seconds -->

<!-- SELECT
            'RecNet' AS `source`,
            j.alpha AS `id`,
            CONCAT('http://www.', j.city, 'recruiter.com', j.seo_url) AS `url`,
            j.title AS `title`,
            j.maintext AS `description`,
            j.company AS `company`,
            j.editdate AS `postdate`,
            i.state AS `state`,
            i.prettycity `city`,
            i.first_zipcode AS `zipcode`,
            c.category AS `category`,
            j.deleted AS deleted,
            j.seo_url AS seo_url
        FROM `portland_site`.jobs_searchable s
        LEFT JOIN `portland_site`.jobs j ON j.alpha = s.job_alpha
        LEFT JOIN `portland_site`.cities i ON s.cities_id = i.cities_id
        LEFT JOIN `portland_site`.categories c ON j.category_alpha = c.alpha
        WHERE s.editdate > now() - INTERVAL 3 DAY
         AND false 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

<!-- 0 rows in 0 seconds -->

<!-- findByParamsRN( { city : 'Scott City', state : 'Missouri', zipcode : NULL, category : NULL, onlyFeatured : false, onlyNotFeatured : false, zipcodeNearby : false }, 0, 25, true ) -->

<!-- SELECT stateabbr FROM `localjobboard_com_-_site`.tblState WHERE statename LIKE 'Missouri' LIMIT 1 -->

<!-- SELECT CityID AS val FROM `localjobboard_com_-_site`.tblCity WHERE prettycityname LIKE 'Scott City' AND citystate LIKE 'MO' -->

<!-- 1 rows in 0.056 seconds -->

<!-- SELECT RNcityIDNearby FROM ljb_cities_distance WHERE LJBcityIDSearchable = '283535' ORDER BY distance LIMIT 40 -->

<!-- 1 rows in 0.001 seconds -->

<!-- SELECT
            'RecNet' AS `source`,
            j.alpha AS `id`,
            CONCAT('http://www.', j.city, 'recruiter.com', j.seo_url) AS `url`,
            j.title AS `title`,
            j.maintext AS `description`,
            j.company AS `company`,
            j.editdate AS `postdate`,
            i.state AS `state`,
            i.prettycity `city`,
            i.first_zipcode AS `zipcode`,
            c.category AS `category`,
            j.deleted AS deleted,
            j.seo_url AS seo_url
        FROM `portland_site`.jobs_searchable s
        LEFT JOIN `portland_site`.jobs j ON j.alpha = s.job_alpha
        LEFT JOIN `portland_site`.cities i ON s.cities_id = i.cities_id
        LEFT JOIN `portland_site`.categories c ON j.category_alpha = c.alpha
        WHERE s.editdate > now() - INTERVAL 3 DAY
         AND s.cities_id IN (765) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

<!-- 2 rows in 0.001 seconds -->

<!-- findByParamsLJB( { city : 'Scott City', state : 'Missouri', zipcode : NULL, category : NULL, onlyFeatured : false, onlyNotFeatured : false, zipcodeNearby : false }, 0, 25, false ) -->

<!-- SELECT stateabbr FROM `localjobboard_com_-_site`.tblState WHERE statename LIKE 'Missouri' LIMIT 1 -->

<!-- SELECT CityID AS val FROM `localjobboard_com_-_site`.tblCity WHERE prettycityname LIKE 'Scott City' AND citystate LIKE 'MO' -->

<!-- 1 rows in 0 seconds -->

<!-- SELECT
            'LJB' AS `source`,
            j.JobID AS `id`,
            CONCAT('http://www.localjobboard.com/', j.domaincitystate, '-jobs/', j.JobID) AS `url`,
            j.JobTitle AS `title`,
            j.JobDesc AS `description`,
            j.BranchName AS `company`,
            j.datestamp AS `postdate`,
            j.JobState AS `state`,
            j.JobCity AS `city`,
            j.JobZip AS `zipcode`,
            c.categoryname AS `category`,
            j.deleted AS deleted,
            j.JobTitle AS seo_url
        FROM `localjobboard_com_-_site`.tblJob_searchable s
        
        LEFT JOIN `localjobboard_com_-_site`.tblJob j ON s.JobID = j.JobID
        LEFT JOIN `localjobboard_com_-_site`.tblCategory c ON j.CategoryID = c.CategoryID
        WHERE s.datestamp > NOW() - INTERVAL 14 DAY
         AND s.CityID IN (283535) 
        ORDER BY s.JobID DESC
        LIMIT 0, 25 -->

<!-- 0 rows in 0.001 seconds -->

<!-- findByParamsLJB( { city : 'Scott City', state : 'Missouri', zipcode : NULL, category : NULL, onlyFeatured : false, onlyNotFeatured : false, zipcodeNearby : false }, 0, 25, true ) -->

<!-- SELECT stateabbr FROM `localjobboard_com_-_site`.tblState WHERE statename LIKE 'Missouri' LIMIT 1 -->

<!-- SELECT CityID AS val FROM `localjobboard_com_-_site`.tblCity WHERE prettycityname LIKE 'Scott City' AND citystate LIKE 'MO' -->

<!-- 
                        SELECT d.cityIDNearby AS val
                        FROM `localjobboard_com_-_site`.tblCityDistance d
                        WHERE d.cityIDSearchable = '283535'
                        AND d.distance < 100
                        ORDER BY d.distance ASC
                        LIMIT 75
                     -->

<!-- 75 rows in 0.006 seconds -->

<!-- SELECT
            'LJB' AS `source`,
            j.JobID AS `id`,
            CONCAT('http://www.localjobboard.com/', j.domaincitystate, '-jobs/', j.JobID) AS `url`,
            j.JobTitle AS `title`,
            j.JobDesc AS `description`,
            j.BranchName AS `company`,
            j.datestamp AS `postdate`,
            j.JobState AS `state`,
            j.JobCity AS `city`,
            j.JobZip AS `zipcode`,
            c.categoryname AS `category`,
            j.deleted AS deleted,
            j.JobTitle AS seo_url
        FROM `localjobboard_com_-_site`.tblJob_searchable s
        
        LEFT JOIN `localjobboard_com_-_site`.tblJob j ON s.JobID = j.JobID
        LEFT JOIN `localjobboard_com_-_site`.tblCategory c ON j.CategoryID = c.CategoryID
        WHERE s.datestamp > NOW() - INTERVAL 14 DAY
        AND s.CityID IN (297386, 297387, 283076, 283077, 297126, 283094, 283003, 297227, 283430, 283431, 283289, 297159, 283627, 297375, 297376, 283060, 297282, 297402, 297170, 297413, 282998, 283345, 283388, 283426, 297097, 297452, 296940, 282963, 297169, 283005, 296775, 283546, 283547, 283095, 297228, 283370, 283371, 283372, 296860, 296861, 283129, 296906, 296773, 283428, 283227, 283228, 297034, 283449, 283450, 282969, 282970, 283536, 283537, 297033, 283578, 283451, 283215, 283216, 276948, 296920, 278133, 278134, 283635, 283636, 297277, 297102, 297132, 283445, 283157, 283014, 277449, 283379, 296813, 283170, 297031) 
        ORDER BY s.JobID DESC
        LIMIT 0, 25 -->

<!-- 0 rows in 0.002 seconds -->

<!-- findByParamsLJB( { city : 'Scott City', state : 'Missouri', zipcode : NULL, category : NULL, onlyFeatured : false, onlyNotFeatured : false, zipcodeNearby : false }, 0, 25, true ) -->

<!-- SELECT z.zipcode FROM `localjobboard_com_-_site`.tblZipLookup z WHERE z.city LIKE 'Scott City' AND z.statename LIKE 'Missouri' AND z.country_id = 236 LIMIT 1 -->

<!-- 
                    SELECT zb.zipcode AS val
                    FROM `localjobboard_com_-_site`.tblZipLookup za
                    LEFT JOIN `localjobboard_com_-_site`.tblZipcodeDistance d ON za.zipid = d.zipIDSearchable
                    LEFT JOIN `localjobboard_com_-_site`.tblZipLookup zb ON d.zipIDNearby = zb.zipid
                    WHERE za.zipcode = '63780'
                    AND d.distance < 100
                    ORDER BY d.distance ASC
                    LIMIT 75
                 -->

<!-- 0 rows in 0.001 seconds -->

<!-- SELECT
            'LJB' AS `source`,
            j.JobID AS `id`,
            CONCAT('http://www.localjobboard.com/', j.domaincitystate, '-jobs/', j.JobID) AS `url`,
            j.JobTitle AS `title`,
            j.JobDesc AS `description`,
            j.BranchName AS `company`,
            j.datestamp AS `postdate`,
            j.JobState AS `state`,
            j.JobCity AS `city`,
            j.JobZip AS `zipcode`,
            c.categoryname AS `category`,
            j.deleted AS deleted,
            j.JobTitle AS seo_url
        FROM `localjobboard_com_-_site`.tblJob_searchable s
        
        LEFT JOIN `localjobboard_com_-_site`.tblJob j ON s.JobID = j.JobID
        LEFT JOIN `localjobboard_com_-_site`.tblCategory c ON j.CategoryID = c.CategoryID
        WHERE s.datestamp > NOW() - INTERVAL 14 DAY
         AND false 
        ORDER BY s.JobID DESC
        LIMIT 0, 25 -->

<!-- 0 rows in 0 seconds -->

<!-- SELECT categoryname FROM `localjobboard_com_-_site`.tblCategory GROUP BY categoryname ORDER BY categoryname -->

    
    <html>

    <head>
        <meta name="google-site-verification" content="pc_rfwoHOWypm_0JcIoYpPj5HjRmsCnFTb6zGjBrqiM" />
        <meta http-equiv="Content-Language" content="en-us">
        <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

                    <title>Scott City, Missouri Jobs - Recruiter Networks</title>
        
        <meta name="robots" content="index,follow">
        <meta name="description" content="Recruiter, jobs, free resumes, recruiter networks, local job boards, local job board, local resume, resumes, job board, recruiters, job postings, local jobs, free resume">
                    <meta name="keywords" content="Recruiter, jobs, Scott City Jobs, Scott City Missouri Jobs, Missouri Jobs">
                <meta name="revisit-after" content="7 days">

        <link rel="stylesheet" type="text/css" href="/styles.css" />

        <script type="text/javascript" src="/js/jquery.js"></script>
        <script type="text/javascript" src="/js/script.js"></script>

    </head>

    <body class="job_list">

    
    <div id="header">
        <div class="inner">
            <a href="http://recruiternetworks.com/" title="" id="masthead">Recruiter Networks</a>
            <a href="http://recruiternetworks.com/" id="recruiter_media_logo">Receruiter Media, Inc.</a>
            <div id="tagline">the <em>smart</em> solution for local jobs</div>
        </div>
    </div>

    <div id="wrapper">
        <div id="content">


    <div class="job_list">

        <div class="linklist">
            <em>Browse by categories in Scott City:</em><br><br>
                            <a href="/Scott+City, MO Jobs in Accounting+.+Finance">Accounting & Finance</a><br>
                            <a href="/Scott+City, MO Jobs in Accounting%2C+Auditing">Accounting, Auditing</a><br>
                            <a href="/Scott+City, MO Jobs in Administration%2C+Clerical">Administration, Clerical</a><br>
                            <a href="/Scott+City, MO Jobs in Administrative+.+Office">Administrative & Office</a><br>
                            <a href="/Scott+City, MO Jobs in Advertising">Advertising</a><br>
                            <a href="/Scott+City, MO Jobs in Advertising+.+Marketing+.+PR">Advertising & Marketing & PR</a><br>
                            <a href="/Scott+City, MO Jobs in Aerospace">Aerospace</a><br>
                            <a href="/Scott+City, MO Jobs in Agriculture%2C+Forestry+%26+Fishing">Agriculture, Forestry & Fishing</a><br>
                            <a href="/Scott+City, MO Jobs in Agriculture%2C+Horticulture%2C+Fishing+%26+Forestry">Agriculture, Horticulture, Fishing & Forestry</a><br>
                            <a href="/Scott+City, MO Jobs in Architecture">Architecture</a><br>
                            <a href="/Scott+City, MO Jobs in Automotive%2C+Auto+Tech+%26+Mechanic">Automotive, Auto Tech & Mechanic</a><br>
                            <a href="/Scott+City, MO Jobs in Banking">Banking</a><br>
                            <a href="/Scott+City, MO Jobs in Biotech+.+Pharmaceutical">Biotech & Pharmaceutical</a><br>
                            <a href="/Scott+City, MO Jobs in Biotechnology+and+Pharmacy">Biotechnology and Pharmacy</a><br>
                            <a href="/Scott+City, MO Jobs in Business+Opportunities">Business Opportunities</a><br>
                            <a href="/Scott+City, MO Jobs in Career+Fairs+.+Hiring+Events">Career Fairs & Hiring Events</a><br>
                            <a href="/Scott+City, MO Jobs in Communications%2C+Media+%26+Marketing">Communications, Media & Marketing</a><br>
                            <a href="/Scott+City, MO Jobs in Construction">Construction</a><br>
                            <a href="/Scott+City, MO Jobs in Construction+-+Building+Trades">Construction - Building Trades</a><br>
                            <a href="/Scott+City, MO Jobs in Construction+-+Management">Construction - Management</a><br>
                            <a href="/Scott+City, MO Jobs in Consulting">Consulting</a><br>
                            <a href="/Scott+City, MO Jobs in Customer+Service+%26+Call+Center">Customer Service & Call Center</a><br>
                            <a href="/Scott+City, MO Jobs in Design%2C+Graphic+Design+%26+CAD">Design, Graphic Design & CAD</a><br>
                            <a href="/Scott+City, MO Jobs in Diversity">Diversity</a><br>
                            <a href="/Scott+City, MO Jobs in Education">Education</a><br>
                            <a href="/Scott+City, MO Jobs in Education+.+Teaching">Education & Teaching</a><br>
                            <a href="/Scott+City, MO Jobs in Employee+Benefits">Employee Benefits</a><br>
                            <a href="/Scott+City, MO Jobs in Energy+.+Utilities">Energy & Utilities</a><br>
                            <a href="/Scott+City, MO Jobs in Engineering">Engineering</a><br>
                            <a href="/Scott+City, MO Jobs in Entertainment">Entertainment</a><br>
                            <a href="/Scott+City, MO Jobs in Environmental+.+Health+.+Safety">Environmental & Health & Safety</a><br>
                            <a href="/Scott+City, MO Jobs in Event+.+Promo+Personnel">Event & Promo Personnel</a><br>
                            <a href="/Scott+City, MO Jobs in Executive">Executive</a><br>
                            <a href="/Scott+City, MO Jobs in Executive+.+Management">Executive & Management</a><br>
                            <a href="/Scott+City, MO Jobs in Exercise+and+Fitness">Exercise and Fitness</a><br>
                            <a href="/Scott+City, MO Jobs in Fashion+.+Modeling">Fashion & Modeling</a><br>
                            <a href="/Scott+City, MO Jobs in Finance">Finance</a><br>
                            <a href="/Scott+City, MO Jobs in Food+Service">Food Service</a><br>
                            <a href="/Scott+City, MO Jobs in Government">Government</a><br>
                            <a href="/Scott+City, MO Jobs in Government+%26+Protective+Services">Government & Protective Services</a><br>
                            <a href="/Scott+City, MO Jobs in Health+Care">Health Care</a><br>
                            <a href="/Scott+City, MO Jobs in Healthcare">Healthcare</a><br>
                            <a href="/Scott+City, MO Jobs in Healthcare%2C+Other">Healthcare, Other</a><br>
                            <a href="/Scott+City, MO Jobs in Healthcare%2C+Practitioner+and+Technician">Healthcare, Practitioner and Technician</a><br>
                            <a href="/Scott+City, MO Jobs in Hospitality+.+Retail">Hospitality & Retail</a><br>
                            <a href="/Scott+City, MO Jobs in Hospitality+%26+Tourism">Hospitality & Tourism</a><br>
                            <a href="/Scott+City, MO Jobs in Human+Resources">Human Resources</a><br>
                            <a href="/Scott+City, MO Jobs in Information+Technology">Information Technology</a><br>
                            <a href="/Scott+City, MO Jobs in Installation%2C+Maintenance+%26+Repair">Installation, Maintenance & Repair</a><br>
                            <a href="/Scott+City, MO Jobs in Insurance">Insurance</a><br>
                            <a href="/Scott+City, MO Jobs in IT+.+Software+.+Systems">IT & Software & Systems</a><br>
                            <a href="/Scott+City, MO Jobs in Journalism+.+Writing+.+Editing">Journalism & Writing & Editing</a><br>
                            <a href="/Scott+City, MO Jobs in Labor">Labor</a><br>
                            <a href="/Scott+City, MO Jobs in Labor+.+Trades">Labor & Trades</a><br>
                            <a href="/Scott+City, MO Jobs in Law+Enforcement">Law Enforcement</a><br>
                            <a href="/Scott+City, MO Jobs in Legal">Legal</a><br>
                            <a href="/Scott+City, MO Jobs in Library+%26+Museum">Library & Museum</a><br>
                            <a href="/Scott+City, MO Jobs in Logistics%2C+Transportation+%26+Drivers">Logistics, Transportation & Drivers</a><br>
                            <a href="/Scott+City, MO Jobs in Maintenance+%26+Repair">Maintenance & Repair</a><br>
                            <a href="/Scott+City, MO Jobs in Management+%26+Business">Management & Business</a><br>
                            <a href="/Scott+City, MO Jobs in Manufacturing">Manufacturing</a><br>
                            <a href="/Scott+City, MO Jobs in Media%2C+Journalism%2C+Printing+and+Publishing">Media, Journalism, Printing and Publishing</a><br>
                            <a href="/Scott+City, MO Jobs in Merchandising">Merchandising</a><br>
                            <a href="/Scott+City, MO Jobs in Military">Military</a><br>
                            <a href="/Scott+City, MO Jobs in Military+%26+Defense">Military & Defense</a><br>
                            <a href="/Scott+City, MO Jobs in Mortgage">Mortgage</a><br>
                            <a href="/Scott+City, MO Jobs in Multilingual">Multilingual</a><br>
                            <a href="/Scott+City, MO Jobs in Non-Profit+Organizations">Non-Profit Organizations</a><br>
                            <a href="/Scott+City, MO Jobs in Operations%2C+Logistics+%26+Warehousing">Operations, Logistics & Warehousing</a><br>
                            <a href="/Scott+City, MO Jobs in Other">Other</a><br>
                            <a href="/Scott+City, MO Jobs in Pharmacist">Pharmacist</a><br>
                            <a href="/Scott+City, MO Jobs in PR+.+Public+Relations">PR & Public Relations</a><br>
                            <a href="/Scott+City, MO Jobs in Professional">Professional</a><br>
                            <a href="/Scott+City, MO Jobs in Professions">Professions</a><br>
                            <a href="/Scott+City, MO Jobs in Real+Estate">Real Estate</a><br>
                            <a href="/Scott+City, MO Jobs in Retail+-+All">Retail - All</a><br>
                            <a href="/Scott+City, MO Jobs in Retail+-+Hourly">Retail - Hourly</a><br>
                            <a href="/Scott+City, MO Jobs in Retail+-+Management">Retail - Management</a><br>
                            <a href="/Scott+City, MO Jobs in Sales">Sales</a><br>
                            <a href="/Scott+City, MO Jobs in Science%2C+Research+%26+Development">Science, Research & Development</a><br>
                            <a href="/Scott+City, MO Jobs in Seasonal+Jobs">Seasonal Jobs</a><br>
                            <a href="/Scott+City, MO Jobs in Securities+.+Investment">Securities & Investment</a><br>
                            <a href="/Scott+City, MO Jobs in Social+Services">Social Services</a><br>
                            <a href="/Scott+City, MO Jobs in Sports%2C+Recreation+%26+Fitness">Sports, Recreation & Fitness</a><br>
                            <a href="/Scott+City, MO Jobs in Systems+.+IT+.+Software">Systems & IT & Software</a><br>
                            <a href="/Scott+City, MO Jobs in Tax+Specialists">Tax Specialists</a><br>
                            <a href="/Scott+City, MO Jobs in Telecom">Telecom</a><br>
                            <a href="/Scott+City, MO Jobs in Web+.+Graphic+Design">Web & Graphic Design</a><br>
                            <a href="/Scott+City, MO Jobs in Wireless+.+Mobile">Wireless & Mobile</a><br>
                            <a href="/Scott+City, MO Jobs in Work+From+Home">Work From Home</a><br>
                    </div>

        <h1>Jobs in Scott City, Missouri</h1>

                
            <div class="job_line">
                <span class="title"><a href="/job/R446257485/other_jobs/part_time_online_teacher_for_children">Part-time Online Teacher for Children</a></span><br>
                Posted for VIPKID  in Other             </div>

        
            <div class="job_line">
                <span class="title"><a href="/job/R446257307/other_jobs/substitute_teachers_teach_children_online">Substitute Teachers - Teach Children Online</a></span><br>
                Posted for VIPKID  in Other             </div>

        
        <div class="pagination">
                                </div>

    </div>

    
    <div id="footer">
        <div class="inner">
            <p>
                &copy; Copyright <a href="http://www.recruiternetworks.com">Recruiter Networks, Inc</a> - All rights reserved
            </p>

            <p>
                <script type="text/javascript"><!--
                    google_ad_client = "pub-5717467728757135";
                    /* 728x90, created 8/18/10 */
                    google_ad_slot = "8001320628";
                    google_ad_width = 728;
                    google_ad_height = 90;
                    //-->
                </script>
                <script type="text/javascript"
                        src="https://pagead2.googlesyndication.com/pagead/show_ads.js">
                </script>
            <p>
                &copy; 2014 -- <a href="http://www.recruitermedia.com">Recruiter Media Inc.</a> - All rights reserved
            </p>
            <p>
                <a href="/about.php">About Us</a> | <a href="/contact.php">Contact</a>
            </p>
        </div><!-- .inner -->
    </div><!-- #footer -->

        </div><!-- #wrapper -->
    </div><!-- #content -->

    
    </body>
    </html>


<!-- CacheControl: maxAge=43200, startTime=2017-10-22 04:42:34, sent=true -->