SELECT SQL_CALC_FOUND_ROWS with wordpress search

As discussed in the comments, your database prefix settings are off-kilter.

Check the database prefix actually in use in your database, and make sure it’s the same as the one in wp-config.php. Also make sure all of your WordPress-related tables have the same prefix.

You’ll also need to search through your database, particularly in the _options table, as the previous database prefix will be hard coded in there in a few places.