Got an SQL syntax error after migrating from mysql to mariadb 10.4.4

Just migrated to a Docker container with mariadb (no external access, before you ask). It doesn't like one of your queries that are executed when clicking on the link to show the detail of the event.

Page with links is https://www.lmmga.brightbox.moorlandshosting.net/about/club-events-2/year.listevents/2019/07/29/-

SQL query is:

MariaDB [lmmga_joomla]> SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , ev.created as created

    ->  , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup

    ->  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn

    ->  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup

    ->  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn

    ->  , ev.state as state

    ->  FROM (vr0sd_jevents_vevent as ev )

    ->  INNER JOIN vr0sd_jevents_repetition as rpt ON rpt.eventid = ev.ev_id

    ->  INNER JOIN vr0sd_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id

    ->  LEFT JOIN vr0sd_jevents_rrule as rr ON rr.eventid = ev.ev_id

    ->  INNER JOIN vr0sd_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid

    ->  WHERE ev.catid IN(-1,38,39)

    ->  AND ev.access IN (1,1) AND icsf.access IN (1,1)

    ->  AND rpt.rp_id = '28'

    ->  GROUP BY rpt.rp_id;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')

 INNER JOIN vr0sd_jevents_repetition as rpt ON rpt.eventid = ev.ev_id

 INNER J' at line 7

MariaDB [lmmga_joomla]> 

It's the brackets in the FROM clause that it doesn't like. Query runs OK if brackets removed. Not sure if results are still valid if removed though.

Support info:

PHP Version : 7.3.6

MySQL Version : 5.5.5-10.4.4-MariaDB-1:10.4.4+maria~bionic-log

Server Information : Linux c420659825cf 4.9.0-8-amd64 #1 SMP Debian 4.9.144-3.1 (2019-02-19) x86_64

Fix jQuery? : Yes

Load JEvents Bootstrap CSS? : Yes

Max Input Vars ? : 2000

Club code set? : No  

User Agent : Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/75.0.3770.90 Chrome/75.0.3770.90 Safari/537.36  

Joomla : 3.9.10

component_com_jevents : 3.4.50

component_com_jce : 2.3.2.3

component_com_acymailing : 5.8.1

module_mod_acymailing : 3.7.0

module_mod_jevents_cal : 3.4.50

module_mod_jevents_custom : 3.4.50

module_mod_jevents_filter : 3.4.50

module_mod_jevents_latest : 3.4.50

module_mod_jevents_legend : 3.4.50

module_mod_jevents_switchview : 3.4.50

plugin_acymailing_contentplugin : 3.7.0

plugin_acymailing_managetext : 1.0.0

plugin_acymailing_online : 3.7.0

plugin_acymailing_share : 1.0.0

plugin_acymailing_stats : 3.7.0

plugin_acymailing_tablecontents : 1.0.0

plugin_acymailing_tagcontent : 3.7.0

plugin_acymailing_tagsubscriber : 5.10.4

plugin_acymailing_tagsubscription : 5.10.4

plugin_acymailing_tagtime : 5.10.4

plugin_acymailing_taguser : 5.10.4

plugin_acymailing_template : 5.10.4

plugin_content_jevents : 3.4.50

plugin_editors_acyeditor : 5.10.4

plugin_editors_acyeditor_j30 : 4.6.2

plugin_finder_jevents : 3.4.50

plugin_installer_jeventsinstaller : 3.4.50 (not enabled)

plugin_search_eventsearch : 3.4.50

plugin_system_gwejson : 3.4.50

Many thanks for any advice.
Regards,
Tony Rogers.