gen_user_error

ERROR SQL [ mysql4 ]

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 ')) order by categorynumericorder' at line 3 [1064]

SQL

select c.idcategory,c.categoryname,c.categoryorder,c.isleaf,c.topcategory,c.categorynumericorder from products_categories as c where isleaf=0 and c.idcategory in (select distinct(topcategory) from products_categories where idcategory in (select idcategory from products where isshown=1 and idcountry=)) order by categorynumericorder

BACKTRACE