=^.^=
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 '2025-06-04 12:08:00' AND '2025-06-04 13:17:00' AND `subject` = 'journey'' at line 1

SELECT * FROM `r__Photos` AS `r__`  WHERE `r__project` = 'RRA'  AND `location` LIKE 'John+o'+Groats%' AND `capture_time` BETWEEN '2025-06-04 12:08:00' AND '2025-06-04 13:17:00' AND `subject` = 'journey'   ;

Bus Dog!