meetchandan

CREATE OR REPLACE TABLE noonbitechit.search.crosslisting_sku_mapping
AS


WITH minutes_products AS (
  SELECT sku AS zsku, lower(os.country_code) as country_code, psku_code, nsku_child AS nsku, partner_barcode, pb.id_partner, brand_code, SUM(stock_net) as total_stock
  FROM `noondwh.instant_spanner.product` prod
  JOIN `noondwh.psku.psku` p ON prod.sku = p.zsku_child
  JOIN `noondwh.psku.pbarcode` pb USING(psku_code)

meetchandan

{
    "cc_emails": [],
    "fwd_emails": [],
    "reply_cc_emails": [],
    "ticket_cc_emails": [],
    "fr_escalated": false,
    "spam": false,
    "email_config_id": null,
    "group_id": 84000195229,
    "priority": 1,

meetchandan

{
    "exref": {
        "exref_type_code": "mp_instant_order",
        "mp_code": "nooninstant",
        "external_ref": "IAEDAQ145A7GCVM7QA"
    },
    "lines": [
        {
            "entity_from": "entity::partner::ae::9411",
            "entity_to": "entity::customer_address::ae::11a3fbe6ac03f7a0f27acb4725dad58b::1",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IEGDA7332P9E39PJOA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::eg::9511",
      "entity_to": "entity::customer_address::eg::e096335c6b3d8b628533fb7376d55bbf::2",

meetchandan

{
    "exref": {
        "exref_type_code": "mp_instant_order",
        "mp_code": "nooninstant",
        "external_ref": "IEGDA65341K8Z7SXRA"
    },
    "lines": [
        {
            "entity_from": "entity::partner::eg::9511",
            "entity_to": "entity::customer_address::eg::eba9e30e2d3feb5e43bf435f4299b52e::2",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAED9A1514PEB0IOSA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::ae::16527",
      "entity_to": "entity::customer_address::ae::6064d15bfeeb21b168495aca706a32c9::4",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAED8F123CA975JZKA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::ae::9411",
      "entity_to": "entity::customer_address::ae::6312c7c3af7767f479cb3dbb6930ee54::2",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAED8C123FHFCVNSDA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::ae::iaed8c123fhfcvnsda-1",
      "entity_to": "entity::customer_address::ae::6312c7c3af7767f479cb3dbb6930ee54::2",

meetchandan

I1-M1-2
I2-M2-1

/set-qty 
{
"item_code": "I2",
"modifiers": "M1",
"qty": 2
}
I1-M1-4

meetchandan

{"mainVideos":[{"id":"1683033798231","title":"Match Stream: GT v DC, Tata IPL 2023, Match 44","timestamp":"1683033798231","imageUrl":"https://a.nooncdn.com/cms/pages/20230405/c3f185a35a6964f0b0e9be794d0fdc15/IPL_match-44.png","videoUrl":"https://livestream.noon.com/hls/live/2098770/66320/master.m3u8","adTag":null,"durationStr":null,"videoType":"MatchStream","matchId":"66320","isLive":true,"isFree":false,"assetKey":null},{"id":"1683035356179","title":"GT vs DC, 44th Match, TOSS","timestamp":"1683035356179","imageUrl":"https://livestream.noon.com/hls/vods/5945/66320/GT_DC_02-05-2023_T20_TOSS/thumbnail.jpg","videoUrl":"https://livestream.noon.com/hls/vods/5945/66320/GT_DC_02-05-2023_T20_TOSS/master.m3u8","adTag":"https://pubads.g.doubleclick.net/gampad/live/ads?iu=/22809011232/noon_vod_uae&description_url=https%3A%2F%2Fnoon.com&tfcd=0&npa=0&sz=640x480&pp=noon_dai_IPL_profile&gdfp_req=1&output=vast&unviewed_position_start=1&env=vp&impl=s&correlator=&vad_type=linear&ad_rule=0&vpos=preroll&max_ad_duration=20000&vpa