in reply to execute failed: called with 2 bind variables when 0 are needed
To put it another way, change $sth->execute(1, 10); to $sth->execute(); and your SQL statement will run as is (assuming your database has the queried table and fields).
In Section
Seekers of Perl Wisdom