with audit_keywords as (
    select sp_keyword_list.id,
           sp_keyword_list.created_at,
           asrr.record_id as other_id,
    asrr.report_date
    from sp_keyword_list
             inner join sponsored_products_14d_metrics asrr on sp_keyword_list.record_id = asrr.record_id
    where

        sp_keyword_list.id = 1
)
select * from audit_keywords;
