SELECT
	COUNT(*)
FROM
	products
WHERE
	products.active = '1' AND
	d1 >= 0 AND
	EXISTS (SELECT * FROM prod_images WHERE products.id = prod_images.id_prod)