Exception Occured.

Exception Message:

Could not sort products: SELECT * FROM ( SELECT DISTINCT * FROM ( SELECT DISTINCT tblCategory_Products.Product_ID, tblProduct_Text.Display_Name, tblProduct.Actual_Price FROM tblCategory_Products INNER JOIN tblProduct ON tblProduct.Product_ID = tblCategory_Products.Product_ID INNER JOIN tblProduct_Text ON tblProduct.Product_ID = tblProduct_Text.Product_ID WHERE tblProduct.Manufacturer_ID = 23 AND tblProduct.Hidden = '0' ORDER BY Actual_Price DESC LIMIT 24 ) AS foo ORDER BY Actual_Price ASC LIMIT -9 ) AS bar ORDER BY Actual_Price DESC .



In File:
/home/echosupp/public_html/controller/ManufacturerController.php

On Line:
314

Trace:

0 /home/echosupp/public_html/view/ManufacturerView.php(214): ManufacturerController->GetProductsIn(Object(ManufacturerModel), 12, 'Actual_Price', 'DESC', '2')
1 /home/echosupp/public_html/view/ManufacturerView.php(175): ManufacturerView->LoadAllProducts()
2 /home/echosupp/public_html/view/ManufacturerView.php(107): ManufacturerView->LoadMainContentColumn()
3 /home/echosupp/public_html/manufacturer.php(32): ManufacturerView->LoadDefault()
4 {main}