Check version of Firefox installed against latest version from Firefox website

firefoxversion.sql

--Tested and working as of 2020-07-14
select
  version as Current,
  (
    select
      substr(
        result,(
          (
            select
              instr(result, 'data-latest-firefox=')
            from
              curl
            where
              url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
          ) + 21
        ),
        6
      ) as Latest
    from
      curl
    where
      url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
  ) as Latest
from
  programs
where
  name like '%firefox%'
  and version < (
    select
      substr(
        result,(
          (
            select
              instr(result, 'data-latest-firefox=')
            from
              curl
            where
              url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
          ) + 21
        ),
        6
      ) as Latest
    from
      curl
    where
      url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
  )