XYZ associationhiralSELECT a.sp_type_id FROM #__wei_service_point_types AS a LEFT JOIN jp9yn_falang_content AS b ON a.sp_type_id = b.reference_id AND b.reference_table = 'wei_service_point_types' AND b.language_id = 6 WHERE IF(b.id IS NULL, a.type_name, b.value) = 'association'getproffessionnameCharity