SQL query to get a stock for only products without combinations

[Eusebio100]

Hello, I need to do a sql query to get a stock, but only for the products that do not have combinations.

Let's see if you can help me, I'm not sure.

Thanks.

[ps8modules]

SELECT a.* 
FROM ps_stock_available a 
WHERE a.id_product NOT IN (
  SELECT DISTINCT(b.id_product) FROM ps_product_attribute b
);