Stuff

SELECT
	products.id,
	products.supnum,
	products.stock,
	products.prefer,
	products.ean AS pEAN,
	products.name AS pName,
	products.d1,
	products.d1_margin,
	prod_alltoys.userprice AS x_userprice
FROM
	prod_cat_set
	INNER JOIN products ON prod_cat_set.id_products = products.id
	LEFT JOIN prod_alltoys ON products.supnum = prod_alltoys.cataloguenumber
WHERE
	prod_cat_set.id_cat_ext = 681 AND
	products.active = '1' AND
	products.d1 >= 0
LIMIT 0,150