SELECT DISTINCT 
                      AU_ARTICLE.art_id, AU_ARTICLE.art_number AS art_num, AU_ARTICLE.art_text, AU_BRAND.bra_brand AS brand, 
                      PR_PRICE_DATA.pd_cost AS cost, PR_PRICE_DATA.pd_sale AS sale, PR_PRICE_DATA.pd_ost AS ost, PR_DISCOUNT.ds_discount AS discount, 
                      AU_BRAND.bra_id, LINK_TDART_TDTYPE_FILTER.at_type_id, LINK_TDART_TDCG_FILTER.ts_td_cg_id, PR_PRICE_DATA.pd_ct_id AS ct_id, 
                      PR_PRICE_DATA.pd_ost_all, PR_PRICE_DATA.pd_ost_4, PR_PRICE_DATA.pd_ost_5, PR_PRICE_DATA.pd_ost_9, PR_PRICE_DATA.pd_ost_10, 
                      PR_PRICE_DATA.pd_ost_12, PR_PRICE_DATA.pd_ost_15, PR_PRICE_DATA.pd_ost_20, PR_PRICE_DATA.pd_ost_22, 
                      PR_PRICE_DATA.pd_ost_26, PR_PRICE_DATA.pd_ost_29, PR_PRICE_DATA.pd_ost_40, PR_PRICE_DATA.pd_ost_44, 
                      PR_PRICE_DATA.pd_ost_52, PR_PRICE_DATA.pd_ost_62, PR_PRICE_DATA.pd_ost_68, PR_PRICE_DATA.pd_ost_82
FROM         LINK_TDART_TDTYPE_FILTER INNER JOIN
                      LINK_TDART_TDCG_FILTER ON LINK_TDART_TDTYPE_FILTER.at_td_art_id = LINK_TDART_TDCG_FILTER.ts_td_art_id INNER JOIN
                      LINK_AUART_TDART_FILTER ON LINK_TDART_TDCG_FILTER.ts_td_art_id = LINK_AUART_TDART_FILTER.laa_td_art_id INNER JOIN
                      AU_ARTICLE ON LINK_AUART_TDART_FILTER.laa_art_id = AU_ARTICLE.art_id INNER JOIN
                      AU_BRAND ON AU_ARTICLE.art_bra_id = AU_BRAND.bra_id LEFT OUTER JOIN
                      PR_DISCOUNT ON AU_BRAND.bra_id = PR_DISCOUNT.ds_bra_id LEFT OUTER JOIN
                      PR_PRICE_DATA ON AU_ARTICLE.art_id = PR_PRICE_DATA.pd_art_id