value2=$(awk '$1=="root"{print $3}' /root/mysql.root.pw)
mysql --table --user=root --password=$value2 mag2_data << eof
select magic, resource_magic.magic_id, count(*) as cnt
from sample_resources
inner join resource_magic on sample_resources.magic_id = resource_magic.magic_id
group by resource_magic.magic_id
order by cnt desc;
eof