IF(ISNULL(st.supp_reference), '', st.supp_reference) AS supp_reference,
refs.reference,
IF(gl.type=".ST_BANKTRANSFER.",MAX(gl.amount),SUM(IF(gl.amount>0, gl.amount,0))) as amount,
com.memo_,
IF(ISNULL(u.user_id),'',u.user_id) as user_id,
IF(ISNULL(st.supp_reference), '', st.supp_reference) AS supp_reference,
refs.reference,
IF(gl.type=".ST_BANKTRANSFER.",MAX(gl.amount),SUM(IF(gl.amount>0, gl.amount,0))) as amount,
com.memo_,
IF(ISNULL(u.user_id),'',u.user_id) as user_id,