SELECT
                
                tattoo.id,tattoo.name,tattoo.create_time,tattoo.url,tattoo.preview,tattoo.config,
                (SELECT GROUP_CONCAT(features.name)) as tags
            
            FROM
                tattoo   
            JOIN features_bind_tattoo ON features_bind_tattoo.tattoo_id = tattoo.id AND features_bind_tattoo.feature_id  = 99 JOIN features ON features.id = features_bind_tattoo.feature_id 
            WHERE
                tattoo.is_private = 0
                AND
                tattoo.status_id = 1
                AND
                tattoo.preview IS NOT NULL
                 AND type_id=0
             GROUP BY tattoo.id 
             ORDER BY tattoo.position, tattoo.id desc                        
             LIMIT 0,8