Unknown column 'swfobject_modified.js' in 'where clause' SQL=select bc.*, ct.name as typeName, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias ORDER BY cg.name separator '#') as categories, 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=swfobject_modified.js group by bc.id order by name
Go Back Home