change this line:
$rsAvailableHH = mysql_query($query_rsAvailableHH, $dbCMS) or die(mysql_error());
to:
$rsAvailableHH = mysql_query($query_rsAvailableHH, $dbCMS) or die($query_rsAvailableHH."<br />".mysql_error());
then go back to using:
$WADbSearch1_DefaultWhere = " AND status=0";
this will write the full query to the screen along with the error to give us some more information.