SELECT
upload_id,
IF( LENGTH(upload_name) > 31, CONCAT( SUBSTRING(upload_name,1,29), '...'), upload_name ) as upload_name_chop,
CONCAT( 'http://ccmixter.org/salman/files/', user_name, '/', upload_id ) as file_page_url,
IF( LENGTH(user_image) > 0, CONCAT( 'http://ccmixter.org/content/', user_name, '/', user_image ), 'http://ccmixter.org/mixter-files/images/mixter-default.gif' ) as user_avatar_url,
user_real_name, user_name, upload_score, upload_num_scores, upload_extra,
1 as thumbs_up, 1 as ratings_enabled,
CONCAT( 'http://ccmixter.org/salman/people/', user_name ) as artist_page_url,
license_img_small as license_logo_url, license_url, license_name,
CONCAT( 'http://ccmixter.org/salman/reviews/', user_name, '/', upload_id ) as reviews_url,
IF( upload_tags LIKE '%,audio,%', CONCAT( 'http://ccmixter.org/salman/api/query/stream.m3u?f=m3u&ids=', upload_id ) , '' ) as stream_url,
DATE_FORMAT( upload_date, '%a, %b %e, %Y @ %l:%i %p' ) as upload_date_format,
upload_contest, upload_name,
upload_num_remixes, upload_num_sources, upload_num_pool_sources, upload_num_pool_remixes
FROM cc_tbl_uploads
JOIN cc_tbl_user ON upload_user = user_id
JOIN cc_tbl_licenses ON upload_license = license_id
WHERE ((upload_banned = 0 AND upload_published = 1))
ORDER BY upload_date DESC
LIMIT 12 OFFSET 44772
Lost connection to MySQL server during queryERROR(1024) "/var/www/ccmixter/cchost_lib/cc-database.php"(169): Internal error, contact the admin [2025-12-19 08:36 am][216.73.216.36][/salman/files?offset=44772]
If you were in the middle of an upload or posting a message it probably worked OK but you should click here to get back to the site's home page or use your browser's BACK button to return to the site and make sure.
The admins have been notified of the problem and will look into it very shortly.