select age
,agegroup
,sex
,pref
,builddv
,schooldv
,schoolsp
,anninc
,anntur
,we_ipo
,we_empnum
,we_capital
,occupacate
,occupaname
,post
,regperiod
,jobchcnt
,we_empform
,jobname
,catename as j_catename
,userid
,nickname
,userattrib
,quesnum
from queslist as ql
inner join jbn_job as jjob on we_job = jobid
inner join jbn_cate as jcat on we_cat = jcat.cateid
where catename = '化学・素材・化成品関連'
where catename = 'IT・通信・インターネット関連'
where catename = '電気電子半導体関連'
where catename = '医療・医療機器・福祉関連'
where catename = '建築・土木・不動産'
where catename = '機械・メカトロ関連'
where catename = '医薬・バイオ・食品関連'
where catename = '営業・海外営業'
where catename = '金融系スペシャリスト'
and (occupacate = '1' or userattrib = 'J')
and (openflag = 'Y' or userattrib = 'J')
order by anninc desc