SHARE
TWEET

ELHA 24

quan8410 Apr 24th, 2019 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT distinct i.grass_date ,
  2.        i.shopid,
  3.        i.itemid,
  4.        u.username,
  5.        i.main_category,
  6.        i.sub_category,
  7.        p.item_name,
  8.        o.buyer_address_state as buyer_location,
  9.        u.address_state as seller_location,
  10.        i.orderid,
  11.        i.gmv,
  12.        i.shopee_estimate_shipping_rebate,
  13.        i.buyer_shipping_fee,
  14.        i.seller_shipping_rebate,
  15.        i.fe_status
  16. from order_mart__order_item_profile i
  17.        INNER JOIN user_profile u
  18.        on i.shopid=u.shopid
  19.        INNER JOIN item_profile p
  20.        on i.itemid=p.itemid
  21.       INNER JOIN order_mart__order_profile o
  22.        on i.orderid=o.orderid
  23. where i.shopid in (12531155,8563637,19464536,69099555,267287,70614549,83115490,72316784,17713786,25710922,16511872,70131487,16461019,40296079,18479475,36832507,15292842,8431428,65169416,26047887,89827191,19874119,69517837,117869244,46182105,18476821,43323341,16178183,11721690,74291781,19414087,17737526,1808469,25826246,71752375,41972589,12788951,95257527,46565529,63520892,35434380,65304483,131560988,867467,67907345,1220986,44731205,9413963,19330007,76680798,121811535,14053715,67884462,25554120,20585883,58558884,18113796,40468815,71944398,17631093,8562464,27662376,52809472,20410272,3933506,20176891,45601183,91451260,93694472,770049,63351058,90980750,129994650,70679496,76480261,63519549,19417109,2042818,63880241,8616850,82396023,136695885,18183995)
  24. and i.main_category in ('Consumer Electronics','Mobile & Accessories','Computer & Laptop','Cameras','Home Appliances')
  25. and i.grass_date=date'2019-04-24'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top