,

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
,

Search for Product