Offres de contrats à la pige en Services aux entreprises

string(973) "SELECT t1.id AS t1__id, t1.employer_id AS t1__employer_id, t1.job_title AS t1__job_title, t1.job_slug AS t1__job_slug, t1.job_description AS t1__job_description, t1.job_created_at AS t1__job_created_at, t1.job_modified_at AS t1__job_modified_at, t1.job_expires_at AS t1__job_expires_at, t1.job_country AS t1__job_country, t1.job_state AS t1__job_state, t1.job_zip_code AS t1__job_zip_code, t1.job_city AS t1__job_city, t1.company_name AS t1__company_name, t1.company_url AS t1__company_url, t1.company_email AS t1__company_email, t1.is_approved AS t1__is_approved, t1.is_active AS t1__is_active, t1.is_filled AS t1__is_filled, t1.is_featured AS t1__is_featured, t1.applications AS t1__applications, t1.read AS t1__read, t1.cache AS t1__cache FROM `78_9awpjb_job` AS `t1` INNER JOIN `78_9awpjb_tagged` AS `t2c` ON `t1`.`id`=`t2c`.`object_id` AND t2c.object='job' WHERE t2c.tag_id IN('35') ORDER BY t1.is_featured DESC, t1.job_created_at DESC, t1.id DESC LIMIT 250 OFFSET 0"