Last active
November 8, 2023 09:45
-
-
Save davidsheardown/7538c9ade6fa2fc62ecf1a07fda49c61 to your computer and use it in GitHub Desktop.
XQuery/XPath in SQL Example Individual Elements and Rows
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Given the XML down below, we can use a couple of queries to get individual elements (or attr) but also a list of other nodes/values: | |
| ;with cte | |
| as | |
| ( | |
| select | |
| Id, | |
| Filename, | |
| cast (replace(XMLpayload, 'utf-8', 'utf-16') AS XML) as XmlContent, | |
| CreatedAt | |
| from | |
| Pricat | |
| where | |
| Processed = 0 | |
| ) | |
| -- Now select the relevant fields we want as well as the XML node/elements | |
| select | |
| Id, | |
| Filename, | |
| Header.N.value('(*:DocumentIdentification)[1]', 'varchar(50)') as DocumentIdentificationNo, | |
| GroupsVariant.N.value('(*:ItemNumber)[1]', 'varchar(100)') as ItemNumberBarcode | |
| from | |
| cte | |
| -- *NOTE: We handle the multiple namespaces by using the "*:" before the node name(s) | |
| -- *NOTE: The node names are CASE SENSITIVE! | |
| outer apply cte.XmlContent.nodes('/*:SalesPriceCatalogue_Xml_Full/*:Header') as Header(N) | |
| outer apply cte.XmlContent.nodes('/*:SalesPriceCatalogue_Xml_Full/*:Groups/*:Group/*:Variants/*:Variant') as GroupsVariant(N) | |
| -- The following is where you will need to perform a separate query to return a "set" of prices. Of course, you can't return | |
| -- multiple rows within already rows if you follow me :) | |
| -- So, for example, if you want to return all ADDITIONAL PRICES (you could also filter these!) then... | |
| ;with cte | |
| as | |
| ( | |
| select | |
| Id, | |
| Filename, | |
| cast (replace(XMLpayload, 'utf-8', 'utf-16') AS XML) as XmlContent, | |
| CreatedAt | |
| from | |
| Pricat | |
| where | |
| Processed = 0 | |
| ) | |
| SELECT | |
| T.c.query('*:GrossPriceCurrency').value('.', 'varchar(50)') AS GrossPriceCurrency, | |
| T.c.query('*:GrossPriceAmount').value('.', 'varchar(50)') AS GrossPriceAmount, | |
| T.c.query('*:Country/*:CountryName').value('.', 'varchar(50)') AS Country | |
| FROM | |
| cte | |
| cross apply cte.XmlContent.nodes('//*:PriceDetail/*:AdditionalPrices/*:AdditionalPrice') T(c) | |
| --WHERE | |
| --T.c.query('*:Country/*:Cou | |
| <ns0:SalesPriceCatalogue_Xml_Full xmlns:ns0="http://Bestseller.BizTalk.Object.SalesPriceCatalogue.CustomXml.Schemas"> | |
| <ns0:Header> | |
| <ns0:SubscriptionType>D</ns0:SubscriptionType> | |
| <ns0:DocumentIdentification>296706233</ns0:DocumentIdentification> | |
| <ns0:CustomerReference>Noos</ns0:CustomerReference> | |
| <ns0:SalesOrderNumber>43189135</ns0:SalesOrderNumber> | |
| <ns0:DispatchNoteNumber>2392828368</ns0:DispatchNoteNumber> | |
| <ns0:OriginatingSystem> | |
| <ns0:ErpSystem>BestInfo2</ns0:ErpSystem> | |
| <ns0:SubSystem>BestPack3</ns0:SubSystem> | |
| <ns0:Organization>Bestseller</ns0:Organization> | |
| </ns0:OriginatingSystem> | |
| <ns0:Date> | |
| <ns0:DocumentDate>2023-10-12</ns0:DocumentDate> | |
| <ns0:DocumentTime>07:00:59</ns0:DocumentTime> | |
| <ns0:SalesOrderDate>2023-10-10</ns0:SalesOrderDate> | |
| <ns0:ValidityStartDate>2023-10-12</ns0:ValidityStartDate> | |
| </ns0:Date> | |
| <ns0:Vat> | |
| <ns0:Rate>23</ns0:Rate> | |
| <ns0:Currency>EUR</ns0:Currency> | |
| </ns0:Vat> | |
| <ns0:Parties> | |
| <ns0:BuyerParty> | |
| <ns0:Name>Born Thurles</ns0:Name> | |
| <ns0:PartyIdentificationDetail> | |
| <ns0:CustomerNumber>301122</ns0:CustomerNumber> | |
| <ns0:VatRegistrationNumber>IE9842299H</ns0:VatRegistrationNumber> | |
| <ns0:GlobalLocationNumber>12264</ns0:GlobalLocationNumber> | |
| </ns0:PartyIdentificationDetail> | |
| <ns0:Address> | |
| <ns0:StreetNameAndNumber>Thurles Shopping Centre</ns0:StreetNameAndNumber> | |
| <ns0:MoreInfo>Elland Clothing Thurles Limited</ns0:MoreInfo> | |
| <ns0:CityName>Tipperary</ns0:CityName> | |
| <ns0:PostcodeIdentification>E41 V4Y9</ns0:PostcodeIdentification> | |
| <ns0:Country> | |
| <ns0:CountryName>IRELAND</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>IE</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>IRL</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>372</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| <ns0:Contact> | |
| <ns0:Telephone>091 895226</ns0:Telephone> | |
| </ns0:Contact> | |
| </ns0:Address> | |
| </ns0:BuyerParty> | |
| <ns0:SupplierParty> | |
| <ns0:Name>BESTSELLER Wholesale (Ireland) Ltd.</ns0:Name> | |
| <ns0:PartyIdentificationDetail> | |
| <ns0:VatRegistrationNumber>IE8265260D</ns0:VatRegistrationNumber> | |
| <ns0:GlobalLocationNumber>5700670000076</ns0:GlobalLocationNumber> | |
| </ns0:PartyIdentificationDetail> | |
| <ns0:Address> | |
| <ns0:StreetNameAndNumber>Unit 14, The Westway Centre, Ballymount Avenue</ns0:StreetNameAndNumber> | |
| <ns0:CityName>Dublin 12</ns0:CityName> | |
| <ns0:PostcodeIdentification>D12 A33D</ns0:PostcodeIdentification> | |
| <ns0:Country> | |
| <ns0:CountryName>IRELAND</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>IE</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>IRL</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>372</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| <ns0:Contact /> | |
| </ns0:Address> | |
| </ns0:SupplierParty> | |
| </ns0:Parties> | |
| </ns0:Header> | |
| <ns0:Groups> | |
| <ns0:Group> | |
| <ns0:Variants> | |
| <ns0:Variant> | |
| <ns0:ItemNumberMaster>12150148</ns0:ItemNumberMaster> | |
| <ns0:ItemNumber>5713755553046</ns0:ItemNumber> | |
| <ns0:ItemName>JPSTMARCO JJBOWIE NOOS</ns0:ItemName> | |
| <ns0:GlobalTradeItemNumberVariant>5713755553046</ns0:GlobalTradeItemNumberVariant> | |
| <ns0:GlobalTradeItemNumberMaster>5713753625981</ns0:GlobalTradeItemNumberMaster> | |
| <ns0:SubBrandName>JACK&JONES PANTS STUDIO</ns0:SubBrandName> | |
| <ns0:BrandName>Jack & Jones</ns0:BrandName> | |
| <ns0:CustomsCode>62034235</ns0:CustomsCode> | |
| <ns0:CustomsCodeName>Other</ns0:CustomsCodeName> | |
| <ns0:ValueAddedTaxRate>23</ns0:ValueAddedTaxRate> | |
| <ns0:IsItemPriceMarked>true</ns0:IsItemPriceMarked> | |
| <ns0:IsItemBarcoded>true</ns0:IsItemBarcoded> | |
| <ns0:IsBox>false</ns0:IsBox> | |
| <ns0:IsMarketing>false</ns0:IsMarketing> | |
| <ns0:IsSupplement>false</ns0:IsSupplement> | |
| <ns0:IsNeverOutOfStock>true</ns0:IsNeverOutOfStock> | |
| <ns0:Season>Winter</ns0:Season> | |
| <ns0:DeliveryPeriod> | |
| <ns0:StartDate>1900-01-01</ns0:StartDate> | |
| <ns0:EndDate>2999-12-31</ns0:EndDate> | |
| <ns0:PeriodName>IMMEDIATE</ns0:PeriodName> | |
| </ns0:DeliveryPeriod> | |
| <ns0:ItemDescription> | |
| <ns0:Description> - Detail Type : Chino trousers | |
| - Fabric : Satin fabrics are more shiny than other fabrics. Giving a more exlusive look | |
| - Waist/Rise : Low rise | |
| - Closing/Fly : Zip fly fastening | |
| - Pocket other : Chino pockets | |
| - Occasion/Styling : The chino pant is an essential style for this category. It is the in between of a dress pant and a casual 5 pocket styling. It's a plain styling, with front and back pockets only | |
| - Fit : Slim fit with a low rise, slim knee and tight leg opening | |
| - Fit : Slim Fit</ns0:Description> | |
| <ns0:DescriptionShort>PANTS MALE WOV CO78/COC20/EA2</ns0:DescriptionShort> | |
| <ns0:QualityDescription>Gender: Male | |
| Manufacture: Woven | |
| Manufacture Detail: Twill weave | |
| Style Type: PANTS | |
| Composition: 78% Cotton, 20% Cotton - Recycled, 2% Elastane</ns0:QualityDescription> | |
| </ns0:ItemDescription> | |
| <ns0:ItemCatagorization> | |
| <ns0:ProductGroupName>Trousers</ns0:ProductGroupName> | |
| <ns0:ProductGroupNumber>8</ns0:ProductGroupNumber> | |
| <ns0:ProductSubGroupName>Chinos</ns0:ProductSubGroupName> | |
| <ns0:ProductSubGroupNumber>56</ns0:ProductSubGroupNumber> | |
| <ns0:NcrIdentifier>224</ns0:NcrIdentifier> | |
| <ns0:ProductClassificationCodeBte>110500</ns0:ProductClassificationCodeBte> | |
| <ns0:ProductClassificationCodeBteV2>110510 H-Kombihosen</ns0:ProductClassificationCodeBteV2> | |
| <ns0:TargetGroup>Male</ns0:TargetGroup> | |
| </ns0:ItemCatagorization> | |
| <ns0:ItemClassification> | |
| <ns0:IsInvoiceUnit>true</ns0:IsInvoiceUnit> | |
| <ns0:IsDespatchUnit>false</ns0:IsDespatchUnit> | |
| <ns0:IsOrderingUnit>true</ns0:IsOrderingUnit> | |
| <ns0:IsConsumerUnit>true</ns0:IsConsumerUnit> | |
| </ns0:ItemClassification> | |
| <ns0:CountryOfOrigin> | |
| <ns0:CountryName>PAKISTAN</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>PK</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>PAK</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>586</ns0:CountryCodeNumber> | |
| </ns0:CountryOfOrigin> | |
| <ns0:Measurement> | |
| <ns0:ItemNetWeight>0.438</ns0:ItemNetWeight> | |
| <ns0:ItemGrossWeight>0.488</ns0:ItemGrossWeight> | |
| </ns0:Measurement> | |
| <ns0:PhysicalAttribute> | |
| <ns0:Size>30</ns0:Size> | |
| <ns0:Length>32</ns0:Length> | |
| <ns0:LengthName>"32</ns0:LengthName> | |
| <ns0:ColourName>Navy Blazer</ns0:ColourName> | |
| <ns0:MainColourName>BLUE</ns0:MainColourName> | |
| <ns0:MainColourNumber>3</ns0:MainColourNumber> | |
| <ns0:ColourNumber>175876</ns0:ColourNumber> | |
| <ns0:PantoneNumber>19-3923 TCX</ns0:PantoneNumber> | |
| <ns0:HexCode>#282D3C</ns0:HexCode> | |
| <ns0:FabricComposition> | |
| <ns0:FabricCompositionText>78% Cotton, 20% Cotton - Recycled, 2% Elastane</ns0:FabricCompositionText> | |
| <ns0:Compositions> | |
| <ns0:Composition> | |
| <ns0:MaterialName>Elastane</ns0:MaterialName> | |
| <ns0:MaterialShortName>EA</ns0:MaterialShortName> | |
| <ns0:Percentage>2</ns0:Percentage> | |
| </ns0:Composition> | |
| <ns0:Composition> | |
| <ns0:MaterialName>Cotton - Recycled</ns0:MaterialName> | |
| <ns0:MaterialShortName>COC</ns0:MaterialShortName> | |
| <ns0:Percentage>20</ns0:Percentage> | |
| </ns0:Composition> | |
| <ns0:Composition> | |
| <ns0:MaterialName>Cotton</ns0:MaterialName> | |
| <ns0:MaterialShortName>CO</ns0:MaterialShortName> | |
| <ns0:Percentage>78</ns0:Percentage> | |
| </ns0:Composition> | |
| </ns0:Compositions> | |
| </ns0:FabricComposition> | |
| <ns0:VariantSpecification> | |
| <ns0:VariantName /> | |
| <ns0:StyleVariantNumbering /> | |
| </ns0:VariantSpecification> | |
| </ns0:PhysicalAttribute> | |
| <ns0:PriceDetail> | |
| <ns0:LocalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| </ns0:LocalPrice> | |
| <ns0:AdditionalPrices> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>FRANCE</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>FR</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>FRA</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>250</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>BELGIUM</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>BE</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>BEL</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>56</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>NETHERLANDS</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>NL</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>NLD</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>528</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>GERMANY</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>DE</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>DEU</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>276</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>ITALY</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>IT</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>ITA</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>380</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>12.50</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>GBP</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>35</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>GBP</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>UNITED KINGDOM</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>GB</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>GBR</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>826</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>IRELAND</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>IE</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>IRL</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>372</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>114.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>DKK</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>399.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>DKK</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>DENMARK</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>DK</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>DNK</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>208</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>GREECE</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>GR</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>GRC</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>300</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>34.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>SPAIN</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>ES</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>ESP</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>724</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>21</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>CAD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>70</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>CAD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>CANADA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>CA</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>CAN</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>124</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>18.58</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>64.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>LEBANON</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>LB</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>LBN</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>422</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>151.50</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>NOK</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>499.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>NOK</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>NORWAY</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>NO</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>NOR</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>578</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>156.20</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>SEK</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>499.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>SEK</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>SWEDEN</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>SE</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>SWE</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>752</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>FINLAND</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>FI</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>FIN</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>246</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>HUNGARY</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>HU</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>HUN</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>348</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>AUSTRIA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>AT</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>AUT</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>40</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>16.60</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>CHF</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>49.90</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>CHF</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>SWITZERLAND</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>CH</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>CHE</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>756</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>20</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>49.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>TURKEY</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>TR</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>TUR</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>792</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>400</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>TRY</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>999.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>TRY</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>TURKEY</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>TR</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>TUR</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>792</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>64.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>PLN</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>179.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>PLN</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>POLAND</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>PL</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>POL</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>616</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>343</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>CZK</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>1029</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>CZK</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>CZECH REPUBLIC</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>CZ</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>CZE</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>203</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>UKRAINE</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>UA</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>UKR</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>804</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>1203.45</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>RUB</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>3490</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>RUB</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>RUSSIAN FEDERATION</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>RU</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>RUS</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>643</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>SLOVENIA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>SI</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>SVN</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>705</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>16.67</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>45</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>USA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>US</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>USA</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>840</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>CROATIA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>HR</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>HRV</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>191</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>1275</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>INR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>3195</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>INR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>INDIA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>IN</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>IND</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>356</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>14.28</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>EUR</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>EUR</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>TUNISIA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>TN</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>TUN</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>788</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>16.20</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>44.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>CHILE</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>CL</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>CHL</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>152</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>25.90</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>AUD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>69.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>AUD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>AUSTRALIA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>AU</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>AUS</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>36</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>555.19</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>MXN</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>1499</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>MXN</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>MEXICO</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>MX</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>MEX</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>484</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>29.99</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>NZD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>89.99</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>NZD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>NEW ZEALAND</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>NZ</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>NZL</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>554</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>13.87</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>39.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>PANAMA</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>PA</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>PAN</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>591</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| <ns0:AdditionalPrice> | |
| <ns0:GrossPriceAmount>20.25</ns0:GrossPriceAmount> | |
| <ns0:GrossPriceCurrency>USD</ns0:GrossPriceCurrency> | |
| <ns0:RetailPriceAmount>59.95</ns0:RetailPriceAmount> | |
| <ns0:RetailPriceCurrency>USD</ns0:RetailPriceCurrency> | |
| <ns0:Country> | |
| <ns0:CountryName>URUGUAY</ns0:CountryName> | |
| <ns0:CountryCodeAlpha2>UY</ns0:CountryCodeAlpha2> | |
| <ns0:CountryCodeAlpha3>URY</ns0:CountryCodeAlpha3> | |
| <ns0:CountryCodeNumber>858</ns0:CountryCodeNumber> | |
| </ns0:Country> | |
| </ns0:AdditionalPrice> | |
| </ns0:AdditionalPrices> | |
| </ns0:PriceDetail> | |
| <ns0:Pictures> | |
| <ns0:Picture> | |
| <ns0:ImageType>Pack Shot</ns0:ImageType> | |
| <ns0:ImagePerspective>Front</ns0:ImagePerspective> | |
| <ns0:FileReferenceUrl>https://bsdammediahub.blob.core.windows.net/productassets/12150148/2993779/e76023a4-19d7-41f2-a273-a8e000f1a9f3/e76023a4-19d7-41f2-a273-a8e000f1a9f3_12150148_2993779_001_preview.jpg</ns0:FileReferenceUrl> | |
| <ns0:ShortUrl>http://image.bestseller.com/e76023a4-19d7-41f2-a273-a8e000f1a9f3</ns0:ShortUrl> | |
| </ns0:Picture> | |
| </ns0:Pictures> | |
| <ns0:Pictures> | |
| <ns0:Picture> | |
| <ns0:ImageType>Pack Shot</ns0:ImageType> | |
| <ns0:ImagePerspective>Back</ns0:ImagePerspective> | |
| <ns0:FileReferenceUrl>https://bsdammediahub.blob.core.windows.net/productassets/12150148/2993779/e597e967-74b6-4d23-b190-a8e000f1bcb7/e597e967-74b6-4d23-b190-a8e000f1bcb7_12150148_2993779_002_preview.jpg</ns0:FileReferenceUrl> | |
| <ns0:ShortUrl>http://image.bestseller.com/e597e967-74b6-4d23-b190-a8e000f1bcb7</ns0:ShortUrl> | |
| </ns0:Picture> | |
| </ns0:Pictures> | |
| </ns0:Variant> | |
| </ns0:Variants> | |
| <ns0:Assortments /> | |
| </ns0:Group> | |
| </ns0:Groups> | |
| </ns0:SalesPriceCatalogue_Xml_Full> | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment