User:MusikAnimal/sandbox: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
* [https://spcodex.wiki/w/index.php?title=Special%3ACargoQuery&tables=shows&fields=_pageName%2C+venue%2C+COUNT%28_ID%29%3DCount&where=coords__lat+IS+NULL+AND+venue+IS+NOT+NULL&join_on=&group_by=venue%2C+location&having=&order_by%5B0%5D=date&order_by_options%5B0%5D=ASC&limit=1000&offset=0&format= Venues without coords] | |||
* [https://spcodex.wiki/wiki/Special:CargoQuery?title=Special%3ACargoQuery&tables=shows&fields=_pageName%2C+venue%2C+venue_type%2C+capacity%2C+location&where=venue+LIKE+%27%25Velodrome%25%27&join_on=&group_by=&having=&order_by%5B0%5D=&order_by_options%5B0%5D=ASC&limit=&offset=&format= venue LIKE query] | |||