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 'of.*, GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(cg.name separat' at line 1 SQL=select of.*, GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(cg.name separator '#') as categoryNames, GROUP_CONCAT(cg.alias separator '#') as categoryAliases from #__jbusinessdirectory_company_offers of left join #__jbusinessdirectory_company_offer_category cc on of.id=cc.offerId left join #__jbusinessdirectory_categories cg on cg.id=cc.categoryId where of.id=24
Go Back Home