$10

There is no reserved keyword in use, yet that is the error I get?

mysql> explain insert into batterylog_unique (

    ->             select * from batterylog

    ->             where id in (

    ->               select A.id from batterylog A

    ->               where A.testing_date = (

    ->                 select max(B.testing_date) from batterylog B

    ->                 where A.brand_battery_country = B.brand_battery_country);

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

	            select * from batterylog

	            whe' at line 1