select b.bug_number from bt_bugs b where b.bug_id = :bug_id and b.project_id = :package_id select revision_id, cr_revisions.title as filename from acs_data_links, cr_items, cr_revisions where object_id_one = :bug_id and object_id_two = :related_object_id and cr_items.item_id = object_id_two and (content_type = 'content_revision' or content_type = 'image') and live_revision = revision_id