kikukeii

SQL

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⟫

Hi 👋, I'm Miftakhuddin Falaki

💫 About Me:

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.

---

🌐 Socials:

💻 Tech Stack:

--- ### 👾 Most used languages & 🔝 Top Contributed Repo ---

💳 Support:

--- ### 🤖 Github Contribution