SELECT
	COUNT(*)
FROM
	products
	LEFT JOIN prod_alltoys ON products.supnum = prod_alltoys.cataloguenumber
	LEFT JOIN prod_images ON products.id = prod_images.id_prod
WHERE
	products.active = '1' AND
	d1 >= 0
GROUP BY
	products.id
HAVING
	pImages = 0