"""Vendor Assigned-Reviewer Query."""

VENDOR_ASSIGNED_REVIEWER_SQL = """
SELECT
    o.`id`,
    o.`f_name`,
    o.`l_name`,
    o.`email`
FROM `vendor` v
INNER JOIN `orchadmin_users` o on v.`assigned_reviewer` = o.`id`
WHERE v.`vendor_id`=:vendor_id;
"""