"""SQL queries for publishing."""

OBTAIN_HFA_PENDING_RESUBMIT_REQUEST = """
    SELECT
      `hfa_orchard_track_licenses`.`id`,
      `hfa_orchard_track_licenses`.`orchard_track_id`,
      `hfa_orchard_track_licenses`.`state`,
      `hfa_orchard_track_licenses`.`hfa_configuration_code`
    FROM `hfa_orchard_track_licenses`
    WHERE state in ('pending','resubmit')
    AND created_at >= %s;
"""