Love You
SELECT p.*, c.country_name, ct.contact_info
FROM peopleMaster p
LEFT JOIN countryMaster c ON p.country_id = c.id
LEFT JOIN contactMaster ct ON p.id = ct.person_id
WHERE p.id IN (
SELECT DISTINCT p.id
FROM peopleMaster p
JOIN skills s ON p.id = s.person_id
WHERE p.job_title IN ('Full Stack Developer', 'Web Developer', 'Backend Developer')
OR s.skill_name IN ('PHP', 'Javascript', 'Codeigniter 4', 'Laravel', 'Express js', 'Nodejs')
)
AND p.status = 'available';{
"status": "success",
"message": "You found me! Here's what I know."
}
