修改下面的sql，所有查询el_requirement_apply和el_comp_info表的语句增加del_flag = '0' 的筛选条件，完整的sql如下：
SELECT gen_random_uuid() AS id,
( SELECT el_financial_institution.fi_full_name
FROM el_financial_institution
WHERE (((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND ((el_financial_institution.parent_id)::text = '-1'::text))) AS financeorgfullname,
efi.fi_code AS code,
COALESCE(( SELECT count(1) AS count
FROM el_granting_credit,
el_financial_institution
WHERE (((el_granting_credit.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::bigint) AS creditenterprisenum,
COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::bigint) AS loanenterprisenum,
COALESCE(( SELECT count(DISTINCT el_requirement_info.unisc_id) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::bigint) AS loanmicroenterprisenum,
COALESCE(( SELECT sum(el_granting_credit.granting_amount) AS sum
FROM el_granting_credit,
el_financial_institution
WHERE (((el_granting_credit.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::numeric) AS creditamount,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::numeric) AS loanamount,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::numeric) AS inclusivemicroenterpriseloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::bigint) AS loannum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric))), (0)::numeric) AS creditloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric))), (0)::bigint) AS creditloannum,
COALESCE(( SELECT sum(el_requirement_info.amount) AS sum
FROM el_requirement_info,
el_requirement_apply,
el_financial_institution
WHERE (((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_financial_institution.id)::text = (el_requirement_apply.institution_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::numeric) AS financingneedsamount,
COALESCE(( SELECT count(1) AS count
FROM el_requirement_info,
el_financial_institution,
el_requirement_apply
WHERE (((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND ((el_financial_institution.id)::text = (el_requirement_apply.institution_id)::text))), (0)::bigint) AS financingneedsnum,
COALESCE(( SELECT trunc(avg(to_number((el_loan_grant.loan_rate)::text, '0.00'::text)), 2) AS trunc
FROM el_loan_grant,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text))), (0)::numeric) AS averagelendingrate,
COALESCE(( SELECT count(1) AS count
FROM el_user_info rr,
el_financial_institution tt
WHERE (((rr.id)::text = (tt.user_id)::text) AND ((rr.user_type)::text = 'FI'::text) AND ((tt.fi_code)::text = (efi.fi_code)::text) AND ((tt.parent_id)::text <> '-1'::text))), (0)::bigint) AS settledinfinancialinstitutionnum,
COALESCE(( SELECT count(1) AS count
FROM el_financial_product,
el_financial_institution
WHERE ((el_financial_product.audit_state = '1'::numeric) AND ((el_financial_product.delflag)::text = '0'::text) AND (((el_financial_product.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text)))), (0)::bigint) AS financialproductsnum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::numeric) AS monthloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::bigint) AS monthloannum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::numeric) AS monthcreditloanamount,
COALESCE(( SELECT count(1) AS count
FROM el_loan_grant,
el_requirement_info,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_loan_grant.requirement_id)::text = (el_requirement_info.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (el_requirement_info.guarantee_mode = '5'::numeric) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::bigint) AS monthcreditloannum,
COALESCE(( SELECT sum(el_loan_grant.grant_amount) AS sum
FROM el_loan_grant,
el_financial_institution
WHERE (((el_loan_grant.create_by)::text = (el_financial_institution.user_id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (to_char(el_loan_grant.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::numeric) AS monthinclusivemicroenterpriseloanamount,
COALESCE(( SELECT sum(el_requirement_info.amount) AS sum
FROM el_requirement_info,
el_requirement_apply,
el_financial_institution
WHERE (((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (to_char(el_requirement_info.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::numeric) AS monthfinancingneedsamount,
COALESCE(( SELECT count(1) AS count
FROM el_requirement_info,
el_requirement_apply,
el_financial_institution
WHERE (((el_requirement_info.id)::text = (el_requirement_apply.requirement_id)::text) AND ((el_requirement_apply.institution_id)::text = (el_financial_institution.id)::text) AND ((el_financial_institution.fi_code)::text = (efi.fi_code)::text) AND (to_char(el_requirement_info.update_date, 'yyyy-mm'::text) = to_char(now(), 'yyyy-mm'::text)))), (0)::bigint) AS monthfinancingneedsnum,
'2023-06-20 08:00:00'::text AS statisticsbegintime,
now() AS statisticsendtime
FROM el_financial_institution efi
GROUP BY efi.fi_code
最新发布
本文探讨了视频编码中层间预测的概念，特别是MODE_SKIP模式，它用于区分inter-layer intra预测和inter-layer motion预测。通过这一模式，可以实现更高效的纹理和运动信息编码。
扫一扫
9233
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
