Template:Items by bits: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<div style="display:inline-table; vertical-align:top;"> {{#cargo_query:tables = ItemsTable | fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}",...") |
m (alphabetize) |
||
Line 3: | Line 3: | ||
| fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits | | fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits | ||
| where = Bits LIKE "%{{{1|0}}}%" AND _pageNamespace="0" | | where = Bits LIKE "%{{{1|0}}}%" AND _pageNamespace="0" | ||
| order by = ItemsTable.Bits | | order by = ItemsTable.Bits, _pageName | ||
| limit = 20 | | limit = 20 | ||
| more results text = | | more results text = | ||
Line 11: | Line 11: | ||
| fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits | | fields = CONCAT("{{favilink id{{!}}", ObjectID, "}}")=Item, CONCAT("{{Bits{{!}}", Bits, "}}")= Bits | ||
| where = Bits LIKE "%{{{1|0}}}%" AND _pageNamespace="0" | | where = Bits LIKE "%{{{1|0}}}%" AND _pageNamespace="0" | ||
| order by = ItemsTable.Bits | | order by = ItemsTable.Bits, _pageName | ||
| offset = 20 | | offset = 20 | ||
| limit = 20 | | limit = 20 |
Revision as of 04:14, 23 January 2021
Error 1054: Unknown column 'Bits' in 'field list' (localhost)
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink id|", ObjectID, "}}") AS `Item`,CONCAT("{{Bits|", Bits, "}}") AS `Bits` FROM `ItemsTable` WHERE Bits LIKE "%0%" AND _pageNamespace="0" ORDER BY `ItemsTable`.`Bits`,`_pageName` LIMIT 20
Error 1054: Unknown column 'Bits' in 'field list' (localhost)
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink id|", ObjectID, "}}") AS `Item`,CONCAT("{{Bits|", Bits, "}}") AS `Bits` FROM `ItemsTable` WHERE Bits LIKE "%0%" AND _pageNamespace="0" ORDER BY `ItemsTable`.`Bits`,`_pageName` LIMIT 20,20