3 SELECT a.artifact_id AS patch_id,
13 a.group_artifact_id AS patch_group_id,
14 a.resolution_id AS resolution
15 FROM artifact a, groups g, artifact_group_list agl
16 WHERE a.group_artifact_id=agl.group_artifact_id
17 AND agl.group_id=g.group_id
18 AND agl.name='Patches';