Created
March 7, 2016 15:56
-
-
Save fuzzysteve/53dd6ee022b3e1e679e2 to your computer and use it in GitHub Desktop.
SQLite query to produce a list of everything in a market group (recursively). Needs at least 3.8
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH RECURSIVE child_groups(marketGroupID) AS ( Values(4) union select invMarketGroups.marketGroupID from invMarketGroups, child_groups where invMarketGroups.parentGroupID=child_groups.marketGroupID) select typename from child_groups join invTypes on invTypes.marketGroupID=child_groups.marketGroupID order by typename |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment