SELECT cArtNr AS 'sku',
cBarcode AS 'standard-product-id',
'EAN' AS 'product-id-type',
'Euere Kategorie' AS 'product_type',
cName AS 'title',
cHersteller AS 'brand',
cHersteller AS 'manufacturer',
'' AS 'mfr-part-number',
'' AS 'description',
'' AS 'bullet-point1',
'' AS 'bullet-point2',
'' AS 'bullet-point3',
'' AS 'bullet-point4',
'' AS 'bullet-point5',
'' AS 'recommended-browse-node1',
'' AS 'recommended-browse-node2',
'' AS 'fedas-id',
'' AS 'parent-sku',
'' AS 'relationship-type',
'' AS 'launch-date',
'' AS 'discontinue-date',
'' AS 'release-date',
'New' AS 'condition-type',
'' AS 'condition-note',
'' AS 'merchant-catalog-number',
'' AS 'legal-disclaimer',
'Euer Keyword 1' AS 'search-terms1',
'Euer Keyword 2' AS 'search-terms2',
'Euer Keyword 3' AS 'search-terms3',
'' AS 'search-terms4',
'' AS 'search-terms5',
'Euer Keyword' AS 'platinum-keywords1',
'' AS 'platinum-keywords2',
'' AS 'platinum-keywords3',
'' AS 'platinum-keywords4',
'' AS 'platinum-keywords5',
'' AS 'is-giftwrap-available',
'' AS 'is-gift-message-available',
'' AS 'item-weight-unit-of-measure',
'' AS 'item-weight',
'' AS 'item-dimension-unit-of-measure',
'' AS 'item-height',
'' AS 'item-length',
'' AS 'item-width',
'' AS 'shipping-weight-unit-of-measure',
'' AS 'shipping-weight',
'' AS 'assembly-instructions',
'' AS 'is-assembly-required',
'' AS 'assembly-time-unit-of-measure',
'' AS 'assembly-time',
'' AS 'manufacturer-warranty-description',
'' AS 'manufacturer-safety-warning',
'' AS 'number-of-pieces',
'' AS 'number-of-players',
'' AS 'toy-award-name1',
'' AS 'toy-award-name2',
'' AS 'toy-award-name3',
'' AS 'toy-award-name4',
'' AS 'toy-award-name5',
'' AS 'are-batteries-included',
'' AS 'are-batteries-required',
'' AS 'battery-type1',
'' AS 'battery-type2',
'' AS 'battery-type3',
'' AS 'number-of-batteries1',
'' AS 'number-of-batteries2',
'' AS 'number-of-batteries3',
'' AS 'is-recalled',
'' AS 'recall-description',
'' AS 'minimum-manufacturer-age-recommended-unit-of-measure',
'' AS 'minimum-manufacturer-age-recommended',
'' AS 'maximum-manufacturer-age-recommended-unit-of-measure',
'' AS 'maximum-manufacturer-age-recommended',
'' AS 'minimum-merchant-age-recommended-unit-of-measure',
'' AS 'minimum-merchant-age-recommended',
'' AS 'maximum-merchant-age-recommended-unit-of-measure',
'' AS 'maximum-merchant-age-recommended',
'' AS 'minimum-manufacturer-weight-recommended-unit-of-measure',
'' AS 'minimum-manufacturer-weight-recommended',
'' AS 'maximum-manufacturer-weight-recommended-unit-of-measure',
'' AS 'maximum-manufacturer-weight-recommended',
'' AS 'main-image-url',
'' AS 'other-image-url1',
'' AS 'other-image-url2',
'' AS 'other-image-url3',
'' AS 'other-image-url4',
'' AS 'other-image-url5',
'' AS 'other-image-url6',
'' AS 'other-image-url7',
'' AS 'other-image-url8',
Convert(decimal(5,2), fEbayPreis) AS 'item-price',
'' AS 'sale-price',
'EUR' AS 'currency',
'' AS 'fulfillment-center-id',
'' AS 'sale-start-date',
'' AS 'sale-end-date',
nLagerbestand AS 'quantity',
'' AS 'leadtime-to-ship',
'' AS 'restock-date',
'' AS 'max-aggregate-ship-quantity',
'' AS 'is-discontinued-by-manufacturer',
'' AS 'registered-parameter',
'' AS 'update-delete'
FROM tartikel
where nLagerbestand >= 0 and
cAktiv = 'Y' and
cBarcode != 'NULL'
order by cArtNr
)