"""Query for retrieving details for the asset file."""
get_file_details = """SELECT ald.audio_channels,
       ald.frequency,
       ald.bits_per_sample,
       ald.filename,
       ald.md5_hash,
       sdaf.initial_folder,
       INET_NTOA(s.local_ip) AS host,
       aty.folder_structure
FROM asset a
    INNER JOIN asset_location al
        ON a.asset_id = al.asset_id
    INNER JOIN asset_location_detail ald
        ON al.asset_location_id = ald.asset_location_id
    INNER JOIN storage_drive sd
        ON al.storage_drive_id = sd.storage_drive_id
    INNER JOIN storage s
        ON sd.storage_id = s.storage_id
    INNER JOIN asset_type aty
        ON aty.asset_type_id = a.asset_type_id
    INNER JOIN storage_drive_asset_folder sdaf
        ON sdaf.storage_drive_id = sd.storage_drive_id
            and sdaf.asset_type_id = a.asset_type_id
WHERE a.upc = :upc
AND s.physical_location_id = :physical_location_id
AND aty.asset = :asset_type;"""