OK, for anyone who gets the same error, you've just missed one $products_new_query_raw that needs to be changed to $listing_sq

Underneath the line:

Code:
$listing_sql = $db->bindVars($listing_sql, ':languageID', $_SESSION['languages_id'], 'integer');
is another line that needs to be changed to:

Code:
$products_new_split = new splitPageResults($listing_sql, MAX_DISPLAY_PRODUCTS_NEW);
That worked for me