CiviCRM Community Forums (archive)

I tried passing in a contribution_id to participant/get & got all the participant records for that contact

The cut down version of the query is this

SELECT DISTINCT (
contact_a.id
) AS contact_id, contact_a.sort_name AS `sort_name`
FROM civicrm_contact contact_a
LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id
LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id
INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE (
civicrm_contribution.id =2358
AND civicrm_contribution.is_test =0
)
LIMIT 0 , 30

If it were this it would return the correct result

SELECT DISTINCT (
contact_a.id
) AS contact_id, contact_a.sort_name AS `sort_name`
FROM civicrm_contact contact_a
LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id
LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id
INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE (
civicrm_contribution.id =2358
AND civicrm_contribution.is_test =0
)
LIMIT 0 , 30

But of course this query is being generated deep in the bowels of the code so I presume that lots of other things expect it to work just the way it does....