SoundCloud Downloader
v1.0.10
An android application to download tracks/playlists from SoundCloud.
7200+ users, 1,38,000+ tracks downloaded
You can download the latest stable APK from here
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;
