#0 /usr/www/users/harbut/colinharbut/art-supplies/core/visual_module_rev_m_brand_subcategories.php(120): DB->select('? SE...')
#1 /usr/www/users/harbut/colinharbut/art-supplies/brand.php(143): VMReviewMenuBrandSubCategories->__construct(Object(DB), Array)
#2 /usr/www/users/harbut/colinharbut/art-supplies/cms2.php(524): include_once('/usr/www/users/...')
#3 {main}Query failed [
SELECT DISTINCT ID, NAME_L3, CATEGORY_ID, C_NAME, CAT_URL, URL_NAME, FIRSTPAR_ID FROM (
select c.ID, cm.NAME_L3, cm.CATEGORY_ID, c.NAME_L3 AS C_NAME, c.URL_NAME as CAT_URL, cm.URL_NAME
,sc.ID AS FIRSTPAR_ID, cm.NUMPP
from CONTENT_MANAGEMENT cm inner
join CATEGORY c on c.ID = cm.CATEGORY_ID
join CATEGORY sc on c.ID = sc.PARENT_ID
where sc.ID IN () AND c.PARENT_ID = 1
UNION
select c.ID, cm.NAME_L3, cm.CATEGORY_ID, c.NAME_L3 AS C_NAME, c.URL_NAME as CAT_URL, cm.URL_NAME
,ssc.ID AS FIRSTPAR_ID, cm.NUMPP
from CONTENT_MANAGEMENT cm inner
join CATEGORY c on c.ID = cm.CATEGORY_ID
join CATEGORY sc on c.ID = sc.PARENT_ID
join CATEGORY ssc on sc.ID = ssc.PARENT_ID
where ssc.ID IN () AND c.PARENT_ID = 1
) AS foo
order by NUMPP, NAME_L3]: 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 ') AND c.PARENT_ID = 1
UNION
select c.ID, cm.NAME_L3, cm.' at line 7