notepad++version.sql

--Tested and working as of 2020-07-17
select
	version as Current,
	(
		select
			substr(
				result,(
					(
						select
							instr(result, 'Current Version ')
						from
							curl
						where
							url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
					) + 16
				),
				5
			) as Latest
		from
			curl
		where
			url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
	) as Latest
from
	programs
where
	name like '%notepad++%'
	and version < (
		select
			substr(
				result,(
					(
						select
							instr(result, 'Current Version ')
						from
							curl
						where
							url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
					) + 21
				),
				6
			) as Latest
		from
			curl
		where
			url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
	)