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

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

<!-- 1 rows in 0.012 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 (652) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

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

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

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

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

<!-- 40 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 s.cities_id IN (651, 995, 82, 18, 77, 319, 375, 79, 81, 482, 47, 78, 80, 646, 642, 649, 648, 483, 647, 993, 994, 42, 643, 645, 644, 303, 641, 650, 659, 673, 197, 99, 90, 996, 664, 347, 92, 327, 270, 324) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

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

<!-- findByParamsLJB( { city : 'Sun City West', 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 'Sun City West' AND citystate LIKE 'AZ' -->

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

<!-- 25 rows in 0.006 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