Related tags with Tags.app and Movable type

Freshness Warning
This article is over 12 years old. It's possible that the information you read below isn't current.

I’m using Tim Appnel’s excellent Tags.app to create my tags pages. For example, see my bestof tag that highlights some of my favorite blog entries.

A new addition to my tag pages is a list of tags that are regularly used with the selected tag. For example, when I use the tag folksonomy I often use the tags tags, tagyu, tagging, simplelinks, web20—those terms are related to folksonomy because I commonly use them together.

To install this feature on your site, you’ll first need to be using the Tags.app plugin. You’ll also need to have Brad Choate’s SQL plugin. And you’ll need to be using MySQL as your database. This might work with other SQL databases, but I haven’t tested it, so you’re on your own there.

Stick this code somewhere in your tag page templates...

Related tags: <MTSQL query="SELECT t1.tagmap_tag, count(t1.tagmap_tag) AS cnt FROM mt_tagmap as t1, mt_tagmap as t2 WHERE t2.tagmap_tag='[MTSearchString]' and t2.tagmap_entry_id=t1.tagmap_entry_id and t1.tagmap_tag != '[MTSearchString]' GROUP BY t1.tagmap_tag ORDER BY cnt desc LIMIT 5"><a href="/tag/<MTSQLColumn column="1">"><MTSQLColumn column="1"></a> </MTSQL>

The entire thing needs to be on a single line in your MT template.

This will take the top 5 tags by usage that are used in entries where the current tag is also used. Want to show more or less tags? Change the LIMIT 5 to LIMIT 10 or whatever number you’d like.

Timothy Appnel
June 8, 2006 11:33 PM

Nicely done Adam. Some form of related tags will be in Tags.App. I released a glimpse in the preview release of the next version of Tags.App I was working on in December. http://code.appnel.com/changelog/2005/12/000019.html That release was put on hold pending the native implemention of tagging in MT.

Your comments:

Text only, no HTML. URLs will automatically be converted to links. Your email address is required, but it will not be displayed on the site.

Name:

Not your company or your SEO link. Comments without a real name will be deleted as spam.

Email: (not displayed)

If you don't feel comfortable giving me your real email address, don't expect me to feel comfortable publishing your comment.

Website (optional):

Follow me on Twitter

Best Of

  • The best of 2006 I wrote a lot of drivel in 2006. Here's the things that are less crappy than the rest.
  • Where do the RSS ad startups fit in? Yahoo's RSS advertising service could spell trouble for pure-play RSS advertising services unless they adapt their business model.
  • The importance of being good Starbucks is pulling CD burning stations from their stores. That says something interesting about their brand.
  • Rounded corners in CSS There lots of ways to create rounded corners with CSS, but they always require lots of complex HTML and CSS. This is simpler.
  • Lock-in is bad T-Mobile thinks they'll get new Hotspot customers with exclusive content and locked-in devices.
  • More of the best »

Recently Read

Get More

Subscribe | Archives

12

Recently

One on One meetings for managers: Frequency and Duration (Nov 28)
How long should your 1:1s be? How often should you run them?
One on One meetings for managers (Nov 26)
A one on one meeting is one of the top ways you can build your managerial leverage
How the Sales organization in a large company slows innovation (Nov 16)
If you have a new innovative product inside a large established company, it can be much harder to reach product market fit than it would be for the same product in a startup.
Networking as an entrepreneur (Oct 23)
Having a network is crazy important. Networking is not.
Stretching your team (Jun 11)
Stretching your team is one of the best ways to improve your output, your team's happiness, and your velocity. But they'll need coaching.
Physical camera shutter for Cisco Spark Board (Jul 6)
A 3d printable design for a camera shutter for a Cisco Spark Board
My Travel Coffee Setup (Jan 20)
What my travel coffee brewing setup looks like, and how you can build your own for under $100.
Turkey Legs (May 30)
Product naming gone awry.

Subscribe to this site's feed.

Elsewhere

Tropo
Voice and communications platforms, including Tropo and Phono. Work.
SacStarts
The Sacramento technology startup community.
Pinewood Freak
Pinewood Derby tips and tricks

Contact

Adam Kalsey

Mobile: 916.600.2497

Email: adam AT kalsey.com

AIM or Skype: akalsey

Resume

PGP Key

©1999-2018 Adam Kalsey.
Content management by Movable Type.