select distinct k.name as keyword,'google_us' as Search_Engine,
subdate((STR_TO_DATE(CONCAT(gksr.week_indexed, ' Sunday'), '%X%V %W')), INTERVAL 7 DAY) AS RightDate,
gksr.rank as Rank
, gksr.url as Url
from keywords k
join google_keyword_serp_results gksr on k.id = gksr.keyword_id
  and domain_id = (select domain_id from domains_accounts
where account_id = [ACCOUNTID]) and domain_rank=1 and serp_type=1
join account_keyword_searchengines aks on aks.keyword_id = k.id
  and aks.account_id = [ACCOUNTID]
#where fkrs.week_indexed < 201532;