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

<!-- findByParamsRN( { city : 'Greenstone', state : 'Pennsylvania', 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 'Greenstone' -->

<!-- 0 rows in 0.014 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 : 'Greenstone', state : 'Pennsylvania', 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 'Greenstone' -->

<!-- 0 rows in 0.003 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 : 'Greenstone', state : 'Pennsylvania', zipcode : NULL, category : NULL, onlyFeatured : false, onlyNotFeatured : false, zipcodeNearby : false }, 0, 25, true ) -->

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

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

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

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

<!-- 38 rows in 0.004 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 (566, 808, 924, 440, 809, 439, 564, 567, 811, 807, 1010, 814, 803, 627, 3, 812, 970, 568, 810, 804, 370, 626, 813, 565, 925, 805, 965, 25, 256, 806, 1021, 964, 623, 259, 968, 923, 624, 464) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

<!-- 25 rows in 0.005 seconds -->

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

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

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

<!-- 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.JobState LIKE 'Pennsylvania' 
        ORDER BY s.JobID DESC
        LIMIT 0, 25 -->

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

<!-- SELECT categoryname FROM `localjobboard_com_-_site`.tblCategory GROUP BY categoryname ORDER BY categoryname -->
MySQL Error: Can't change size of file (OS errno 28 - No space left on device)