User:Egocarib/Sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
Line 4: | Line 4: | ||
|join on=Mutations._pageName = VersHist._pageName | |join on=Mutations._pageName = VersHist._pageName | ||
|where=Mutations._pageNamespace='0' AND Mutations.CreationCode<>'' AND Mutations.Deprecated='0' | |where=Mutations._pageNamespace='0' AND Mutations.CreationCode<>'' AND Mutations.Deprecated='0' | ||
|order by=VersHist.Version DESC | |order by=VersHist.Version DESC,Mutations._pageName | ||
}} | }} | ||
Revision as of 20:24, 29 October 2020
Error 1054: Unknown column 'Mutations.CreationCode' in 'where clause' (localhost)
Function: CargoSQLQuery::run Query: SELECT `Mutations`.`_pageName` AS `_pageName`,`VersHist`.`Version` AS `Version` FROM `Mutations` LEFT OUTER JOIN `VersHist` ON ((`Mutations`.`_pageName`=`VersHist`.`_pageName`)) WHERE `Mutations`.`_pageNamespace`='0' AND `Mutations`.`CreationCode`<> AND `Mutations`.`Deprecated`='0' ORDER BY `VersHist`.`Version` DESC,`Mutations`.`_pageName` LIMIT 100
Gathering together old stuff I was working on...
throwing axe
/9 4 | |
Damage
|
2d122-24 (Avg: 13) |
Weight
|
1# |