Below are results for , for shoots shot from 2014-11-01 to 2015-12-31.

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 'As BROKEHOA FROM MV146441 WHERE MV146441.ENTRY = 2 ORDER By BROKEHOA DESC LIMIT ' at line 1: SELECT DISTINCT As BROKEHOA FROM MV146441 WHERE MV146441.ENTRY = 2 ORDER By BROKEHOA DESC LIMIT 3,1