SELECT  topic.topic_id, ((COUNT(parent.topic_id)-1) * 30) AS margin, topic.topic_left, topic.topic_right,
        IF( COUNT(parent.topic_id) > 1, 1, 0 ) as is_reply, topic.topic_deleted,
        topic.topic_text as format_html_topic_text, 
        user.user_real_name, user.user_name, user.user_num_reviews,
        CONCAT( '', user.user_name ) as artist_page_url,
        DATE_FORMAT( topic.topic_date, '%a, %b %e, %Y @ %l:%i %p' ) as topic_date_format,
        user.user_image as user_image,
        IF( LENGTH(user_image) > 0, CONCAT( '', user_name,  '/',  user_image ), '' ) as user_avatar_url
FROM cc_tbl_topics AS topic, 
     cc_tbl_topics AS parent,
     cc_tbl_user AS user
WHERE 1 AND (topic.topic_upload = 41369)
        AND (topic.topic_type <> 'collab') 
        AND (topic.topic_user = user_id) 
        AND (topic.topic_left BETWEEN parent.topic_left AND parent.topic_right)
GROUP BY topic.topic_id
ORDER BY (topic.topic_left)  asc

Got error 28 from storage engineERROR(1024) "/var/www/ccmixter/cchost_lib/cc-database.php"(151): Internal error, contact the admin [2017-01-21 22:02 pm][][/reviews/aliteralmind/41369]

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.