your recordset already has a where clause in it, so i think the default where clause should be:
AND 0 <> 0
if that does not fix the error, change the following line:
$WADAproducts = mysql_query($query_limit_WADAproducts, $Connection1) or die(mysql_error());
to:
$WADAproducts = mysql_query($query_limit_WADAproducts, $Connection1) or die(mysql_error()."<br />".$query_limit_WADAproducts);
this will write the sql causing the error to the page so we can look into it further.