{"id":76,"date":"2007-04-18T11:48:06","date_gmt":"2007-04-18T09:48:06","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=76"},"modified":"2007-04-18T11:48:06","modified_gmt":"2007-04-18T09:48:06","slug":"update-kategorii-przy-indeksie","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=76","title":{"rendered":"Update kategorii przy indeksie"},"content":{"rendered":"

— zapytania kasujace dane z tabeli interfejsowej i tabeli z b\u0142\u0119dami
\ndelete from MTL_ITEM_CATEGORIES_INTERFACE
\ndelete from MTL_INTERFACE_ERRORS<\/p>\n

— zapytania pokazuj\u0105ce dane w tabeli interfejsowej oraz tabeli z b\u0142\u0119dami
\nselect * from MTL_ITEM_CATEGORIES_INTERFACE
\nselect * from MTL_INTERFACE_ERRORS<\/p>\n

— zapytanie wrzucaj\u0105ce JEDEN rekord do tabeli MTL_ITEM_CATEGORIES_INTERFACE
\ninsert into MTL_ITEM_CATEGORIES_INTERFACE
\n\t\u00a0 (ITEM_NUMBER,
\n\t\u00a0\t\u00a0 ORGANIZATION_CODE,
\n\t\u00a0\t\u00a0 CATEGORY_SET_NAME,
\n\t\u00a0\t\u00a0 CATEGORY_NAME,
\n\t\u00a0\t\u00a0 PROCESS_FLAG,
\n\t\u00a0\t\u00a0 SET_PROCESS_ID,
\n\t\u00a0\t\u00a0 TRANSACTION_TYPE)
\nvalues (’38362000-001-00000000′, 'CIM’, 'Intrastat’, '28362000′, 1, 1000, 'CREATE’);<\/p>\n

— zapytanie pokazuj\u0105ce id_organizacji, id zestawu kategorii oraz warto\u015b\u0107 kategorii
\n\t\u00a0 select organization_id, category_set_id, category_concat_segs
\n\t\u00a0\t\u00a0\t\u00a0 from mtl_item_categories_v
\n\t\u00a0\t\u00a0 where inventory_item_id in
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 (select distinct inventory_item_id
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 from mtl_system_items_b
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 where segment1 = '38362000-001-00000000′)
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and category_set_name = 'Intrastat’
\n— I N T E R F E J S —
\n— W celu zaktualizowania kategorii przy indeksie przy wykorzystaniu interfejsu nale\u017cy:
\n— w pierwszej kolejno\u015bci usun\u0105\u0107 kategi\u0119 z indeksu, a nast\u0119pnie za\u0142adowa\u0107 now\u0105 kategori\u0119.
\n— W tym celu poni\u017cej mamy dwa rodzaje insert\u00f3w. Jeden z opcj\u0105 DELETE drugi z opcj\u0105 CREATE
\n— Po za\u0142adowaniu danych do tabeli interfejsowej nale\u017cy uruchomi\u0107\t\u00a0 „Otwarty interfejs przydzia\u0142u kategorii pozycji”
\n— w parametrze w polu UID zestawu rekord\u00f3w nale\u017cy poda\u0107 warto\u015b\u0107 1000 – spowoduje to usuni\u0119cie
\n— kategorii, nast\u0119pnie nalezy go ponownie uruchomi\u0107 wpisuj\u0105c warto\u015b\u0107 1001 – spowoduje to
\n— przypisanie nowych warto\u015bci kategorii<\/p>\n

\t\u00a0\t\u00a0\t\u00a0\t\u00a0
\n— zapytanie pokazuj\u0105ce indeksy oraz obecnie przypisane warto\u015bci kategorii Intrastat i wrzucaj\u0105ce do tabeli interfejsowej
\n— te kategorie b\u0119d\u0105 kasowane (SET PROCESS ID – 1000)
\ninsert into MTL_ITEM_CATEGORIES_INTERFACE
\n\t\u00a0 (ITEM_NUMBER,
\n\t\u00a0\t\u00a0 ORGANIZATION_CODE,
\n\t\u00a0\t\u00a0 CATEGORY_SET_NAME,
\n\t\u00a0\t\u00a0 CATEGORY_NAME,
\n\t\u00a0\t\u00a0 PROCESS_FLAG,
\n\t\u00a0\t\u00a0 SET_PROCESS_ID,
\n\t\u00a0\t\u00a0 TRANSACTION_TYPE)
\n\t\u00a0 select msi.segment1\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „ITEM_NUMBER”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’CIM’\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „ORGANIZATION_CODE”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,mic.CATEGORY_SET_NAME\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „CATEGORY_SET_NAME”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,mic.CATEGORY_CONCAT_SEGS\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „CATEGORY_NAME”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’1′\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „PROCESS_FLAG”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’1000′\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „SET_PROCESS_ID”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’DELETE’\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „TRANSACTION_TYPE”
\n\t\u00a0\t\u00a0\t\u00a0 from\t\u00a0 apps.mtl_system_items_b msi
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,apps.mtl_item_categories_v mic
\n\t\u00a0\t\u00a0 where
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 msi.inventory_item_id=mic.INVENTORY_ITEM_ID
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and mic.CATEGORY_SET_NAME = 'Intrastat’ — nazwa kategorii
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and mic.ORGANIZATION_ID = 115\t\u00a0 — tylko CIM
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and msi.ORGANIZATION_ID = 115\t\u00a0 — tylko CIM
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and (msi.segment1 like '28309080%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '28332300%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '28352300%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29089000%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29173100%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29173400%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29189090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29190090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29201000%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29322980%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081010%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081020%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081030%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081040%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082010%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082015%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082030%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082050%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082060%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082080%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083011%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083013%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083015%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083017%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083021%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083023%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083027%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083030%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38084090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38089010%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38249099%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38362000%’)
\norder by msi.segment1\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0
\n— zapytanie pokazuj\u0105ce indeksy oraz obecnie przypisane warto\u015bci kategorii Intrastat i wrzucaj\u0105ce do tabeli interfejsowej
\n— te kategorie b\u0119d\u0105 ustawiane (SET PROCESS ID – 1001)
\ninsert into MTL_ITEM_CATEGORIES_INTERFACE
\n\t\u00a0 (ITEM_NUMBER,
\n\t\u00a0\t\u00a0 ORGANIZATION_CODE,
\n\t\u00a0\t\u00a0 CATEGORY_SET_NAME,
\n\t\u00a0\t\u00a0 CATEGORY_NAME,
\n\t\u00a0\t\u00a0 PROCESS_FLAG,
\n\t\u00a0\t\u00a0 SET_PROCESS_ID,
\n\t\u00a0\t\u00a0 TRANSACTION_TYPE)
\n\t\u00a0 select msi.segment1\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „ITEM_NUMBER”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’CIM’\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „ORGANIZATION_CODE”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,mic.CATEGORY_SET_NAME\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „CATEGORY_SET_NAME”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,decode(mic.CATEGORY_CONCAT_SEGS,’28309080′,’28309085′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’28332300′,’28332920′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’28352300′,’28352930′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’29089000′,’29089990′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’29173100′,’29173410′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’29173400′,’29173490′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’29189090′,’29189990′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’29190090′,’24199090′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’29201000′,’29201900′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’29322980′,’29322985′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38081010′,’38089110′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38081020′,’38089120′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38081030′,’38089130′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38081040′,’38089140′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38081090′,’38089190′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38082010′,’38089210′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38082015′,’38089220′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38082030′,’38089230′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38082050′,’38089250′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38082060′,’38089260′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38082080′,’38089290′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083011′,’38089311′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083013′,’38089313′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083015′,’38089315′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083017′,’38089317′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083021′,’38089321′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083023′,’38089323′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083027′,’38089327′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083030′,’38089330′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38083090′,’38089390′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38084090′,’38089490′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38089010′,’38089910′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38249099′,’38249098′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’38362000′,’28362000′
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’INNE’)\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „CATEGORY_NAME”\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’1′\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „PROCESS_FLAG”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’1001′\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „SET_PROCESS_ID”
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,’CREATE’\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 „TRANSACTION_TYPE”
\n\t\u00a0\t\u00a0\t\u00a0 from\t\u00a0 apps.mtl_system_items_b msi
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 ,apps.mtl_item_categories_v mic
\n\t\u00a0\t\u00a0 where
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 msi.inventory_item_id=mic.INVENTORY_ITEM_ID
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and mic.CATEGORY_SET_NAME = 'Intrastat’ — nazwa kategorii
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and mic.ORGANIZATION_ID = 115\t\u00a0 — tylko CIM
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and msi.ORGANIZATION_ID = 115\t\u00a0 — tylko CIM
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0 and (msi.segment1 like '28309080%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '28332300%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '28352300%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29089000%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29173100%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29173400%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29189090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29190090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29201000%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '29322980%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081010%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081020%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081030%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081040%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38081090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082010%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082015%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082030%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082050%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082060%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38082080%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083011%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083013%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083015%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083017%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083021%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083023%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083027%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083030%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38083090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38084090%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38089010%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38249099%’
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0 or msi.segment1 like '38362000%’)
\norder by msi.segment1\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0
\n\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

— zapytania kasujace dane z tabeli interfejsowej i tabeli z b\u0142\u0119dami<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/76"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76"}],"version-history":[{"count":0,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/76\/revisions"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}