SELECT
                COUNT(*) as `c`
            FROM
                tattoo   
            JOIN features_bind_tattoo ON features_bind_tattoo.tattoo_id = tattoo.id AND features_bind_tattoo.feature_id  = 32 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