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

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

<!-- 0 rows in 0.003 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.004 seconds -->

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

<!-- 0 rows in 0.004 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.001 seconds -->

<!-- findByParamsRN( { city : 'Tylersville', 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 'Tylersville' AND citystate LIKE 'PA' -->

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

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

<!-- 5 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 (924, 923, 925, 464, 466) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

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

<!-- findByParamsLJB( { city : 'Tylersville', 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 'Tylersville' AND citystate LIKE 'PA' -->

<!-- 1 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 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)