join attribute on attribute.individual_ref = I.individual_ref and attribute.attr_code_ref=9289 where condition
join attribute on attribute.individual_ref = I.individual_ref where condition and attribute.attr_code_ref=9289