The following SQL query might help you get started:
SELECT
BU_TRANS.DOC_ID,
BU_TRANS.document_title,
BU_TRANS.contact_combo_name,
PdmString(BU_TRANS.contact_id),
BU_TRANS.document_hits,
BU_TRANS.id,
BU_TRANS.document_vote_count,
BU_TRANS.document_avg_rating,
cnt.department_name,
KD.ACTIVE_STATE,
cnt.combo_name,
cnt.email_address,
PdmString(cnt.id)
FROM
BU_TRANS,
cnt,
KD
WHERE
(
BU_TRANS.contact_id = cnt.id
AND
BU_TRANS.DOC_ID = KD.id
AND
KD.ACTIVE_STATE >= 0
AND
KD.ACTIVE_STATE < 100
AND
KD.status_name IN ( 'Published' )
)