SELECT DISTINCT(contact_a.id) as contact_id, civicrm_contribution_type.id as contribution_type_id, civicrm_contribution_type.name as contribution_type, civicrm_pledge.id as pledge_id

FROM civicrm_contact contact_a

LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id
LEFT JOIN civicrm_contribution_type ON civicrm_contribution.contribution_type_id = civicrm_contribution_type.id

LEFT JOIN civicrm_pledge ON civicrm_pledge.contact_id = contact_a.id

WHERE ( contact_a.id = 91224 AND civicrm_pledge.is_test = 0 )