Unknown column 'own' in 'where clause' 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 #__jbusinessdirectory_companies bc left join #__jbusinessdirectory_company_types ct on bc.typeId=ct.id left join #__jbusinessdirectory_company_contact cnt on bc.id=cnt.companyId left join #__jbusinessdirectory_company_category cc on bc.id=cc.companyId left join #__jbusinessdirectory_categories cg on cg.id=cc.categoryId left join #__jbusinessdirectory_categories ccm on ccm.id=bc.mainSubcategory and ccm.published=1 left join #__jbusinessdirectory_countries as cr on cr.id = bc.countryId where bc.id=own group by bc.id order by name
Go Back Home