select a.id as id,
       a.warehouse_id as warehouse_id,
       a.customer_id as customer_id,
       b.supplier_id as supplier_id,
       a.product_category_id as product_category_id,
       a.product_set_id as product_set_id,
       a.product_id as product_id,
       a.price as price,
       NULL as kick_back,
       NULL as pms,
       a.note as note,
       a.created_at as created_at,
       a.updated_at as updated_at
FROM wholesale_prices as a
LEFT JOIN product_sets as b on a.product_set_id = b.id
INTO OUTFILE "/tmp/wholesale_prices.csv" FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\';
