SELECT
    DISTINCT(civicrm_contribution.id),
    contact_a.id AS contact_id,
    contact_a.contact_type  AS `contact_type`,
    contact_a.contact_sub_type  AS `contact_sub_type`,
    contact_a.sort_name  AS `sort_name`,
    contact_a.display_name  AS `display_name`,
    civicrm_contribution.id AS contribution_id,
    civicrm_contribution.currency AS `currency`,
    civicrm_contribution.receive_date AS `receive_date`,
    civicrm_contribution.non_deductible_amount AS `non_deductible_amount`,
    civicrm_contribution.total_amount AS `total_amount`,
    civicrm_contribution.fee_amount AS `fee_amount`,
    civicrm_contribution.net_amount AS `net_amount`,
    civicrm_contribution.trxn_id AS `trxn_id`,
    civicrm_contribution.invoice_id AS `invoice_id`,
    civicrm_contribution.cancel_date AS `cancel_date`,
    civicrm_contribution.cancel_reason AS `cancel_reason`,
    civicrm_contribution.receipt_date AS `receipt_date`,
    civicrm_contribution.thankyou_date AS `thankyou_date`,
    civicrm_contribution.SOURCE AS `contribution_source`,
    civicrm_contribution.amount_level AS `amount_level`,
    civicrm_contribution.is_test AS `is_test`,
    civicrm_contribution.is_pay_later AS `is_pay_later`,
    civicrm_contribution.check_number AS `check_number`,
    civicrm_contribution.campaign_id AS contribution_campaign_id,
    civicrm_contribution_type.id AS contribution_type_id,
    civicrm_contribution_type.name AS contribution_type,
    civicrm_contribution_type.accounting_code AS `accounting_code`,
    payment_instrument.id AS instrument_id,
    payment_instrument.label AS `payment_instrument`,
    civicrm_product.id AS product_id,
    civicrm_product.name AS `product_name`,
    civicrm_product.sku AS `sku`,
    civicrm_contribution_product.id AS contribution_product_id,
    civicrm_contribution_product.product_option AS `product_option`,
    civicrm_contribution_product.fulfilled_date AS `fulfilled_date`,
    civicrm_contribution_product.start_date AS `contribution_start_date`,
    civicrm_contribution_product.end_date AS `contribution_end_date`,
    civicrm_contribution.contribution_recur_id AS `contribution_recur_id`,
    civicrm_note_contribution.note AS contribution_note,
    contribution_status.VALUE AS contribution_status_id,
    contribution_status.label AS contribution_status,
    payment_instrument.name AS contribution_payment_instrument,
    civicrm_contribution.check_number AS contribution_check_number
FROM
    civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id
    INNER JOIN civicrm_contribution_type ON civicrm_contribution.contribution_type_id = civicrm_contribution_type.id
    LEFT  JOIN civicrm_contribution_product ON civicrm_contribution_product.contribution_id = civicrm_contribution.id
    LEFT  JOIN civicrm_product ON civicrm_contribution_product.product_id =civicrm_product.id
    LEFT JOIN civicrm_note civicrm_note_contribution ON (
        civicrm_note_contribution.entity_table = 'civicrm_contribution' AND
                        civicrm_contribution.id = civicrm_note_contribution.entity_id )
    LEFT JOIN civicrm_option_group option_group_payment_instrument ON ( option_group_payment_instrument.name = 'payment_instrument')
    LEFT JOIN civicrm_option_value payment_instrument ON (
        civicrm_contribution.payment_instrument_id = payment_instrument.VALUE AND
        option_group_payment_instrument.id = payment_instrument.option_group_id )
    LEFT JOIN civicrm_option_group option_group_contribution_status ON (option_group_contribution_status.name = 'contribution_status')
    LEFT JOIN civicrm_option_value contribution_status ON (
        civicrm_contribution.contribution_status_id = contribution_status.VALUE AND
        option_group_contribution_status.id = contribution_status.option_group_id )
    WHERE  ( civicrm_contribution.is_test = 0 )  AND (contact_a.is_deleted = 0)