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": "Thank you for coming here! Results will be displayed if you click on the results below."
}↲ results ⟪23/11/2024⟫
Experienced in developing applications using PHP, JavaScript, RESTful API, and databases such as MySQL, PostgreSQL, and MS SQL Server. Proficient in frameworks like Laravel, CodeIgniter 4, and ExpressJS. Also experienced in providing technical support for user issues and handling application deployment.
