Untitled
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)