SELECT no_applicant,DATE_FORMAT(regist_date,'%y/%m/%d(%a)') as regist_date,DATE_FORMAT(renewal_date,'%y/%m/%d(%a)') as renewal_date,DATE_FORMAT(renewal_date,'%Y-%m-%dT%T') as rdf_date,last_login,name,name2,email,url,area,gyomu_shurui,workstyle,flag_anonymous,nickname,flag_status,soho_member,gender,birth_year,birth_month,birth_day,cert,cert_no,flag_kentei FROM applicant WHERE flag_public='A' AND flag_active != 'N' AND (soho_member = '1' OR soho_member = '2') AND (workstyle='在宅' OR workstyle='両方') AND area LIKE :type ORDER BY rank DESC,renewal_date DESC LIMIT 76,15 北陸のSOHOメンバー https://www.atsoho.com/jobinfo/index 北陸のSOHOメンバー ja 2019-10-21T04:33:58+09:00