Aquatic Eco-Systems

• Home
• Aquaculture
• Lake Management
• Koi
• Aquarium
• Ponics

 

MYSQL ERROR [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-24,9' at line 4] SQL[select sc.*,min(price) as minprice,max(price) as maxprice from sub_categories sc, sub_category_products scp, products p where sc.category_id=202 and sc.id=scp.sub_category_id and scp.product_id=p.id and sc.active=1 group by sc.id order by sc.descr limit -24,9] cnt[8] Operation did not complete!
1:mysql/mysql->exec
2:aquaticeco_categories/aquaticeco_categories->viewprecall
3:aquaticeco_categories/cwainterface->_render
4:aquaticeco_categories/cwainterface->render
5:aquaticeco_categories/cwainterface->_view
6:aquaticeco_categories/cwainterface->view
7:aquaticeco_categories/aquaticeco_categories->view
8:aquaticeco_categories/cwainterface->_run
9:aquaticeco_categories/cwainterface->run
10:cwamodule/cwamodule->run
11:instance_manager/instance_manager->run
12:layout/layout->rendersection
13:layout/layout->rendersectioncache
14:layout/layout->render
15:page/page->render
1:mysql/mysql->getrow
2:aquaticeco_categories/aquaticeco_categories->viewprecall
3:aquaticeco_categories/cwainterface->_render
4:aquaticeco_categories/cwainterface->render
5:aquaticeco_categories/cwainterface->_view
6:aquaticeco_categories/cwainterface->view
7:aquaticeco_categories/aquaticeco_categories->view
8:aquaticeco_categories/cwainterface->_run
9:aquaticeco_categories/cwainterface->run
10:cwamodule/cwamodule->run
11:instance_manager/instance_manager->run
12:layout/layout->rendersection
13:layout/layout->rendersectioncache
14:layout/layout->render
15:page/page->render
1:mysql/mysql->getrow
2:aquaticeco_categories/aquaticeco_categories->viewprecall
3:aquaticeco_categories/cwainterface->_render
4:aquaticeco_categories/cwainterface->render
5:aquaticeco_categories/cwainterface->_view
6:aquaticeco_categories/cwainterface->view
7:aquaticeco_categories/aquaticeco_categories->view
8:aquaticeco_categories/cwainterface->_run
9:aquaticeco_categories/cwainterface->run
10:cwamodule/cwamodule->run
11:instance_manager/instance_manager->run
12:layout/layout->rendersection
13:layout/layout->rendersectioncache
14:layout/layout->render
15:page/page->render