diff options
Diffstat (limited to 'calculate_price_after_disc.ktr')
| -rw-r--r-- | calculate_price_after_disc.ktr | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index 3e205a6..b3ae58c 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -1618,31 +1618,49 @@ coalesce((select (select group3 from price_group_dw pgd where id = 2) as markup_std3, (select group4 from price_group_dw pgd where id = 2) as markup_std4, (select group5 from price_group_dw pgd where id = 2) as markup_std5, +(select group6 from price_group_dw pgd where id = 2) as markup_std6, +(select group7 from price_group_dw pgd where id = 2) as markup_std7, +(select group8 from price_group_dw pgd where id = 2) as markup_std8, (select group1 from price_group_dw pgd where id = 1) as markup_group1, (select group2 from price_group_dw pgd where id = 1) as markup_group2, (select group3 from price_group_dw pgd where id = 1) as markup_group3, (select group4 from price_group_dw pgd where id = 1) as markup_group4, (select group5 from price_group_dw pgd where id = 1) as markup_group5, +(select group6 from price_group_dw pgd where id = 1) as markup_group6, +(select group7 from price_group_dw pgd where id = 1) as markup_group7, +(select group8 from price_group_dw pgd where id = 1) as markup_group8, (select group1 from price_group_dw pgd where id = 3) as markup_tier2_1, (select group2 from price_group_dw pgd where id = 3) as markup_tier2_2, (select group3 from price_group_dw pgd where id = 3) as markup_tier2_3, (select group4 from price_group_dw pgd where id = 3) as markup_tier2_4, (select group5 from price_group_dw pgd where id = 3) as markup_tier2_5, +(select group6 from price_group_dw pgd where id = 3) as markup_tier2_6, +(select group7 from price_group_dw pgd where id = 3) as markup_tier2_7, +(select group8 from price_group_dw pgd where id = 3) as markup_tier2_8, (select group1 from price_group_dw pgd where id = 4) as markup_tier3_1, (select group2 from price_group_dw pgd where id = 4) as markup_tier3_2, (select group3 from price_group_dw pgd where id = 4) as markup_tier3_3, (select group4 from price_group_dw pgd where id = 4) as markup_tier3_4, (select group5 from price_group_dw pgd where id = 4) as markup_tier3_5, +(select group6 from price_group_dw pgd where id = 4) as markup_tier3_6, +(select group7 from price_group_dw pgd where id = 4) as markup_tier3_7, +(select group8 from price_group_dw pgd where id = 4) as markup_tier3_8, (select group1 from price_group_dw pgd where id = 5) as markup_tier4_1, (select group2 from price_group_dw pgd where id = 5) as markup_tier4_2, (select group3 from price_group_dw pgd where id = 5) as markup_tier4_3, (select group4 from price_group_dw pgd where id = 5) as markup_tier4_4, (select group5 from price_group_dw pgd where id = 5) as markup_tier4_5, +(select group6 from price_group_dw pgd where id = 5) as markup_tier4_6, +(select group7 from price_group_dw pgd where id = 5) as markup_tier4_7, +(select group8 from price_group_dw pgd where id = 5) as markup_tier4_8, (select group1 from price_group_dw pgd where id = 6) as markup_tier5_1, (select group2 from price_group_dw pgd where id = 6) as markup_tier5_2, (select group3 from price_group_dw pgd where id = 6) as markup_tier5_3, (select group4 from price_group_dw pgd where id = 6) as markup_tier5_4, -(select group5 from price_group_dw pgd where id = 6) as markup_tier5_5 +(select group5 from price_group_dw pgd where id = 6) as markup_tier5_5, +(select group6 from price_group_dw pgd where id = 6) as markup_tier5_6, +(select group7 from price_group_dw pgd where id = 6) as markup_tier5_7, +(select group8 from price_group_dw pgd where id = 6) as markup_tier5_8 from product p left join brand b on b.id = p.brand_id</sql> <limit>0</limit> |