Advertisement
Guest User

Untitled

a guest
May 31st, 2016
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT ID, CreatedAt, Identifier, Name, DeliveryName, RoundedPriceSum FROM StarOrder
  2. WHERE
  3. SiteID = 1 AND --StarSite.ID 1= SE, 2 = NO
  4. ShippingTypeID = 4 -- StarShippingType.ID 4 = STORE_PICKUP SE, 10 = STORE_PICKUP NO
  5. and CreatedAt between '2015/01/11' and '2016/05/30'
  6. Order BY DeliveryName DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement