select * from HoleSKU hs
inner join bays b on hs.Bays = b.BayNumber
inner join skulocations sk on sk.bayid = b.Id
where hs.sku = 123941 and BayNumber = ####
select * from HoleSKU hs
inner join bays b on hs.Bays = b.BayNumber
inner join skulocations sk on sk.bayid = b.Id
where hs.sku = 788278 and hs.statuscode = ‘c’ and b.zoneid = ’25’ and b.BayNumber = 2 order by b.id
SELECT ZoneId, SKU, Bays, COUNT(ZoneId)
FROM HoleSKU HS
WHERE TypeHole = ‘PD’
AND Createdate >= ‘2023-02-20’
AND Createdate <= ‘2023-02-20’
and ZoneId = ’22’
AND HS.StatusCode = ‘A’
GROUP BY ZoneId, SKU, Bays
