Issue wtih wrong values in SQL export

[ptityop]

I have a very odd issue, when exporting the catalog with wholesale prices, some wholesale prices come out as 0 .... Although the info shows in the backend as. I have a basic SQL query to pull up the catalogue with wholesale prices. Most of them are coming out fine but plenty of values in the wholesale column come out as 0-0000 although the wholesale price is properly set and showing properly in the admin ...

How can this happen knowing this is pulled out from the database.

I am also putting here the SQL query

Thanks in advance

SELECT 
	p.id_product 'Product ID',
	p.reference 'Reference',
	pl.name 'Product Name',
	p.price 'Price',
	p.wholesale_price 'Wholesale Price',
	s.quantity 'Quantity'
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category and cl.id_lang=2)
LEFT JOIN ps_stock_available s ON (p.id_product = s.id_product)
GROUP BY p.id_product
ORDER by p.reference

 

Edited May 3, 2023 by ptityop (see edit history)

[bera_ramazan]

The sql code is working and you should too.

[ptityop]

Hello, I know this works ... but this does not make sense, how can I have a value in the admin and o as vale in the database ... ?