SELECT 
    upload_id, upload_name, user_real_name,
    CONCAT( 'https://ccmixter.org/people/', user_name ) as artist_page_url,
    CONCAT( 'https://ccmixter.org/files/', user_name, '/', upload_id ) as file_page_url,
    LOWER(CONCAT_WS(' ', upload_name, upload_description, upload_tags)) as qsearch
      
FROM cc_tbl_uploads
JOIN cc_tbl_user ON upload_user = user_id

WHERE ((upload_banned = 0  AND  upload_published = 1)) AND (LOWER(CONCAT(upload_name,upload_description,upload_tags))  LIKE '%mild-tinted%' OR LOWER(CONCAT(upload_name,upload_description,upload_tags))  LIKE '%material%')

ORDER BY upload_date DESC
LIMIT 12 OFFSET 24

Lost connection to MySQL server during queryERROR(1024) "/var/www/ccmixter/cchost_lib/cc-database.php"(164): Internal error, contact the admin [2024-06-01 19:16 pm][52.15.61.129][/search?offset=24&search_in=uploads&search_text=mild-tinted+material&search_type=any]

wups, ccMixter is experiencing technical difficulties...

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.