ELHA 24

SELECT distinct i.grass_date ,
       i.shopid,
       i.itemid,
       u.username,
       i.main_category,
       i.sub_category,
       p.item_name,
       o.buyer_address_state as buyer_location,
       u.address_state as seller_location,
       i.orderid,
       i.gmv,
       i.shopee_estimate_shipping_rebate,
       i.buyer_shipping_fee,
       i.seller_shipping_rebate,
       i.fe_status
from order_mart__order_item_profile i
       INNER JOIN user_profile u
       on i.shopid=u.shopid
       INNER JOIN item_profile p
       on i.itemid=p.itemid
      INNER JOIN order_mart__order_profile o
       on i.orderid=o.orderid
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)
and i.main_category in ('Consumer Electronics','Mobile & Accessories','Computer & Laptop','Cameras','Home Appliances')
and i.grass_date=date'2019-04-24'