SELECT * FROM candidate_profile WHERE cand_designation = 'Marketing Director' AND cand_keyskills = 'Accounting, Accounts Payable, Accounts Receivable, Admissions' AND cand_currentstate = 'Bihar' AND cand_currentcity = 'Banka' AND cand_preferredstate = 'Chhattisgarh' AND cand_preferredcity = 'Balrampur' AND cand_yearofpass = '2020' AND cand_edulevel = 'Graduation' AND cand_industry = 'Finance' AND cand_funcarea = 'Financial Reporting' AND cand_role = 'Marketing Director' AND cand_jobtype = 'Part Time' AND cand_emptype = 'Permanent' AND cand_shift = 'Night' AND cand_joiningdetail = 'Availabile to Join' AND cand_gender = 'Male'