メキシコ求人情報とメキシコ就職・転職サポート

SELECT ID, job_desc, cid, ctype, cloc, post_title, post_type, mmark, salary_value, raising_bonus, working_time, holiday_vacation, insurance, allowances, essential_requirement, welcome_requirement, all_requirement, apply_for_new_graduate_students, visa_support, other, job_offer_keywords, location_description, display_start_date FROM wp_posts WHERE mmark LIKE '%シニア層歓迎%' AND post_type='jobman_job' AND post_status='publish'