I have a short Perl Script that worked fine under MySQL 4.0 but fails under newer MySQL (5.0.67-community-log MySQL Community Edition (GPL)). The JOIN needs to be cleaned up so that it will run under 5.0+
Error: Unknown column ‘shows.id’ in ‘on clause
