asd

select distinct p.product_num as productNumber,
       dcsl.store_list_code as dealStoreListCode,
       fssl.store_list_code as slotStoreListCode,
       fg.save_tactic as saveTactic,
       ppp.zone_number as zone,
       z.zone_type_code as zoneTypeCode,
       ppp.calc_save_percent as savePercentAmount,
       ppp.calc_save_dollar as saveDollarAmount,
       d.deal_number as dealNumber,
       d.deal_year as dealYear,
       d.deal_start_date as dealStartDate,
       ppp.price_amount as basePromoPrice,
       ppp.snapshot_reg_price_amount as baseRegularPrice,
       p.special_buy_ind as isSpecialBuy,
       s.media_program_code as mediaProgramCode
from promo_product_price ppp
   join zones z on ppp.zone_number = z.zone_number
   join flighted_product fp on ppp.flighted_product_id = fp.id
   join flighted_group fg on fp.flighted_group_id = fg.id
   join flighted_group_media_channel fgmc on fg.id = fgmc.flighted_group_id
   join slot s on fgmc.media_channel_reference_id = s.slot_id
   join fp_deal_page dp on s.page_id = dp.id
   join deal d on dp.deal_id = d.deal_id
   join product p on fp.product_id = p.id
   left join deal_channel_store_list dcsl on d.deal_id = dcsl.deal_id
   left join fp_slot_store_list fssl on s.slot_id = fssl.slot_id
where fp.status_code='FLT' and fp.validated_ind=1
   and ppp.price_type_code='Retail'
and d.deal_year = ?
and d.deal_number = ?
order by p.product_num