SoundCloud Downloader
v1.0.10
SoundCloudからトラック/プレイリストをダウンロードするためのAndroidアプリケーション。
7200+ users, 1,38,000+ tracks downloaded
ここから最新の安定したAPKをダウンロードできます
SELECT
DATE ( u . created_at ) AS date ,
COUNT ( u . id ) AS total_users_joined
FROM
users u
GROUP BY
DATE ( u . created_at )
ORDER BY
date DESC ;
SELECT
u . id ,
u . name ,
u . email ,
u . imei ,
COUNT (DISTINCT r . id ) AS total_requests,
COUNT (DISTINCT dr . id ) AS total_downloads,
COUNT (DISTINCT t . id ) AS total_tracks,
u . is_active ,
(
SELECT
soundcloud_url
FROM
requests
WHERE
user_id = u . id
ORDER BY
id DESC
LIMIT 1
) AS last_hit
FROM
users u
LEFT JOIN
requests r ON r . user_id = u . id
LEFT JOIN
download_requests dr ON dr . request_id = r . id
LEFT JOIN
tracks t ON t . request_id = r . id
GROUP BY
u . id
ORDER BY
total_requests DESC ;