'That project template no longer exists.']); exit; } $sql = mysqli_query($mysqli, "SELECT ticket_template_id, ticket_template_name, ticket_template_subject, (SELECT COUNT(*) FROM task_templates WHERE task_template_ticket_template_id = ticket_template_id) AS task_count FROM ticket_templates WHERE ticket_template_id NOT IN (SELECT ticket_template_id FROM project_template_ticket_templates WHERE project_template_id = $project_template_id) AND ticket_template_archived_at IS NULL ORDER BY ticket_template_name ASC"); ob_start(); ?>