SELECT af.id,
af.contact_id,
af.assignment_id,
aff.value,
(
SELECT role
FROM assignments_contacts
WHERE id = af.contact_id
AND assignment_id = af.assignment_id
LIMIT 1
) as role,
(
SELECT value
FROM assignments_feedback_fields
WHERE field = 1
AND feedback_id = af.id
LIMIT 1
) as score,
(
SELECT concat(firstname,' ',lastname) as name
FROM assignments_contacts
WHERE id = af.contact_id
AND assignment_id = af.assignment_id
LIMIT 1
) as name,
af.publish_with_name
FROM assignments_feedback AS af,
assignments_feedback_fields AS aff WHERE af.sale_person_email = 'jari.kantonen@remax.fi'
AND aff.field IN (9,15,27)
AND aff.feedback_id = af.id
AND (
af.publish_with_name = 1
OR
af.publish_anonymously = 1
)
AND af.hidden = 0
ORDER BY af.insert_date DESC
LIMIT 20
