Jon.Severinsson.net - d20 Spells - List Spells
All spells for a ordered by name.
Could not successfully run query (SELECT SQL_CACHE `Name`, `Origin`, `School`, `Subschool`, `Descriptors`, `Components`, `CastingTime`, `Range`, `Target_Area_or_Effect`, `Duration`, `Save`, `SR`, `Description`, `FullDescription`, `SorWiz`, `Cleric`, `Druid`, `Adept_NPC`, `Bard`, `Paladin`, `Ranger`, `Assassin_Prestige`, `Blackguard_Prestige`, `Air`.`Level` AS `Air`, `Animal`.`Level` AS `Animal`, `Chaos`.`Level` AS `Chaos`, `Death`.`Level` AS `Death`, `Destruction`.`Level` AS `Destruction`, `Earth`.`Level` AS `Earth`, `Evil`.`Level` AS `Evil`, `Fire`.`Level` AS `Fire`, `Good`.`Level` AS `Good`, `Healing`.`Level` AS `Healing`, `Knowledge`.`Level` AS `Knowledge`, `Law`.`Level` AS `Law`, `Luck`.`Level` AS `Luck`, `Magic`.`Level` AS `Magic`, `Plant`.`Level` AS `Plant`, `Protection`.`Level` AS `Protection`, `Strength`.`Level` AS `Strength`, `Sun`.`Level` AS `Sun`, `Travel`.`Level` AS `Travel`, `Trickery`.`Level` AS `Trickery`, `War`.`Level` AS `War`, `Water`.`Level` AS `Water` FROM `spells` LEFT JOIN `domains` AS `Air` ON (`spells`.`Name` = `Air`.`Spell` AND `Air`.`Domain` = 'Air') LEFT JOIN `domains` AS `Animal` ON (`spells`.`Name` = `Animal`.`Spell` AND `Animal`.`Domain` = 'Animal') LEFT JOIN `domains` AS `Chaos` ON (`spells`.`Name` = `Chaos`.`Spell` AND `Chaos`.`Domain` = 'Chaos') LEFT JOIN `domains` AS `Death` ON (`spells`.`Name` = `Death`.`Spell` AND `Death`.`Domain` = 'Death') LEFT JOIN `domains` AS `Destruction` ON (`spells`.`Name` = `Destruction`.`Spell` AND `Destruction`.`Domain` = 'Destruction') LEFT JOIN `domains` AS `Earth` ON (`spells`.`Name` = `Earth`.`Spell` AND `Earth`.`Domain` = 'Earth') LEFT JOIN `domains` AS `Evil` ON (`spells`.`Name` = `Evil`.`Spell` AND `Evil`.`Domain` = 'Evil') LEFT JOIN `domains` AS `Fire` ON (`spells`.`Name` = `Fire`.`Spell` AND `Fire`.`Domain` = 'Fire') LEFT JOIN `domains` AS `Good` ON (`spells`.`Name` = `Good`.`Spell` AND `Good`.`Domain` = 'Good') LEFT JOIN `domains` AS `Healing` ON (`spells`.`Name` = `Healing`.`Spell` AND `Healing`.`Domain` = 'Healing') LEFT JOIN `domains` AS `Knowledge` ON (`spells`.`Name` = `Knowledge`.`Spell` AND `Knowledge`.`Domain` = 'Knowledge') LEFT JOIN `domains` AS `Law` ON (`spells`.`Name` = `Law`.`Spell` AND `Law`.`Domain` = 'Law') LEFT JOIN `domains` AS `Luck` ON (`spells`.`Name` = `Luck`.`Spell` AND `Luck`.`Domain` = 'Luck') LEFT JOIN `domains` AS `Magic` ON (`spells`.`Name` = `Magic`.`Spell` AND `Magic`.`Domain` = 'Magic') LEFT JOIN `domains` AS `Plant` ON (`spells`.`Name` = `Plant`.`Spell` AND `Plant`.`Domain` = 'Plant') LEFT JOIN `domains` AS `Protection` ON (`spells`.`Name` = `Protection`.`Spell` AND `Protection`.`Domain` = 'Protection') LEFT JOIN `domains` AS `Strength` ON (`spells`.`Name` = `Strength`.`Spell` AND `Strength`.`Domain` = 'Strength') LEFT JOIN `domains` AS `Sun` ON (`spells`.`Name` = `Sun`.`Spell` AND `Sun`.`Domain` = 'Sun') LEFT JOIN `domains` AS `Travel` ON (`spells`.`Name` = `Travel`.`Spell` AND `Travel`.`Domain` = 'Travel') LEFT JOIN `domains` AS `Trickery` ON (`spells`.`Name` = `Trickery`.`Spell` AND `Trickery`.`Domain` = 'Trickery') LEFT JOIN `domains` AS `War` ON (`spells`.`Name` = `War`.`Spell` AND `War`.`Domain` = 'War') LEFT JOIN `domains` AS `Water` ON (`spells`.`Name` = `Water`.`Spell` AND `Water`.`Domain` = 'Water') WHERE `Origin` IN ('SRD') AND `` != 255 ORDER BY `Name`) from DB: Unknown column '' in 'where clause'1