Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[zamzom]

Trying to run SBA 1.5.4 for [ZC 1.5.8][PHP 8.0]
Few remarks for some errors in admin/products_with_attributes_stock page.

First it gives the following error
--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 1' at line 1

In admin/includes/classes/products_with_attributes_stock.php
on around line 376:

        $query_products =    "SELECT DISTINCT " . $retFieldsTxt . ((empty($search_order_by_fields) || empty($retFieldsTxt)) ? '' : ', ') . $search_order_by_fields . " 
          FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa 
          INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (pa.products_id = pd.products_id)
          INNER JOIN " . TABLE_PRODUCTS . " p ON (pa.products_id = p.products_id)
          WHERE 
          pd.language_id=" . (int)$language_id . "
          " . $w . "
          ORDER BY " . $search_order_by;
//        . $SearchRange;      // zamzom: Took it out, because splitPageResults adds another LIMIT which triggers MySql error

        if (!isset($_GET['seachPID']) && !isset($_GET['pwas-search-button']) && !isset($_GET['updateReturnedPID'])) {
          $products_split = new splitPageResults($_GET['page'], STOCK_SET_SBA_NUMRECORDS, $query_products, $products_query_numrows);
        } 

$SearchRange already carries a MySql LIMIT statement, however a consequtively coming call to splitPageResults adds another LIMIT statement so this triggers an error. I think the first $SearchRange can be ommited?