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 'of plummer-id-9190683,1623686556)' at line 1
INSERT INTO dailyvisits (position,job_id,date) VALUES ('chief of police',city-plummer-comp-city of plummer-id-9190683,1623686556)