select tag,count(tag) from infobox_user_sendcard group by tag order by count(tag) desc limit 10
select a.uuid,substring_index(substring_index(a.tag,',',b.help_topic_id+1),',',-1)
from
infobox_user_sendcard a
join
mysql.help_topic b
on b.help_topic_id < (length(a.tag) - length(replace(a.tag,',',''))+1)
order by a.uuid;
select t.tag,count(t.tag) from (select a.uuid,substring_index(substring_index(a.tag,',',b.help_topic_id+1),',',-1) tag
from
infobox_user_sendcard a
join
mysql.help_topic b
on b.help_topic_id < (length(a.tag) - length(replace(a.tag,',',''))+1)
order by a.uuid) as t group by t.tag order by count(t.tag) desc limit 10
select a.uuid,substring_index(substring_index(a.tag,',',b.help_topic_id+1),',',-1)
from
infobox_user_sendcard a
join
mysql.help_topic b
on b.help_topic_id < (length(a.tag) - length(replace(a.tag,',',''))+1)
order by a.uuid;
select t.tag,count(t.tag) from (select a.uuid,substring_index(substring_index(a.tag,',',b.help_topic_id+1),',',-1) tag
from
infobox_user_sendcard a
join
mysql.help_topic b
on b.help_topic_id < (length(a.tag) - length(replace(a.tag,',',''))+1)
order by a.uuid) as t group by t.tag order by count(t.tag) desc limit 10