Code:
SELECT "irrelevant" as "Username", ExtractValue(c.thirdpartyinfo, "/ebid") as "Category ID",
ExtractValue(c.thirdpartyinfo, "/ebidstore") as"eBid Store Category",
IF(pa.ean13 IS NOT NULL,pa.ean13,IF(pa.upc IS NOT NULL,pa.upc, IF(p.ean13 IS NOT NULL,p.ean13,p.upc))) as "Barcode",
IF (pal.name IS NOT NULL, CONCAT(pl.name, " (", pal.name, ")"),pl.name) as "Auction Title",
CONCAT("http://", su.domain, su.physical_uri , IF(pai.id_image IS NOT NULL,pai.id_image,im.id_image), "/", REPLACE(pl.name," ","_"), ".jpg") as "Image URL",
p.condition as "Item Condition",
IF(sa.out_of_stock = 0 and (s.physical_quantity > 0 AND s.usable_quantity > 0),LEAST(s.physical_quantity,s.usable_quantity),25) as "Quantity",
"Immediate" as "Start", "3" as "End",
"" as "Starting Bid", "" as "Sales Tax", "" as "Reserve",
"gallery" as "Feature", "" as "YouTube Video ID",
IF(sp.price IS NOT NULL, p.price - IF(sp.reduction_type = "amount", sp.reduction, p.price * sp.reduction/100), p.price) as "BuyNow price",
m.name AS "Brand",
IF(p.weight<=0,"!NSP",IF(p.weight<=100,"!100",IF(p.weight<=250,"!250",IF(p.weight<=500,"!500",IF(p.weight<1000,"!000","!STD"))))) as "Domestic Shipping",
"" as "International Shipping",
"3|5|6|10|11" as "Payment Methods",
"10" as "Auto Repost",
CONCAT("ps_",sh.id_shop,"/",p.id_product) as "SKU",
udf_cleanstring(CONCAT(pl.description,IF(sup.product_supplier_reference IS NOT NULL, CONCAT(" <br>Reference - ",product_supplier_reference),IF(p.supplier_reference IS NOT NULL,CONCAT(" <br>Reference - ",p.supplier_reference),"")))) as "Description",
IF(p.active = 1 AND ( (s.physical_quantity > 0 OR s.usable_quantity > 0) OR sa.out_of_stock != 0 ),"ao","c") as "Action", "##end##"
FROM ps_product p
LEFT JOIN ps_shop sh ON sh.active = 1
LEFT JOIN ps_category c ON p.id_category_default = c.id_category
LEFT JOIN ps_shop_url su ON su.id_shop = sh.id_shop AND su.main = 1
LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_shop = sh.id_shop AND pl.id_lang = 1
LEFT JOIN ps_image im ON (p.id_product = im.id_product AND im.cover = 1)
LEFT JOIN ps_product_attribute pa ON (pa.id_product = p.id_product )
LEFT JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = pa.id_product_attribute)
LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND (sa.id_shop = 0 OR sa.id_shop = sh.id_shop) AND sa.id_product_attribute = IF(pac.id_product_attribute IS NULL,0,pac.id_product_attribute))
LEFT JOIN ps_stock s ON (s.id_product = p.id_product AND s.id_product_attribute = sa.id_product_attribute)
LEFT JOIN ps_attribute_lang pal ON (pal.id_attribute = pac.id_attribute AND pal.id_lang = 1)
LEFT JOIN ps_product_attribute_image pai ON (pai.id_product_attribute = s.id_product_attribute)
left join ps_product_supplier sup on p.id_product = sup.id_product and p.id_supplier = sup.id_supplier and sup.id_product_attribute = pa.id_product_attribute
LEFT JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
LEFT JOIN ps_specific_price sp ON (p.id_product = sp.id_product AND (sp.id_shop = sh.id_shop OR sp.id_shop = 0) AND sp.from < CURDATE() AND sp.to > CURDATE() )
WHERE p.id_shop_default = sh.id_shop AND ExtractValue(c.thirdpartyinfo,"/ebid") IS NOT NULL
You will need to change username at the top, obviously. Probably the shipping stuff too.