meetchandan

You are a data analyst tool for analyzing Noon Minutes advertising data.

Communication Style

• NEVER introduce yourself or explain what you are
• NEVER mention being a "tool", "agent", or "data analyst"
• Just provide the requested information directly

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "ISAG2F719U3SQYGYPA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::sa::9311",
      "entity_to": "entity::customer_address::sa::c4d4bbcce048d2efe5bf9bed8715633f::2",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IBHG2D6BHLAH2PZOVA"
  },
  "lines": [
    {
      "entity_from": "entity::legal_entity_v2::bh::LE35L4ESNBH",
      "entity_to": "entity::customer_address::bh::91cf0b5159fe39aae8a5eb7981766eea::1",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IBHG244BHLE24GU0LA"
  },
  "lines": [
    {
      "entity_from": "entity::legal_entity_v2::bh::LE35L4ESNBH",
      "entity_to": "entity::customer_address::bh::1292252d5aeb82aa526df4aa5a564efd::1",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IBHG244BHLE24GU0LA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::bh::451558",
      "entity_to": "entity::customer_address::bh::1292252d5aeb82aa526df4aa5a564efd::1",

meetchandan

update customer_address
set is_deleted = 1
where address_code in ("596f1496cc3866847bd9607efdde1516","e9362f5b9585e9869b78575d6fda720d","f2f31bcc7e529e43f41d30e9f5ddd97b","c97b82645a8642b00d20681e4b6a210c","d15f71e30537cc5f34f9440b8c606413","bf154e63d47ed6689a63f154f079b6dd","3aa44019ac2fbf439e8c3bb37ceb8932","21617112c6daebc9854e51322270e0e8","90ca2b8e62b54fca27a4244d07d9cfca","fdcd24b356b4361948a6f7e3cec06bc8","fcfca590f647faf2bcd589be651fdd62","829b82f962d40c7fb8901b08c9506667","0dde17de941a7d44886cdb898cfad03d","d591ae719ae87016470b6107251a17d9","48963713aa812b0556b7e25bcc12ca91","7b4380a0b7c039fbb7508f5f96ea1967","c70f127851b422251ba86964f54c255a","5e2e89f2306cf83be7be40b8b25a5ff7","09e6d50d45bae0971ce0cdda79a874c0","dc5f52223f6921a2b5e98acc312d1cd5","d5bcbb37b3d4f01a23f2412290ecb7d9","11b799628ad5fc636d70fd611c3e418c","16276a239a48250b4e1ce007d4a731b3","219a1abd34b235794b5e627a43c580ea","0a0dc8290fc56ebc45fe15b919207512","21f817a14cf01d81e679e216ba7e565b","5e7e857d46d7abb320f8e49f2229c9a6","b7e9dd36fe1e

meetchandan

{
    "nbHits": 1,
    "nbPages": 1,
    "search": {
        "q": null,
        "sort": null,
        "f": {
            "page_code": [
                "home_app_mobile_ae_v2"
            ]

meetchandan

SELECT
zp.zsku_parent,
a.attribute_id,
a.attribute_code,
a.attribute_name_en,
a.attribute_name_ar,
a.attribute_type,
a.attribute_namespace AS namespace_code,
a.is_multivalued,
a.is_localizable,

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAEF6H759ZNA5YRRXA"
  },
  "lines": [
    {
      "entity_from": "entity::legal_entity_v2::ae::LE1QX7CQGAE",
      "entity_to": "entity::customer_address::ae::50c3d72fa9091aa3733558ac64dcf868::2",

meetchandan

{
  "exref": {
    "exref_type_code": "mp_instant_order",
    "mp_code": "nooninstant",
    "external_ref": "IAEF6H759ZNA5YRRXA"
  },
  "lines": [
    {
      "entity_from": "entity::partner::ae::302207",
      "entity_to": "entity::customer_address::ae::50c3d72fa9091aa3733558ac64dcf868::2",