Untitled

SELECT DISTINCT p.product_num AS productNumber,
                fssl.store_list_code AS slotStoreListCode,
                fg.pre_flight_deal_id AS dealId,
                fg.save_tactic AS saveTactic,
				fp.id,
				ppp.price_effective_date,
                ppp.zone_number AS ZONE,
                ppp.calc_save_percent AS savePercentAmount,
                ppp.calc_save_dollar AS saveDollarAmount,
                ppp.price_amount AS basePromoPrice,
                ppp.snapshot_reg_price_amount AS baseRegularPrice,
                s.media_program_code AS mediaProgramCode,
                ic.comment AS COMMENT,
                ic.comment_code AS commentCode
FROM flighted_product fp
JOIN product p ON fp.product_id = p.id
JOIN flighted_group fg ON fp.flighted_group_id = fg.id
JOIN deal d ON fg.pre_flight_deal_id = d.deal_id
LEFT JOIN flighted_group_media_channel fgmc ON fg.id = fgmc.flighted_group_id
LEFT JOIN slot s ON fgmc.media_channel_reference_id = s.slot_id
LEFT JOIN fp_slot_store_list fssl ON s.slot_id = fssl.slot_id
LEFT JOIN fp_deal_page dp ON s.page_id = dp.id
LEFT JOIN flighted_product_comment fpc ON fpc.flighted_product_id = fp.id
LEFT JOIN ibs_comment ic ON ic.id = fpc.comment_id
LEFT JOIN promo_product_price ppp ON ppp.flighted_product_id = fp.id
WHERE p.product_num in ('1163202')
  AND (ppp.zone_number IS NULL
       OR ppp.zone_number in ('0', '0808'))
  AND p.status_code != 'FD'
  AND fp.status_code = 'FLT'
  AND fp.validated_ind = 1
  AND fp.validated_ind = 1
  AND (d.deal_start_date <= '2022-06-17'
       AND (d.deal_end_date IS NULL
            OR d.deal_end_date >= '2022-06-17'))