--'usr_3t7nh9pkvax1j6412nv1' select * from ( with promotions as ( SELECT * FROM EXTERNAL_QUERY("reby-cloud.eu.reby_prod", ''' SELECT id_to_time(id) as created_at, concat('acc_',id_to_text(account_id)) as account_id, balance__amount as balance_amount, balance__currency as balance_currency, concat('c_',id_to_text(company_id)) as company_id, free_unlocks, concat('cpua_',id_to_text(id)) as id, concat('tx_',id_to_text(last_promotion_transaction_id)) as transaction_id, concat('usr_',id_to_text(user_id)) as user_id FROM company_user_promotion_account --where user_id = id_from_text('3t7nh9pkvax1j6412nv1') ; ''' ) ) select * from ( SELECT --promotions.balance_amount, sa.service_area, cp.code, cpu.* FROM `reby-cloud.analytics_reby_v1_eu.pg_company_promotion_usage` cpu left join `reby-cloud.analytics_reby_v1_eu.pg_company_promotion` cp on cpu.company_promotion_id = cp.id left join `reby-cloud.analytics_reby_v1_eu.reby_users_servicearea` sa on sa.user_id = cpu.user_id --left join promotions on cpu.user_id =promotions.user_id --where sa.service_area in ('Zaragoza','Gijón') --and date(expiration_date) > current_date and date(cpu.created_at) > current_date -15 --where cpu.user_id = 'usr_3t7nh9pkvax1j6412nv1' --order by cpu.created_at desc ) where (service_area = 'Zaragoza' AND code in ('SEVILLAES','REBYBCN','REBYJON','REBYGONA','SEVILLAES','TOTAREBY','HOLAMOTOS')) OR (service_area = 'Sevilla' AND code in ('REBYBCN','REBYJON','REBYGONA','TOTAREBY','HOLAMOTOS','REBYGO')) OR (service_area = 'Gijón' AND code in ('SEVILLAES','REBYBCN','REBYGONA','SEVILLAES','TOTAREBY','HOLAMOTOS')) OR (service_area = 'Terrassa' AND code in ('SEVILLAES','REBYBCN','REBYGONA','SEVILLAES')) OR (service_area in ('Napoles','Lecce','Minturno','Bergamo','Grosseto','Caserta') AND code in ('SEVILLAES','REBYBCN','REBYJON','REBYGONA','SEVILLAES','REBYGO','HOLAMOTOS')) ) --where user_id = 'usr_3t7nh9pkvax1j6412nv1' where value_remaining_amount > 0 and is_expired is false
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter