Untitled

mail@pastecode.io avatarunknown
plain_text
a month ago
1.4 kB
2
Indexable
Never
SELECT p.id, p.PhysicalStoreID, p.PostingStateID, p.ClientOrderID, pi2.ItemID, pi2.Qty, pts.CutOffTime  from Posting p
join PostingTimeSlot pts on p.ID = pts.PostingID 
join PostingItem pi2 on p.id = pi2.PostingID 
where p.id in (	
21111375448,
21111385448,
21111395448,
21111405448,
21111415448,
21111425448,
21111435448,
21111445448,
21111455448,
21111465448,
21111475448,
21111485448,
21111495448,
21111505448,
21111515448,
21111525448,
21111535448,
21111545448,
21111555448,
21111565448,
21111575448,
21111585448,
21111595448,
21111605448,
21111615448,
21111625448,
21111635448,
21111645448,
21111655448,
21111665448,
21111675448,
21111685448,
21111695448,
21111705448,
21111715448,
21111725448,
21111735448)

SELECT p.id, p.DeliveryVariantID, p.PhysicalStoreID, p.PostingStateID, p.ClientOrderID, pi2.ItemID, pi2.Qty, pts.CutOffTime  from Posting p
join PostingTimeSlot pts on p.ID = pts.PostingID 
join PostingItem pi2 on p.id = pi2.PostingID 
where p.id in (	
21060153246,
2341430736,
21383933478,
21341594543,
21305773979,
21175166223,
21105356180,
21096110242,
21019181579,
20950212747,
20960862494,
20942781876,
21178685920,
2341435395,
2341435394,
2341435393,
21081262121,
2341453711,
2341453710,
2341453707,
2341437303,
2341441457,
2341441718,
20839961094,
20902971167,
21021512327,
21026003974,
21071421574,
21107475178,
21153138117,
21232240099,
21245064254,
21252014849,
21319954511,
21323653741,
21328733741,
21338163278)