Hi, I just upgraded to Hotspots Pro 5.3.9 and now I get the following error:

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 'AND m.catid IN ('32','33','34') AND m.state = 1 AND (m.publish_up = '0000-00-0' at line 3

The full SQL looks like this:

SELECT SQL_CALC_FOUND_ROWS m.id as hotspots_id, m.*
FROM j7vtr_hotspots_marker as m
WHERE AND m.catid IN ('32','33','34') AND m.state = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-09-29 18:32:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-29 18:32:02') AND m.access IN (1,1,5)
ORDER BY m.title ASC LIMIT 25

It looks like the sql is not being built correctly.

Thanks for your help,
Paul