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

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

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

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

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

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

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

<!-- 40 rows in 0.005 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 (641, 648, 347, 92, 327, 270, 197, 99, 90, 996, 392, 649, 1013, 664, 324, 1011, 1012, 482, 27, 18, 303, 644, 690, 683, 995, 652, 651, 661, 375, 319, 82, 398, 198, 673, 77, 659, 79, 81, 483, 47) 
        ORDER BY s.job_alpha DESC
        LIMIT 0, 25 -->

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

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

<!-- 1 rows in 0.019 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.012 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