when having issues with data assist search, I find it helpful to write the sql being generated to the page and then try to execute the query on the database directly.
add the following code after the body tag of the results page:
<?php echo($query_limit_WADAtbl_AVVPSponsorReg); ?>
this will write the sql to the page to use for troubleshooting.