Condensing queries.

When making queries the way I do (creating them for each table for certain combinations) something important to do is condense the queries. You can't have sixty-two different inventory queries for each race/class combination for a template set. The method I use may not be perfect for this use, but it's done a darn good job so far. What I do is select from the tables, summing together racemasks (since Blizz seems to have the most overlap race to race rather than class to class,) grouping by other important columns. For example:

SELECT ID, SUM(RaceMask), ClassMask, AchievementID,                                                                                         Comment FROM mod_ptrtemplate_achievements GROUP BY ClassMask, AchievementID;
SELECT ID, SUM(RaceMask), ClassMask, Button, Action, Type,                                                                                  Comment FROM mod_ptrtemplate_action       GROUP BY ClassMask, Button, Action, Type;
SELECT ID, SUM(RaceMask), ClassMask, BagID, SlotID, ItemID, Quantity, Enchant0, Enchant1, Enchant2, Enchant3, Enchant4, Enchant5, Enchant6, Comment FROM mod_ptrtemplate_inventory    GROUP BY ClassMask, BagID, SlotID, ItemID, Quantity, Enchant0, Enchant1, Enchant2, Enchant3, Enchant4, Enchant5, Enchant6;
SELECT ID, SUM(RaceMask), ClassMask, QuestID,                                                                                               Comment FROM mod_ptrtemplate_quests       GROUP BY ClassMask, QuestID;
SELECT ID, SUM(RaceMask), ClassMask, FactionID, Standing,                                                                                   Comment FROM mod_ptrtemplate_reputations  GROUP BY ClassMask, FactionID, Standing;
SELECT ID, SUM(RaceMask), ClassMask, SkillID, Value, Max,                                                                                   Comment FROM mod_ptrtemplate_skills       GROUP BY ClassMask, SkillID, Value, Max;
SELECT ID, SUM(RaceMask), ClassMask, SpellID,                                                                                               Comment FROM mod_ptrtemplate_spells       GROUP BY ClassMask, SpellID;