Error: 2013 Lost connection to MySQL server during query
The following SQL statement was executed:
select /*get_job_num_by_positions*/ * , get_positions(id,'en',1,'') name from ( select
distinct position_id id ,jobs_positions_cache.parent_id r_parent_id, if(jobs_positions_cache.parent_id is null ,position_id,jobs_positions_cache.parent_id) c_parent_id,count(distinct jobs_positions_cache.job_id) num from jobs_positions_cache,jobs_locations_cache ,jobs_industries_cache where jobs_positions_cache.job_id = jobs_locations_cache.job_id and location_id in (39) and jobs_positions_cache.job_id = jobs_industries_cache.job_id and jobs_industries_cache.industry_id in (6) group by position_id
order by c_parent_id,r_parent_id ) temp
|
|
| Beijing | Shanghai | Dalian | Tianjin | Shenzhen | |
Teacher | Accounter | Engineer | Project Manager | HR Recruitment | |
| Campus | Power System | Sales | English | Fresh Graduates | |
Banking | Legal | Internet | Advertising | Computer-Software |

