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

<!-- findByParamsRN( { city : 'Drexel Heights', state : 'Arizona', 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 'Drexel Heights' -->

<!-- 1 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 s.cities_id IN (643) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

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

<!-- findByParamsRN( { city : 'Drexel Heights', state : 'Arizona', 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 'Drexel Heights' -->

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

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

<!-- 27 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 (42, 994, 993, 647, 650, 642, 646, 80, 78, 47, 81, 79, 77, 319, 375, 82, 651, 482, 652, 995, 18, 649, 644, 648, 303, 483, 645) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

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

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

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

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

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

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

<!-- SELECT categoryname FROM `localjobboard_com_-_site`.tblCategory GROUP BY categoryname ORDER BY categoryname -->
MySQL Error: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space