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 '@actionline.com.br group by bc.id order by name' at line 11 SQL=select bc.*, ct.name as typeName,GROUP_CONCAT(cg.id) as categoryIds, GROUP_CONCAT(cg.name separator '#') as categoryNames, GROUP_CONCAT(cg.alias separator '#') as categoryAliases, cnt.contact_name, cnt.contact_email,cnt.contact_phone,cnt.contact_fax, cr.country_name, ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId from call_jbusinessdirectory_companies bc left join call_jbusinessdirectory_company_types ct on bc.typeId=ct.id left join call_jbusinessdirectory_company_contact cnt on bc.id=cnt.companyId left join call_jbusinessdirectory_company_category cc on bc.id=cc.companyId left join call_jbusinessdirectory_categories cg on cg.id=cc.categoryId left join call_jbusinessdirectory_categories ccm on ccm.id=bc.mainSubcategory and ccm.published=1 left join call_jbusinessdirectory_countries as cr on cr.country_id = bc.countryId where bc.id=dpo@actionline.com.br group by bc.id order by name
Go Back Home