OGD and Program Items by Outlet

Select * from Location where code = '520189174' and clientId = 408
select * from LocationGroupDefinitionLocation where LocationId = 13761025 and IsDeleted = 0
Select * from ProgramItemLocationGroupDefinition where LocationGroupDefinitionId in (6181,6882,11385) and IsDeleted = 0
select * from Programitem where programitemid in (15925,17096,17546,18435,19818,20875,21500,21449,22639,22849,26107,26161,27723,27819,28686,28830,30260,30221,31256,31380,32335,32484,33856,33880,34801,37923,41527)
and ValidTo >= '2026-06-09'