select ci.item_id as ad_id, cr.title from cr_items ci, cr_revisions cr where ci.latest_revision = cr.revision_id and content_type = 'ca_ad' $where_clause