SELECT pr.project_id FROM projects AS pr, users_table AS ut, client_table AS ct WHERE ut.userid = ##userid## AND pr.clientid = ct.client_id AND pr.project_id = ##project_id## AND ut.client_id = ct.client_id