User:Korgat: Difference between revisions

User:Korgat (edit)

722 bytes added , 18 February

308

edits

@@ Line 278: / Line 278: @@
 <hr>
 {{#cargo_compound_query:
-tables=equipment; where = where_to_find like "%Wyrm's Crossing%"
+tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
      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 "%Wyrm's Crossing%"
+|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+<hr>
+Sold by [[Entharl Danthelon]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
+    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 "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
      AND rarity != "common" AND legacy IS NULL;
    fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type