Drilldown: Factions
Choose a table:
- Anatomies (737)
- ArtifactData (441)
- Characters (1101)
- CookingEffects (65)
- CorpseTables (78)
- Corpses (118)
- CreatureFactions (704)
- CreatureMutations (860)
- Cybernetics (77)
- DynamicObjects (1939)
- Effects (82)
- EncounterTableRows (2118)
- EncounterTables (70)
- ExtraInfo (1718)
- FactionFeelings (138)
- Factions (76)
- Food (138)
- FurnitureData (25)
- GeneralData (2800)
- Inventory (1298)
- ItemsTable (1177)
- Liquids (27)
- Locations (42)
- MissileWeaponData (66)
- Modability (563)
- Mods (65)
- Mutations (130)
- OnEatEffects (21)
- PhysicalProperties (1080)
- Quests (27)
- Recipes (10)
- ReputationBonuses (49)
- Skills (154)
- VersHist (679)
- VersHistInfobox (2636)
- WaterRitualSkills (16)
- All pages (14276)
Factions > BuyInterests 
:
humanoid settlements or
underground locations
& RecipeReputationCost:
None
& ParentFaction :
Beasts or
Plants
& JoinKey :
Dogs or
Hermits or
Merchants' Guild
:
humanoid settlements or
underground locations
& RecipeReputationCost:
None
& ParentFaction :
Beasts or
Plants
& JoinKey :
Dogs or
Hermits or
Merchants' Guild Use the filters below to narrow your results.
FactionID:
IsVisible:
BasePlayerReputation:
WaterRitualSkill:
WaterRitualRecipe:
BuyInterests: (Click arrow to add another value)
SellInterests:
SkillReputationCost:
RecipeReputationCost:
WaterRitualLiquid:
ParentFaction: (Click arrow to add another value)
Old:
PlainName:
JoinKey: (Click arrow to add another value)
Showing below up to 1 result in range #1 to #1.
View (previous 250 | next 250) (20 | 50 | 100 | 250 | 500)
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Guild') ORDER BY `Factions_alias`.`_pageName` LIMIT 250' at line 1 (localhost)
Function: CargoSQLQuery::run
Query: SELECT `Factions_alias`.`_pageName` AS `_pageName` FROM `Factions` `Factions_alias` LEFT OUTER JOIN `Factions__BuyInterests` `Factions_alias__BuyInterests` ON ((`Factions_alias`.`_ID`=`Factions_alias__BuyInterests`.`_rowID`)) WHERE (`Factions_alias__BuyInterests`.`_value` = 'humanoid settlements' OR `Factions_alias__BuyInterests`.`_value` = 'underground locations') AND (((`Factions_alias`.`RecipeReputationCost` = '' AND `Factions_alias`.`RecipeReputationCost` != 0) OR `Factions_alias`.`RecipeReputationCost` IS NULL) ) AND (`Factions_alias`.`ParentFaction` = 'Beasts' OR `Factions_alias`.`ParentFaction` = 'Plants') AND (`Factions_alias`.`JoinKey` = 'Dogs' OR `Factions_alias`.`JoinKey` = 'Hermits' OR `Factions_alias`.`JoinKey` = 'Merchants' Guild') ORDER BY `Factions_alias`.`_pageName` LIMIT 250