SELECT ups.upload_name, topic_id,
               reviewee.user_real_name as reviewee_user_real_name, 
               reviewer.user_real_name as reviewer_user_real_name,
		reviewer.user_image as reviewer_image ,  
		CONCAT( 'https://ccmixter.org/content/', reviewer.user_name, '/', reviewer.user_image ) as avatar_path , 
               CONCAT( 'http://ccmixter.org/ghostly/reviews/', reviewee.user_name, '/', upload_id, '#', topic_id ) as topic_url,
               CONCAT( 'http://ccmixter.org/ghostly/files/',  reviewee.user_name, '/', upload_id ) as file_page_url,
               CONCAT( 'http://ccmixter.org/ghostly/people/',  reviewee.user_name ) as artist_page_url,
               CONCAT( 'http://ccmixter.org/ghostly/people/',  reviewer.user_name ) as reviewer_page_url,
               topic_text as format_text_topic_text, topic_left,
               DATE_FORMAT( topic_date, '%a, %b %e %l:%i %p' ) as topic_date_format
        FROM cc_tbl_topics
        JOIN cc_tbl_uploads ups      ON topic_upload = ups.upload_id
        JOIN cc_tbl_user    reviewee ON ups.upload_user = reviewee.user_id
        JOIN cc_tbl_user    reviewer ON topic_user = reviewer.user_id
        WHERE 1 AND (topic_type = 'review')
        ORDER BY topic_date DESC
        LIMIT 30 OFFSET 83040

Lost connection to MySQL server during queryERROR(1024) "/var/www/ccmixter/cchost_lib/cc-database.php"(169): Internal error, contact the admin [2026-02-09 14:32 pm][216.73.216.101][/ghostly/reviews?offset=83040]

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.