( SELECT `jobs`.`id`,jobs.id AS is_delivery,jobs.id AS is_collection,`jobs`.`title`,`jobs`.`update_time`,`jobs`.`refresh_time`,`jobs`.`salary_min`,`jobs`.`salary_max`,`jobs`.`salary_year`,`jobs`.`jobs_welfare`,`jobs`.`company_id`,`jobs`.`view`,`jobs`.`top`,`jobs`.`recommend`,`jobs`.`urgent`,`jobs`.`create_time`,`jobs`.`salary_type`,`jobs`.`salary_cycle`,`jobs`.`jobs_type`,`jobs`.`education_level`,`jobs`.`exp_level`,`jobs`.`jobs_area1`,`jobs`.`jobs_area2`,`jobs`.`jobs_area3` FROM `xycms_jobs` `jobs` WHERE (  `jobs`.`company_id` = 504  AND `jobs`.`examine` IN (0,1)  AND `jobs`.`status` = 1 ) AND `jobs`.`delete_time` IS NULL ORDER BY jobs.urgent desc,jobs.top desc,jobs.refresh_time desc,jobs.id desc )

( SELECT `jobs`.`id`,jobs.id AS is_delivery,jobs.id AS is_collection,`jobs`.`title`,`jobs`.`update_time`,`jobs`.`refresh_time`,`jobs`.`salary_min`,`jobs`.`salary_max`,`jobs`.`salary_year`,`jobs`.`jobs_welfare`,`jobs`.`company_id`,`jobs`.`view`,`jobs`.`top`,`jobs`.`recommend`,`jobs`.`urgent`,`jobs`.`create_time`,`jobs`.`salary_type`,`jobs`.`salary_cycle`,`jobs`.`jobs_type`,`jobs`.`education_level`,`jobs`.`exp_level`,`jobs`.`jobs_area1`,`jobs`.`jobs_area2`,`jobs`.`jobs_area3` ,@rk := @rk+1 as `index` FROM `xycms_jobs` `jobs` ,(select @rk:=0)  `index`WHERE (  `jobs`.`company_id` = 504  AND `jobs`.`examine` IN (0,1)  AND `jobs`.`status` = 1 ) AND `jobs`.`delete_time` IS NULL ORDER BY jobs.urgent desc,jobs.top desc,jobs.refresh_time desc,jobs.id desc )