Butchery: Difference between revisions

3 bytes added ,  21:39, 15 August 2020
m
(→‎Corpses that can be butchered: rewrote query, same great taste)
Line 9: Line 9:
{{#cargo_query:tables=Corpses=C,CorpseTables=CT
{{#cargo_query:tables=Corpses=C,CorpseTables=CT
|join on=C.JoinKey=CT.JoinKey
|join on=C.JoinKey=CT.JoinKey
|fields=CONCAT('{{((}}favilink page{{!}}',C._pageName,'{{))}}')=Page
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(C._pageName),'{{))}}')=Page
|where=CT.ObjectID IS NOT NULL AND C._pageNamespace = '0'
|where=CT.ObjectID IS NOT NULL AND C._pageNamespace = '0'
|group by=C._pageName
|group by=C._pageName