SELECT f.* FROM `flexbase-platform-production.gold.finance__loan_tape` f 
join `flexbase-platform-production.silver.credit_limit_by_day` t3
on f.company_id = t3.company_id
join `flexbase-platform-production.bronze_platform_identity.businesses` t2
on t3.company_id = t2.id
join `flexbase-platform-production.bronze_platform_accounting.rutter_links` t1 
on t2.account_id = t1.account_id where t3.credit_limit>0 and t1.status='active'