SELECT
    projects.project_id,
    projects.project_name,
    projects.description,
    projects.live_flag,
    projects.clientid,
    projects.project_id,
    projects.progress

FROM
    projects,
    proj_contractor
    
WHERE

    projects.project_id = proj_contractor.project_id
    AND projects.live_flag = 1
    AND proj_contractor.userid = ##userid##



##where_sql##

GROUP BY projects.project_id DESC