Need someone to lead product or development at your software company? I lead product and engineering teams and I'm looking for my next opportunity. Check out my resume and get in touch.

Related tags with Tags.app and Movable type

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

6 Jun 2006

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.

Recently Written

A framework for onboarding new employees (May 15): There’s no single good way to onboard an employee that works for every role. Here's a framework for creating a process that you can adapt to each situation.
TV hosts as a guide for software managers (May 10): Software managers can learn a lot from journalists or late night TV hosts and how they interview people.
The Improvement Flywheel (Apr 29): An incredible flywheel for the improvement of a development team. Fix a few things, and everything starts getting better.
Managers and technical ability (Dec 26): In technical fields, the closer you are to the actual work being done, the closer your skills need to resemble those of the people doing the work.
Dysfunctions of output-oriented software teams (Sep 17): Whatever you call it, the symptom is that you're measuring your progress by how much you build and deliver instead of measuring success by the amount of customer value you create.
Evaluative and generative product development (Aug 30): Customers never even talk to the companies that don't fit their needs at all. If the only product ideas you're considering are those that meet the needs of your current customers, then you're only going to find new customers that look exactly like your current customers.
Product Manager Career Ladder (Aug 19): What are the steps along the product management career path?
Building the Customer-Informed Product (Aug 15): Strong products aren't composed of a list of features dictated by customers. They are guided by strong visions, and the execution of that vision is the primary focus of product development.

Older...

Recently Read

Contact

Adam Kalsey

+1 916 600 2497

adam AT kalsey.com

Resume

Public Key