SELECT a.product_name, a.product_version, a.product_version_major, a.product_version_minor, a.product_date 
FROM `ProductUpdates` a, (SELECT product_name, product_version, product_version_major, product_version_minor, MAX(product_date) from 'ProductUpdates' GROUP BY product_name, product_version, product_version_major, product_version_minor
WHERE product_name = 'FluidMath'
AND product_version =1

SELECT product_name, product_version, product_version_major, product_version_minor, MAX(product_date) FROM ProductUpdates GROUP BY product_name, product_version, product_version_major, product_version_minor

SELECT product_name, product_version, MAX(product_version_major) as max_version_major
FROM ProductUpdates 
WHERE product_name = 'FluidMath' AND product_version = 1



SELECT b.product_name, b.product_version, b.product_version_major, MAX(product_version_minor) AS max_version_minor
FROM ProductUpdates b, 
	(SELECT product_name, product_version, MAX(product_version_major) AS max_version_major
	FROM ProductUpdates 
	WHERE product_name = 'FluidMath' AND product_version = 1) a
WHERE b.product_name = 'FluidMath' AND b.product_version = 1 AND b.product_version_major = a.max_version_major



SELECT c.product_name, c.product_version, c.product_version_major, c.product_version_minor, c.product_date, c.product_url
FROM ProductUpdates c,
	(SELECT b.product_name, b.product_version, b.product_version_major, MAX(product_version_minor) as max_version_minor
	FROM ProductUpdates b, 
		(SELECT product_name, product_version, MAX(product_version_major) as max_version_major
		FROM ProductUpdates 
		WHERE product_name = 'FluidMath' AND product_version = 1) a
	WHERE b.product_name = 'FluidMath' AND b.product_version = 1 AND b.product_version_major = a.max_version_major) b
WHERE c.product_name = 'FluidMath' AND c.product_version = 1 AND c.product_version_major = b.product_version_major AND c.product_version_minor = b.max_version_minor
