4 ms·
So I think it is much easier to read if you can line up like clauses: SELECT spf.blah_blah, count(*) AS cnt FROM jv_CTLG_ENTITY_ATTR_PROD_MAP pr
by justin_vanw 10y ago
So I think it is much easier to read if you can line up like clauses:
SELECT spf.blah_blah,
count(*) AS cnt
FROM jv_CTLG_ENTITY_ATTR_PROD_MAP prod_map
JOIN jv_SSA_PRODUCT_FACT spf
ON prod_map.prod_ref_id = spf.PROD_REF_ID
WHERE prod_map.INVSBL_IND = '0' AND
spf.LSTG_END_DT >= date_sub(from_unixtime(unix_timestamp()), 2) AND
spf.LSTG_START_DT <= date_sub(from_unixtime(unix_timestamp()), 2) AND
spf.lstg_site_id = 0 AND
prod_map.ENTITY_ATTR_TYPE_DESC IN ('BMPN','GTIN') AND
spf.CTLG_ID = 1075 AND
spf.LSTG_TYPE_CD NOT IN (10,12,15)
GROUP BY spf.blah_blah;