Closed ferronn-dev closed 3 years ago
spellcategoryid="330" gets the mount items
$ bq query -n 1000 'select s.display_lang from itemeffect e, itemsparse s where e.spellcategoryid = "330" and s.id = e.parentitemid'
Waiting on bqjob_r41414bc61ab4de21_0000017923902485_1 ... (0s) Current status: DONE
+--------------------------------------+
| display_lang |
+--------------------------------------+
| Horn of the Frostwolf Howler |
| Brown Horse Bridle |
| Knight-Lieutenant's Steed |
| Horn of the Gray Wolf |
| White Stallion |
| Black Stallion Bridle |
| Palomino |
| Pinto Bridle |
| Horn of the Black Wolf |
| Horn of the Red Wolf |
| Horn of the Timber Wolf |
| Horn of the Winter Wolf |
| Riding Gryphon Reins |
| Chestnut Mare Bridle |
| Horn of the Dire Wolf |
| Horn of the Brown Wolf |
| Blood Guard's Mount |
| Gray Ram |
| Harness: Black Ram |
| Harness: Blue Ram |
| White Ram |
| Brown Ram |
| Reins of the Striped Frostsaber |
| Whistle of the Emerald Raptor |
| Horn of the Skeletal Mount |
| Reins of the Night saber |
| Reins of the Leopard |
| Reins of the Spotted Frostsaber |
| Reins of the Bengal Tiger |
| Reins of the Spotted Nightsaber |
| Reins of the Striped Nightsaber |
| Old Whistle of the Ivory Raptor |
| Whistle of the Turquoise Raptor |
| Old Whistle of the Obsidian Raptor |
| Whistle of the Violet Raptor |
| Red Mechanostrider |
| Blue Mechanostrider |
| White Mechanostrider Mod A |
| Reins of the Nightsaber |
| Reins of the Frostsaber |
| Reins of the Primal Leopard |
| Reins of the Tawny Sabercat |
| Reins of the Golden Sabercat |
| Horn of the Red Wolf |
| Horn of the Arctic Wolf |
| Lieutenant General's Mount |
| Palomino Bridle |
| Commander's Steed |
| White Stallion Bridle |
| Whistle of the Mottled Red Raptor |
| Reins of the Winterspring Frostsaber |
| Whistle of the Ivory Raptor |
| Green Mechanostrider |
| Unpainted Mechanostrider |
| Purple Mechanostrider |
| Red & Blue Mechanostrider |
| Fluorescent Green Mechanostrider |
| Icy Blue Mechanostrider Mod A |
| Frost Ram |
| Black Ram |
| Red Skeletal Horse |
| Blue Skeletal Horse |
| Brown Skeletal Horse |
| Green Skeletal Warhorse |
| Deathcharger's Reins |
| Test Epic Mount |
| Kodo Mount |
| Gray Kodo |
| Brown Kodo |
| Green Kodo |
| Teal Kodo |
| Black War Steed Bridle |
| Black War Kodo |
| Black Battlestrider |
| Black War Ram |
| Whistle of the Black War Raptor |
| Red Skeletal Warhorse |
| Reins of the Black War Tiger |
| Horn of the Black War Wolf |
| Reins of the Swift Mistsaber |
| Reins of the Swift Dawnsaber |
| Reins of the Swift Frostsaber |
| Swift Yellow Mechanostrider |
| Swift White Mechanostrider |
| Swift Green Mechanostrider |
| Swift Palomino |
| Swift White Steed |
| Swift Brown Steed |
| Swift Brown Ram |
| Swift Gray Ram |
| Swift White Ram |
| Swift Blue Raptor |
| Swift Olive Raptor |
| Swift Orange Raptor |
| Purple Skeletal Warhorse |
| Great White Kodo |
| Great Gray Kodo |
| Great Brown Kodo |
| Horn of the Swift Brown Wolf |
| Horn of the Swift Timber Wolf |
| Horn of the Swift Gray Wolf |
| Reins of the Swift Stormsaber |
| Stormpike Battle Charger |
| Swift Razzashi Raptor |
| Swift Zulian Tiger |
| Foror's Fabled Steed |
| Blue Qiraji Resonating Crystal |
| Red Qiraji Resonating Crystal |
| Yellow Qiraji Resonating Crystal |
| Green Qiraji Resonating Crystal |
| Black Qiraji Resonating Crystal |
| Skeletal Steed Reins |
| Riding Turtle |
+--------------------------------------+
... instead of a manual list