MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INNER JOIN product p ON p.csub_ref = cs.cat_subid AND p.sale <> -1
IN...' at line 7 MySQL Query: DB=timewebn_timeweb, SQL=SELECT
c.name as categoryName,
cs.name as subCategoryName,
GROUP_CONCAT(DISTINCT m.title ORDER BY m.title ASC SEPARATOR ', ') as subCatDescn
FROM category c
INNER JOIN category_sub cs ON cs.cid_ref = c.catid AND cs.cat_subid =
INNER JOIN product p ON p.csub_ref = cs.cat_subid AND p.sale <> -1
INNER JOIN manufacturer m ON m.mid = p.mid
GROUP BY cs.name ,