gistfile1.sql

  SELECT
		(
			SELECT COUNT(*)
			FROM `VendorRequests`
			LEFT JOIN (
				SELECT *
				FROM (
					SELECT *
					FROM `MfgUpdates` AS `UpdatesOrdered`
					ORDER BY `UpdatesOrdered`.`When` DESC
				) `GroupingUpdates`
				GROUP BY `GroupingUpdates`.`Mfg`, `GroupingUpdates`.`Option`
			) AS `LastUpdate` ON (
				`VendorRequests`.`Vendor`=`LastUpdate`.`Mfg` AND
				`VendorRequests`.`Option`=`LastUpdate`.`Option`
			)
			WHERE
				`Vendor`=`ID` AND
				IFNULL(`VendorRequests`.`When` > `LastUpdate`.`When`, true)
		) AS `requests`,
		`mfg`.*
	FROM `mfg`

	$where
	ORDER BY $sorter