SELECT
    COUNT(*) AS page_count

FROM
    projects,
    proj_contractor
    
WHERE

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



##where_sql##