Query: | SELECT `ID`,`Path`,`Count`,`Key`, CONCAT('categories+name+', `Key`) AS `pName`, CONCAT('categories+title+', `Key`) AS `pTitle`,`Type`,`Icon`,`Parent_ID` FROM `fl_categories` WHERE (`Status` = 'active') AND (`Parent_ID` = '0') AND (`Type` = 'manufacturers') ORDER BY `Position` |