SQL Error on 1 Website, not others?

I am using a bought template called "Beauty Shop". I have 6 zc sites, all on a dedicated server. All my sites are 1.3.8a, all relatively recent installs. All stores have the same mods: easy populate, ultimate seo, super orders, google xml sitemap.

Beauty Shop throws the error listed below when it's used on ONE of the sites. Other templates on this website work fine, and Beauty Shop works fine on any of the other sites. Unfortunately, I have been directed to use this exact template on this single site, the only place where it doesn't work!

"pd" is referenced in store/includes/modules/templatename/ in files featured_products.php, new_products.php, product_listing.php, and specials_index.php. None of my other templates have this SQL call, otherwise I would swap it out.

This error does not appear on the home page, or on a product page. It appears everywhere else: cats, subcats, search results, etc. So every click between the start page and an individual product page throws this error.

I'd like to either kill this sql or figure out how to stop this error from showing.

The class for the error is <div class="systemError">, which is not in the template style sheet.

1109 Unknown table 'pd' in field list
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_date_added, p.products_price, pd.products_description from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '166' and p.products_status = 1 ]