
<!-- get_search_category_jobs: SELECT job_alpha FROM searchCategories_JobsByCity WHERE search_category_id=3 AND cities_id=2 ORDER BY `rank` ASC -->

<!-- get_search_category_jobs: 
        SELECT 
            j.alpha as job_alpha,
            s.cities_id, 
            j.title, 
            DATE_FORMAT(s.editdate, '%m/%e/%Y') as editdate, 
            j.location, 
            j.company, 
            j.maintext,
            j.seo_url  
        FROM jobs j 
        INNER JOIN jobs_searchable s ON j.alpha = s.job_alpha
        WHERE j.alpha IN () 
        AND s.featured = 1 
        ORDER BY field(j.alpha, ) -->

<!-- get_search_category_jobs: SELECT job_alpha FROM searchCategories_JobsByCity WHERE search_category_id=3 AND cities_id=2 ORDER BY `rank` ASC LIMIT 0, 20 -->

<!-- get_search_category_jobs: 
        SELECT 
            j.alpha as job_alpha,
            s.cities_id, 
            j.title, 
            DATE_FORMAT(s.editdate, '%m/%e/%Y') as editdate, 
            j.location, 
            j.company, 
            j.maintext,
            j.seo_url  
        FROM jobs j 
        INNER JOIN jobs_searchable s ON j.alpha = s.job_alpha
        WHERE j.alpha IN () 
        ORDER BY field(j.alpha, ) -->
No jobs found.

<!-- CacheControl: maxAge=43200s, renderTime=0.071s, startTime=2020-07-06 22:52:39, cacheHeadersSent=true -->


<!-- Read from cache file /mnt/sdc/websites/portland/public_html/cache/1/2/4/8f5bd11d5b67f67e68dc356abab5b with age 18750s, renderTime=0s -->