User:Teamtoto/Sandbox

{{#cargo_query:tables=GeneralData=GD,CreatureFactions=CF,_pageData=PD,_pageData___categories=PDC|fields=GD._pageName|join on=GD._pageName=CF._pageName,PDC._rowID=PD._ID,PD._pageName=GD._pageName|where=CF.Faction="Barathrumites" AND PDC._value <>"Unique_Characters"}}

Error: Table "PDC" is not included within the join conditions.

Error 1054: Unknown column 'GD._pageName' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `PD`.`_pageID` AS `cargo_backlink_page_id_PD`,`CF`.`_pageID` AS `cargo_backlink_page_id_CF`,`GD`.`_pageID` AS `cargo_backlink_page_id_GD`,`GD`.`_pageName` AS `_pageName`,`PD`.`_categories__full` AS `_categories__full` FROM `GeneralData` `GD`,`_pageData___categories` LEFT OUTER JOIN `CreatureFactions` `CF` ON ((`GD`.`_pageName`=`CF`.`_pageName`)) LEFT OUTER JOIN `_pageData` `PD` ON ((`GD`.`_pageName`=`PD`.`_pageName`) AND (`_pageData___categories`.`_rowID`=`PD`.`_ID`)) WHERE `CF`.`Faction`="Barathrumites" ORDER BY `PD`.`_pageID`,`CF`.`_pageID`,`GD`.`_pageID`,`GD`.`_pageName`,`PD`.`_categories__full` LIMIT 100