select t_recruit.titile as titile, t_recruit.industry as industry, t_recruit.duty_place as duty_place, t_recruit.qualification as qualification, t_recruit.salary as salary, t_recruit.working_hours as working_hours, t_recruit.holiday as holiday, t_recruit.nearest_station as nearest_station, t_recruit.tel as tel, t_recruit.mail as mail, t_recruit.application as application, t_recruit.service as service, t_recruit.message as message from t_recruit where t_recruit.shop_id = 1