| | |
|---|
| | | bdb.dict_value as eventTypeName |
|---|
| | | from YWXT.sm_hk_event she |
|---|
| | | left join YWXT.blade_dict_biz bdb on bdb.dict_key = she.event_type and bdb.is_deleted = 0 and code = 'EVENT_TYPE' |
|---|
| | | left join SJZT_MD."att_wmst_base" awb on awb."video_guid" = she.src_index |
|---|
| | | left join ( |
|---|
| | | select "res_guid","video_guid" from SJZT_MD."att_wmst_base" |
|---|
| | | union all |
|---|
| | | select "regionindexcode" as "res_guid","gbindexcode" as "video_guid" from SJZT_ODS."haik_gb_wmst_base" |
|---|
| | | ) |
|---|
| | | awb on awb."video_guid" = she.src_index |
|---|
| | | left join SJZT_MD."att_res_base" a on a."guid" = awb."res_guid" |
|---|
| | | left join SJZT_MD."att_ad_base" b on b."guid" = a."interior_ad_guid" |
|---|
| | | LEFT JOIN SJZT_MD."att_ad_base" c ON b."p_ad_code" = c."guid" |
|---|
