a guest Mar 26th, 2019 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- # 30193
- # COUNT(DISTINCT pa.id)
- , ba.*
- FROM prices_all pa
- LEFT JOIN brand_groups bg
- ON bg.parent_id = pa.brand_id
- LEFT JOIN tecdoc_2016q1_europe.ARTICLES_UPD_2017 art
- ON art.ART_SUP_ID = bg.BRA_ID AND art.OWN_S_CLEAR = pa.art_num
- LEFT JOIN brand_all ba ON pa.brand_id = ba.id
- 1 = 1
- AND art.ART_ID IS NOT NULL
- AND pa.avalaible_gen = 1
- AND art.OWN_ART_TYP = '2018'
RAW Paste Data