SELECT
                `products`.`prodID`,
                SUM(`product_offers`.`stock`) as total_stock
            FROM `product_offers`
            INNER JOIN `products` ON `product_offers`.`prodID` = `products`.`prodID`
            WHERE `products`.`category_id` IN (5353,5377,5378,5379,5380,5401,5427,5442,5443) AND product_offers.color_id=1 GROUP BY `products`.`prodID`
                ORDER BY total_stock = 0, `products`.`prodID`   -- Сортировка по наличию и по prodID, если товары имеют одинаковые характеристики
                LIMIT 12 OFFSET 0 -- Применяем LIMIT и OFFSET для пагинации
<br>Ошибка mysqli: 1247 : Reference 'total_stock' not supported (reference to group function)<br><br />
<b>Fatal error</b>:  Uncaught TypeError: mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in /var/www/domainspay/data/www/xrbrands.ru/application/controllers/controller_categorieseo.php:441
Stack trace:
#0 /var/www/domainspay/data/www/xrbrands.ru/application/controllers/controller_categorieseo.php(441): mysqli_num_rows(false)
#1 /var/www/domainspay/data/www/xrbrands.ru/application/controllers/controller_categorieseo.php(81): Controller_categorieseo-&gt;getProducts(Array, 'product_offers....', 12, 0, Array)
#2 /var/www/domainspay/data/www/xrbrands.ru/application/core/route.php(131): Controller_categorieseo-&gt;action_index()
#3 /var/www/domainspay/data/www/xrbrands.ru/application/core/route.php(76): Route::callAction(Object(Controller_categorieseo), 'action_index')
#4 /var/www/domainspay/data/www/xrbrands.ru/application/bootstrap.php(130): Route::start()
#5 /var/www/domainspay/data/www/xrbrands.ru/index.php(13): include('/var/www/domain...')
#6 {main}
  thrown in <b>/var/www/domainspay/data/www/xrbrands.ru/application/controllers/controller_categorieseo.php</b> on line <b>441</b><br />