308
editsAd placeholder
User:Korgat: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 260: | Line 260: | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' AND | where_to_find NOT REGEXP 'Lower City Sewers' AND | ||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | where_to_find NOT REGEXP 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | ||
| Line 274: | Line 275: | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' AND | where_to_find NOT REGEXP 'Lower City Sewers' AND | ||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | where_to_find NOT REGEXP 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | ||
| Line 341: | Line 343: | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Lower City Sewers%" | |tables=weapons; where = where_to_find like "%Lower City Sewers%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Undercity Ruins]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Undercity Ruins%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Undercity Ruins%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
| Line 816: | Line 831: | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' AND | where_to_find NOT REGEXP 'Lower City Sewers' AND | ||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | where_to_find NOT REGEXP 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | ||
| Line 833: | Line 849: | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' AND | where_to_find NOT REGEXP 'Lower City Sewers' AND | ||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | where_to_find NOT REGEXP 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | ||