|
|
||
|
|
|
法律提示:
 热门城市: |
北京招聘 | 上海招聘 | 大连招聘 | 天津招聘 | 深圳招聘 | 热门职位: |
教师招聘 | 会计招聘 | 工程师招聘 | 项目经理招聘 | 人力资源招聘 |
| 热门关键字: |
校园招聘 | 电力招聘 | 销售招聘 | 英语招聘 | 应届生招聘 | 热门行业: |
银行招聘 | 法律招聘 | 互联网招聘 | 广告招聘 | 计算机软件招聘 |
Error: 1146 Table 'meijob.jobs_locations' doesn't exist
The following SQL statement was executed:
select *,get_job_name(job_id,'cn') job_name from (select distinct jobs.id job_id,jobs.featured,jobs.posted_datetime,jobs.`expiration_datetime`
from jobs,jobs_locations,jobs_positions,jobs_employee_types,jobs_languages,jobs_locations jl,jobs_positions jp
where jobs.id = jobs_locations.job_id
and jobs.id = jobs_positions.job_id
and jobs.id = jobs_languages.job_id
and jobs.id = jobs_employee_types.job_id
and jobs_locations.location_id = jl.location_id and jl.job_id = 5603381
and jobs_positions.position_id = jp.position_id and jp.job_id = 5603381
and jobs_employee_types.`employee_type_id` in (select employee_type_id from jobs_employee_types where job_id = 5603381)
and jobs.`diploma_id` >= (select diploma_id from jobs where jobs.id = 5603381)
and jobs.id <> 5603381
and (featured != 'd' or featured is null) limit 0,5 ) temp
Error: 0
The following SQL statement was executed:
select *,get_job_name(job_id,'cn') job_name from (select distinct jobs.id job_id,jobs.featured,jobs.posted_datetime,jobs.`expiration_datetime` from jobs,jobs_locations,jobs_positions,jobs_languages,jobs_locations jl,jobs_positions jp
where jobs.id = jobs_locations.job_id
and jobs.id = jobs_languages.job_id
and jobs.id = jobs_positions.job_id
and jobs_locations.location_id = jl.location_id and jl.job_id = 5603381
and jobs_positions.position_id = jp.position_id and jp.job_id = 5603381
and jobs.id <> 5603381
and (featured != 'd' or featured is null) limit 0,5 ) temp
Error: 0
The following SQL statement was executed:
select *,get_job_name(job_id,'cn') job_name from (select distinct jobs.id job_id,jobs.featured,get_job_name(id,'cn') job_name,jobs.posted_datetime,jobs.`expiration_datetime` from jobs,jobs_locations,jobs_positions,jobs_positions jp
where jobs.id = jobs_locations.job_id
and jobs.id = jobs_positions.job_id
and jobs_positions.position_id = jp.position_id
and jp.job_id = 5603381
and jobs.id <> 5603381
limit 0,5 ) temp
Error: 0
The following SQL statement was executed:
select *,get_job_name(job_id,'cn') job_name from (select seekers_jobs.job_id,count(sj.seeker_id) number
from seekers_jobs ,seekers_jobs sj
where seekers_jobs.seeker_id = sj.seeker_id
and sj.seeker_id !=1
and sj.job_id = 5603381
and sj.`saved` = 's'
and seekers_jobs.job_id != 5603381
and seekers_jobs.saved = 's'
group by seekers_jobs.job_id order by number desc limit 0,5 ) temp