Specials Query - MySQL
Specials Query
SELECT od.transdate, od.storenum, od.SpecialID, s.Description, od.productcode, od.amount, od.ptsRedeemed FROM offers_deal od
join specials s on s.id = od.specialid
where od.transdate between '2026-09-20' and '2026-09-26 23:59:59'
and od.specialid >0
and od.used =1;
join specials s on s.id = od.specialid
where od.transdate between '2026-09-20' and '2026-09-26 23:59:59'
and od.specialid >0
and od.used =1;