It might work, you'll have to test it to see if it does or not.
You're query code may need to be done like the following as there's technically 2 separate queries (1 that inputs the user and another that inputs the profile status):
if ($input['page']==1) {
$query.=",`_user`='".$input['user']."'";
if (get_site_option('manual_profile_approval','core')==1) {
$query.=",`status`=".STAT_APPROVED;
}
}
You can try your code change and then try what I provided to see if either one of them works.