https://yandex.ru/support/marketplace/assortment/files/index.html#file__format
#выгрузка для XLS яндекс маркет
select op.product_id, opd.name, op.image, opd.description, ocd.name as category, om.name as manufacturer, op.ean, op.price, op.quantity,
op.height, op.length, op.width, op.weight,
opa.text as country
from oc_product op
left join oc_product_description opd on op.product_id = opd.product_id
left join oc_product_to_category optc on op.product_id = optc.product_id
left join oc_category_description ocd on ocd.category_id = optc.category_id
left join oc_manufacturer om on om.manufacturer_id = op.manufacturer_id
left join oc_product_attribute opa on opa.product_id = op.product_id
where op.quantity > 0
and op.price > 1000
and ean not like '200%'
order by op.sku
