Method getDownloadFile

public static function getDownloadFile($id)
{
    $db = Factory::getDBO();
    $query = ' SELECT d.*, u.id as userid, o.order_token' . ' FROM #__phocacart_order_downloads AS d' . ' LEFT JOIN #__phocacart_orders AS o ON o.id = d.order_id' . ' LEFT JOIN #__users AS u ON u.id = o.user_id' . ' WHERE d.id = ' . (int) $id . ' AND d.published = 1' . ' ORDER BY d.id' . ' LIMIT 1';
    $db->setQuery($query);
    $file = $db->loadObject();
    return $file;
}