ok here is some data for you to look at ...
CREATE TABLE `roster_api_items` (
`id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`context` varchar(100) DEFAULT NULL,
`bl` varchar(100) DEFAULT NULL,
`item_name` varchar(96) NOT NULL,
`item_color` varchar(16) NOT NULL,
`item_texture` varchar(64) NOT NULL,
`item_tooltip` mediumtext NOT NULL,
`level` int(11) DEFAULT NULL,
`item_level` int(11) DEFAULT NULL,
`item_type` varchar(64) DEFAULT NULL,
`item_subtype` varchar(64) DEFAULT NULL,
`item_rarity` int(4) NOT NULL DEFAULT '0',
`locale` varchar(16) DEFAULT NULL,
`timestamp` int(10) NOT NULL,
`json` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `roster_api_items`
--
INSERT INTO `roster_api_items` (`id`, `item_id`, `context`, `bl`, `item_name`, `item_color`, `item_texture`, `item_tooltip`, `level`, `item_level`, `item_type`, `item_subtype`, `item_rarity`, `locale`, `timestamp`, `json`) VALUES
(2116, 123910, '', '', 'Demonsteel Breastplate', '0070dd', 'inv_chest_plate_legionendgame_c_01', 'Demonsteel Breastplate<br /> Obliterum: 0/8<br />Binds when equipped<br />Item Level 815<br />Chest Plate<br />632 Armor<br />+1404 Stamina<br />+936 Strenght or Intelect<br />Durability 140 / 140 <br />Requires Level 110<br />', 110, 815, '', '', 3, 'en_US', 1479323908, '{"id":123910,"disenchantingSkillRank":0,"description":"","name":"Demonsteel Breastplate","icon":"inv_chest_plate_legionendgame_c_01","stackable":1,"itemBind":2,"bonusStats":[{"stat":74,"amount":936},{"stat":7,"amount":1404}],"itemSpells":[],"buyPrice":1970200,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":5,"equippable":true,"itemLevel":815,"maxCount":0,"maxDurability":140,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":394040,"requiredSkill":0,"requiredLevel":110,"requiredSkillRank":0,"itemSource":{"sourceId":182951,"sourceType":"CREATED_BY_SPELL"},"baseArmor":632,"hasSockets":false,"isAuctionable":true,"armor":632,"displayInfoId":145092,"nameDescription":" Obliterum: 0/8","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"trade-skill","bonusLists":[596,3408],"availableContexts":["trade-skill"],"bonusSummary":{"defaultBonusLists":[596,689,3408],"chanceBonusLists":[600,601,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Fireflash","id":13150},"stats":[{"statId":"32","delta":327,"maxDelta":818},{"statId":"36","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Peerless","id":13151},"stats":[{"statId":"32","delta":327,"maxDelta":818},{"statId":"49","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Quickblade","id":13152},"stats":[{"statId":"32","delta":327,"maxDelta":818},{"statId":"40","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Feverflare","id":13156},"stats":[{"statId":"36","delta":327,"maxDelta":818},{"statId":"49","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Aurora","id":13157},"stats":[{"statId":"36","delta":327,"maxDelta":818},{"statId":"40","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Harmonious","id":13161},"stats":[{"statId":"40","delta":327,"maxDelta":818},{"statId":"49","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Impatient","id":13170},"stats":[{"statId":"36","delta":1145}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Savant","id":13171},"stats":[{"statId":"49","delta":1145}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Adaptable","id":13172},"stats":[{"statId":"40","delta":1145}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Decimator","id":13176},"stats":[{"statId":"32","delta":1145}],"sockets":[]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:26 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1849","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"3090","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/123910?id=123910&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2117, 134185, '', '', 'Skoldiir Sabatons', '0070dd', 'inv_boot_plate_legionendgame_c_01', 'Skoldiir Sabatons<br /><br />Binds when picked up<br />Item Level 810<br />Feet Plate<br />430 Armor<br />+1005 Stamina<br />+530 Critical Strike<br />+313 Mastery<br />+670 Strenght or Intelect<br />Durability 65 / 65 <br />Requires Level 101<br />', 101, 810, '', '', 3, 'en_US', 1479323910, '{"id":134185,"disenchantingSkillRank":0,"description":"","name":"Skoldiir Sabatons","icon":"inv_boot_plate_legionendgame_c_01","stackable":1,"itemBind":1,"bonusStats":[{"stat":32,"amount":530},{"stat":74,"amount":670},{"stat":49,"amount":313},{"stat":7,"amount":1005}],"itemSpells":[],"buyPrice":1251538,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":8,"equippable":true,"itemLevel":810,"maxCount":0,"maxDurability":65,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":250307,"requiredSkill":0,"requiredLevel":101,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":430,"hasSockets":false,"isAuctionable":false,"armor":430,"displayInfoId":145075,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"dungeon-level-up-1","bonusLists":[1795],"availableContexts":["dungeon-level-up-1","dungeon-normal","dungeon-heroic","challenge-mode","dungeon-mythic","world-quest-1","world-quest-2","world-quest-3","world-quest-4","world-quest-5","world-quest-6","challenge-mode-2","challenge-mode-3","challenge-mode-jackpot","world-quest-7","world-quest-8","world-quest-9"],"bonusSummary":{"defaultBonusLists":[1795],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:29 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-127.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1854","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1265","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/134185?id=134185&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2118, 139065, '', '', 'Dreamwalker\' s Band', '0070dd', 'inv_70_quest_ring8a', 'Dreamwalker\' s Band<br /><br />Binds when picked up<br />Item Level 810<br />Finger Miscellaneous<br />+754 Stamina<br />+994 Haste<br />+587 Mastery<br />Requires Level 101<br />', 101, 810, '', '', 3, 'en_US', 1479323911, '{"id":139065,"disenchantingSkillRank":0,"description":"","name":"Dreamwalker\' s Band","icon":"inv_70_quest_ring8a","stackable":1,"itemBind":1,"bonusStats":[{"stat":49,"amount":587},{"stat":36,"amount":994},{"stat":7,"amount":754}],"itemSpells":[],"buyPrice":1111301,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":810,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":222260,"requiredSkill":0,"requiredLevel":101,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"dungeon-level-up-1","bonusLists":[1795],"availableContexts":["dungeon-level-up-1","dungeon-normal","dungeon-heroic","challenge-mode","dungeon-mythic","world-quest-1","world-quest-2","world-quest-3","world-quest-4","world-quest-5","world-quest-6","challenge-mode-2","challenge-mode-3","challenge-mode-jackpot","world-quest-7","world-quest-8","world-quest-9"],"bonusSummary":{"defaultBonusLists":[1795],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:29 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-115.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1856","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1218","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/139065?id=139065&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2119, 113900, '', '', 'Vertebrae Protector', 'a335ee', 'inv_6_0raid_necklace_2d', 'Vertebrae Protector<br /><br />Binds when picked up<br />Item Level 670<br />Neck Miscellaneous<br />+136 Strength<br />+204 Stamina<br />+92 Critical Strike<br />+89 Haste<br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323916, '{"id":113900,"disenchantingSkillRank":0,"description":"","name":"Vertebrae Protector","icon":"inv_6_0raid_necklace_2d","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":136},{"stat":36,"amount":89},{"stat":32,"amount":92},{"stat":7,"amount":204}],"itemSpells":[],"buyPrice":906067,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":2,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":181213,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":78},{"statId":"62","delta":78},{"statId":"63","delta":78}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:35 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-126.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1862","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1444","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113900?id=113900&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2120, 113990, '', '', 'Overdriven Spaulders', 'a335ee', 'inv_shoulder_plate_raidpaladin_o_01', 'Overdriven Spaulders<br /><br />Binds when picked up<br />Item Level 670<br />Shoulder Plate<br />264 Armor<br />+273 Stamina<br />+118 Haste<br />+123 Mastery<br />+182 Strenght or Intelect<br />Durability 100 / 100 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323917, '{"id":113990,"disenchantingSkillRank":0,"description":"","name":"Overdriven Spaulders","icon":"inv_shoulder_plate_raidpaladin_o_01","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":182},{"stat":49,"amount":123},{"stat":36,"amount":118},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":1565888,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":3,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":100,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":313177,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":264,"hasSockets":false,"isAuctionable":false,"armor":264,"displayInfoId":132618,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"74","delta":10},{"statId":"7","delta":16},{"statId":"36","delta":7},{"statId":"49","delta":7}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":104},{"statId":"62","delta":104},{"statId":"63","delta":104},{"statId":"64","delta":104}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:35 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-121.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1863","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1537","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113990?id=113990&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2121, 113916, '', '', 'Charbreath Firecloak', 'a335ee', 'inv_cape_draenorraid_d_01plate_warrior', 'Charbreath Firecloak<br /><br />Binds when picked up<br />Item Level 670<br />Cloak Cloth<br />58 Armor<br />+136 Strength<br />+204 Stamina<br />+95 Critical Strike<br />+84 Haste<br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323917, '{"id":113916,"disenchantingSkillRank":0,"description":"","name":"Charbreath Firecloak","icon":"inv_cape_draenorraid_d_01plate_warrior","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":136},{"stat":36,"amount":84},{"stat":32,"amount":95},{"stat":7,"amount":204}],"itemSpells":[],"buyPrice":1559756,"itemClass":4,"itemSubClass":1,"containerSlots":0,"inventoryType":16,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":311951,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":58,"hasSockets":false,"isAuctionable":false,"armor":58,"displayInfoId":139023,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":3},{"statId":"4","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":78},{"statId":"62","delta":78},{"statId":"63","delta":78}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:35 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-126.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1864","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1498","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113916?id=113916&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2122, 113896, '', '', 'Fleshmelter Bracers', 'a335ee', 'inv_plate_raiddeathknight_o_01bracer', 'Fleshmelter Bracers<br /><br />Binds when picked up<br />Item Level 670<br />Wrist Plate<br />154 Armor<br />+204 Stamina<br />+69 Haste<br />+104 Mastery<br />+136 Strenght or Intelect<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323918, '{"id":113896,"disenchantingSkillRank":0,"description":"","name":"Fleshmelter Bracers","icon":"inv_plate_raiddeathknight_o_01bracer","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":136},{"stat":49,"amount":104},{"stat":36,"amount":69},{"stat":7,"amount":204}],"itemSpells":[],"buyPrice":1047981,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":9,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":209596,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":154,"hasSockets":false,"isAuctionable":false,"armor":154,"displayInfoId":136968,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":3},{"statId":"74","delta":9},{"statId":"7","delta":13},{"statId":"36","delta":4},{"statId":"49","delta":6}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":78},{"statId":"62","delta":78},{"statId":"63","delta":78},{"statId":"64","delta":78}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:36 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1866","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1530","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113896?id=113896&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2123, 113906, '', '', 'Gauntlets of Dramatic Blows', 'a335ee', 'inv_plate_raiddeathknight_o_01glove', 'Gauntlets of Dramatic Blows<br /><br />Binds when picked up<br />Item Level 670<br />Hands Plate<br />220 Armor<br />+273 Stamina<br />+112 Critical Strike<br />+127 Mastery<br />+182 Strenght or Intelect<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323918, '{"id":113906,"disenchantingSkillRank":0,"description":"","name":"Gauntlets of Dramatic Blows","icon":"inv_plate_raiddeathknight_o_01glove","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":182},{"stat":49,"amount":127},{"stat":32,"amount":112},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":982695,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":10,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":196539,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":220,"hasSockets":false,"isAuctionable":false,"armor":220,"displayInfoId":136965,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":4},{"statId":"74","delta":10},{"statId":"7","delta":16},{"statId":"32","delta":7},{"statId":"49","delta":7}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":104},{"statId":"62","delta":104},{"statId":"63","delta":104},{"statId":"64","delta":104}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:37 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-118.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1867","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1543","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113906?id=113906&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2124, 113659, '', '', 'Fleshchewer Greatbelt', 'a335ee', 'inv_plate_raidwarrior_o_01belt', 'Fleshchewer Greatbelt<br /><br />Binds when picked up<br />Item Level 655<br />Waist Plate<br />190 Armor<br />+237 Stamina<br />+116 Critical Strike<br />+88 Haste<br />+158 Strenght or Intelect<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 655, '', '', 4, 'en_US', 1479323919, '{"id":113659,"disenchantingSkillRank":0,"description":"","name":"Fleshchewer Greatbelt","icon":"inv_plate_raidwarrior_o_01belt","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":158},{"stat":32,"amount":116},{"stat":36,"amount":88},{"stat":7,"amount":237}],"itemSpells":[],"buyPrice":931775,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":6,"equippable":true,"itemLevel":655,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":186355,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":190,"hasSockets":false,"isAuctionable":false,"armor":190,"displayInfoId":139972,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":3},{"statId":"74","delta":9},{"statId":"7","delta":14},{"statId":"32","delta":7},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":90},{"statId":"62","delta":90},{"statId":"63","delta":90},{"statId":"64","delta":90}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:37 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-127.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1868","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1525","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113659?id=113659&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2125, 113961, '', '', 'Iron Bellow Sabatons', 'a335ee', 'inv_plate_raidwarrior_o_01boots', 'Iron Bellow Sabatons<br /><br />Binds when picked up<br />Item Level 670<br />Feet Plate<br />242 Armor<br />+273 Stamina<br />+95 Critical Strike<br />+137 Haste<br />+182 Strenght or Intelect<br />Durability 80 / 80 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323920, '{"id":113961,"disenchantingSkillRank":0,"description":"","name":"Iron Bellow Sabatons","icon":"inv_plate_raidwarrior_o_01boots","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":182},{"stat":32,"amount":95},{"stat":36,"amount":137},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":1474679,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":8,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":80,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":294935,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":242,"hasSockets":false,"isAuctionable":false,"armor":242,"displayInfoId":132729,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":4},{"statId":"74","delta":10},{"statId":"7","delta":16},{"statId":"32","delta":5},{"statId":"36","delta":8}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":104},{"statId":"62","delta":104},{"statId":"63","delta":104},{"statId":"64","delta":104}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:38 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1870","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1531","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113961?id=113961&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2126, 116830, '', '', 'Researcher\'s Ring', '1eff00', 'inv_ringwod_7d', 'Researcher\'s Ring<br /><br />Binds when picked up<br />Item Level 588<br />Finger Miscellaneous<br />+64 Strength<br />+95 Stamina<br />+44 Versatility<br />+40 Mastery<br />', 0, 588, '', '', 2, 'en_US', 1479323921, '{"id":116830,"disenchantingSkillRank":0,"description":"","name":"Researcher\'s Ring","icon":"inv_ringwod_7d","stackable":1,"itemBind":1,"bonusStats":[{"stat":40,"amount":44},{"stat":49,"amount":40},{"stat":4,"amount":64},{"stat":7,"amount":95}],"itemSpells":[],"buyPrice":593678,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":588,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":2,"sellPrice":118735,"requiredSkill":0,"requiredLevel":0,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[15,171],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"QUALITY","id":3},"stats":[{"statId":"ilevel","delta":10},{"statId":"4","delta":6},{"statId":"7","delta":10},{"statId":"40","delta":4},{"statId":"49","delta":4}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"QUALITY","id":4},"stats":[{"statId":"ilevel","delta":20},{"statId":"4","delta":13},{"statId":"7","delta":20},{"statId":"40","delta":9},{"statId":"49","delta":9}],"sockets":[]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:39 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1871","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1365","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/116830?id=116830&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2127, 113599, '', '', 'Grunt\'s Solid Signet', 'a335ee', 'inv_ringwod_d_4', 'Grunt\'s Solid Signet<br /><br />Binds when picked up<br />Item Level 655<br />Finger Miscellaneous<br />+119 Strength<br />+178 Stamina<br />+84 Critical Strike<br />+71 Haste<br />Requires Level 100<br />', 100, 655, '', '', 4, 'en_US', 1479323921, '{"id":113599,"disenchantingSkillRank":0,"description":"","name":"Grunt\'s Solid Signet","icon":"inv_ringwod_d_4","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":119},{"stat":36,"amount":71},{"stat":32,"amount":84},{"stat":7,"amount":178}],"itemSpells":[],"buyPrice":1255368,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":655,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":251073,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":7},{"statId":"7","delta":11},{"statId":"32","delta":5},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":68},{"statId":"62","delta":68},{"statId":"63","delta":68}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:40 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-113.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1872","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1439","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113599?id=113599&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2128, 113645, '', '', 'Tectus\' Beating Heart', 'a335ee', 'inv_misc_trinket6oog_stonefist3', 'Tectus\' Beating Heart<br /><br />Binds when picked up<br />Item Level 655<br />Trinket Miscellaneous<br />+173 Strength<br />Requires Level 100<br />Equip: Your attacks have a chance to grant ^3.4782 Critical Strike for 10 sec. (Approximately 0.92 procs per minute)<br />', 100, 655, '', '', 4, 'en_US', 1479323922, '{"id":113645,"disenchantingSkillRank":0,"description":"","name":"Tectus\' Beating Heart","icon":"inv_misc_trinket6oog_stonefist3","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":173}],"itemSpells":[{"spellId":177041,"spell":{"id":177041,"name":"Item - Attacks Proc Critical Strike [Tectus\' Beating Heart]","icon":"spell_shadow_siphonmana","description":"Your attacks have a chance to grant ^3.4782 Critical Strike for 10 sec. (Approximately 0.92 procs per minute)","castTime":"Passive"},"nCharges":0,"consumable":false,"categoryId":0,"trigger":"ON_EQUIP"}],"buyPrice":1803234,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":12,"equippable":true,"itemLevel":655,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":360646,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":false,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":9}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":90},{"statId":"62","delta":90},{"statId":"63","delta":90}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:40 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1873","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1665","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113645?id=113645&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2129, 115328, '', '', 'Grandiose Greataxe of the Decimator', 'a335ee', 'inv_axe_2h_draenorquest_b_01', 'Grandiose Greataxe of the Decimator<br /><br />Binds when picked up<br />Item Level 645<br />Two-Hand Axe<br />993 - 1491 Damage Speed 3.6<br />(344.9 dps)<br />+192 Strength<br />+288 Stamina<br />+512 Critical Strike<br />+256 Haste<br />+256 Versatility<br />+256 Mastery<br />Durability 120 / 120 <br />Requires Level 100<br />', 100, 645, '', '', 4, 'en_US', 1479323922, '{"id":115328,"disenchantingSkillRank":0,"description":"","name":"Grandiose Greataxe of the Decimator","icon":"inv_axe_2h_draenorquest_b_01","stackable":1,"itemBind":1,"bonusStats":[{"stat":40,"amount":256},{"stat":32,"amount":512},{"stat":49,"amount":256},{"stat":4,"amount":192},{"stat":36,"amount":256},{"stat":7,"amount":288}],"itemSpells":[],"buyPrice":3459437,"itemClass":2,"itemSubClass":1,"containerSlots":0,"weaponInfo":{"damage":{"min":993,"max":1491,"exactMin":993,"exactMax":1490},"weaponSpeed":3.6,"dps":344.8611},"inventoryType":17,"equippable":true,"itemLevel":645,"maxCount":0,"maxDurability":120,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":691887,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":128531,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[486,487,488,489,490],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[486,487,488,489,490],"chanceBonusLists":[39,38,37,36,35,34,33,32,31,30,19,29,28,27,26,21,25,24,23,22,20,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,61,62,63,64,65,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Fireflash","id":13150},"stats":[{"statId":"32","delta":97,"maxDelta":146},{"statId":"36","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Peerless","id":13151},"stats":[{"statId":"32","delta":97,"maxDelta":146},{"statId":"49","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Quickblade","id":13152},"stats":[{"statId":"32","delta":97,"maxDelta":146},{"statId":"40","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Feverflare","id":13156},"stats":[{"statId":"36","delta":97,"maxDelta":146},{"statId":"49","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Aurora","id":13157},"stats":[{"statId":"36","delta":97,"maxDelta":146},{"statId":"40","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Harmonious","id":13161},"stats":[{"statId":"40","delta":97,"maxDelta":146},{"statId":"49","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":11},{"statId":"7","delta":17},{"statId":"32","delta":29},{"statId":"36","delta":15},{"statId":"40","delta":15},{"statId":"49","delta":15}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":110},{"statId":"62","delta":110},{"statId":"63","delta":110},{"statId":"64","delta":110}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:41 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1875","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"3419","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/115328?id=115328&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2130, 124925, '', '', 'Wild Combatant\'s Chain Helm', '0070dd', 'inv_helm_mail_draenorhonors2_c_01', 'Wild Combatant\'s Chain Helm<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Head Mail<br />177 Armor<br />+242 Agility<br />+364 Stamina<br />+162 Critical Strike<br />+162 Mastery<br />Classes: Hunter <br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 85 / 85 <br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323926, '{"id":124925,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Chain Helm","icon":"inv_helm_mail_draenorhonors2_c_01","stackable":1,"allowableClasses":[3],"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":32,"amount":162},{"stat":49,"amount":162},{"stat":7,"amount":364},{"stat":3,"amount":242}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":1,"equippable":true,"itemLevel":670,"itemSet":{"id":1222,"name":"Gladiator\'s Pursuit","setBonuses":[{"description":"For 6 sec after using Arcane Shot, your PvP power is increased by 795.","threshold":2},{"description":"Increases PvP power by 500.","threshold":2},{"description":"Increases the regeneration of your Focus by 25%.","threshold":4},{"description":"Increases PvP Power by 1,000.","threshold":4}],"items":[127050,127073,127084,127095,127106]},"maxCount":0,"maxDurability":85,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":189160,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":177,"hasSockets":false,"isAuctionable":false,"armor":177,"displayInfoId":142242,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"3","delta":15},{"statId":"7","delta":21},{"statId":"32","delta":9},{"statId":"49","delta":9}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:44 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1877","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1879","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124925?id=124925&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2131, 124897, '', '', 'Wild Combatant\'s Necklace of Cruelty', '0070dd', 'inv_60pvp_neck2a', 'Wild Combatant\'s Necklace of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Neck Miscellaneous<br />+136 Agility<br />+204 Stamina<br />+97 Critical Strike<br />+84 Haste<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323926, '{"id":124897,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Necklace of Cruelty","icon":"inv_60pvp_neck2a","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":36,"amount":84},{"stat":32,"amount":97},{"stat":7,"amount":204},{"stat":3,"amount":136}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":2,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":113335,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"3","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:45 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1878","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1389","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124897?id=124897&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2132, 126092, '', '', 'Warmongering Combatant\'s Spaulders', '0070dd', 'inv_shoulder_mail_draenorhonors2_c_01', 'Warmongering Combatant\'s Spaulders<br />Warlords Season 3<br />Binds when picked up<br />Item Level 700<br />Shoulder Mail<br />186 Armor<br />+361 Stamina<br />+161 Critical Strike<br />+161 Haste<br />+241 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 85 / 85 <br />Requires Level 100<br />', 100, 700, '', '', 3, 'en_US', 1479323927, '{"id":126092,"disenchantingSkillRank":0,"description":"","name":"Warmongering Combatant\'s Spaulders","icon":"inv_shoulder_mail_draenorhonors2_c_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":241},{"stat":32,"amount":161},{"stat":36,"amount":161},{"stat":7,"amount":361}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":3,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":85,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":200638,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":186,"hasSockets":false,"isAuctionable":false,"armor":186,"displayInfoId":142260,"nameDescription":"Warlords Season 3","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"73","delta":14},{"statId":"7","delta":21},{"statId":"32","delta":9},{"statId":"36","delta":9}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:45 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-109.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1879","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1446","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/126092?id=126092&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2133, 124686, '', '', 'Wild Gladiator\'s Cape of Prowess', 'a335ee', 'inv_cape_draenorpvp_d_02_leather_blue', 'Wild Gladiator\'s Cape of Prowess<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Cloak Cloth<br />72 Armor<br />+180 Agility<br />+271 Stamina<br />+112 Haste<br />+129 Mastery<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323927, '{"id":124686,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Cape of Prowess","icon":"inv_cape_draenorpvp_d_02_leather_blue","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":49,"amount":129},{"stat":36,"amount":112},{"stat":3,"amount":180},{"stat":7,"amount":271}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":1,"containerSlots":0,"inventoryType":16,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":328888,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":72,"hasSockets":false,"isAuctionable":false,"armor":72,"displayInfoId":139399,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:46 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-115.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1880","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1025","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124686?id=124686&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}');
INSERT INTO `roster_api_items` (`id`, `item_id`, `context`, `bl`, `item_name`, `item_color`, `item_texture`, `item_tooltip`, `level`, `item_level`, `item_type`, `item_subtype`, `item_rarity`, `locale`, `timestamp`, `json`) VALUES
(2134, 124783, '', '', 'Wild Gladiator\'s Armor', 'a335ee', 'inv_chest_mail_raidshaman_p_01', 'Wild Gladiator\'s Armor<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Chest Mail<br />248 Armor<br />+481 Stamina<br />+214 Critical Strike<br />+214 Mastery<br />+321 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 165 / 165 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323928, '{"id":124783,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Armor","icon":"inv_chest_mail_raidshaman_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":321},{"stat":49,"amount":214},{"stat":32,"amount":214},{"stat":7,"amount":481}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":5,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":165,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":458440,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":248,"hasSockets":false,"isAuctionable":false,"armor":248,"displayInfoId":142328,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:46 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1881","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1012","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124783?id=124783&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2135, 124781, '', '', 'Wild Gladiator\'s Armbands of Cruelty', 'a335ee', 'inv_bracer_mail_raidhunter_p_01', 'Wild Gladiator\'s Armbands of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Wrist Mail<br />108 Armor<br />+271 Stamina<br />+112 Critical Strike<br />+129 Mastery<br />+180 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323928, '{"id":124781,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Armbands of Cruelty","icon":"inv_bracer_mail_raidhunter_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":180},{"stat":32,"amount":112},{"stat":49,"amount":129},{"stat":7,"amount":271}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":9,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":228835,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":108,"hasSockets":false,"isAuctionable":false,"armor":108,"displayInfoId":141770,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:47 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-118.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1883","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1026","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124781?id=124781&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2136, 124784, '', '', 'Wild Gladiator\'s Gauntlets', 'a335ee', 'inv_glove_mail_raidhunter_p_01', 'Wild Gladiator\'s Gauntlets<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Hands Mail<br />155 Armor<br />+361 Stamina<br />+161 Critical Strike<br />+161 Mastery<br />+241 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323929, '{"id":124784,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Gauntlets","icon":"inv_glove_mail_raidhunter_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":241},{"stat":32,"amount":161},{"stat":49,"amount":161},{"stat":7,"amount":361}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":10,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":231388,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":155,"hasSockets":false,"isAuctionable":false,"armor":155,"displayInfoId":141751,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:47 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1884","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1016","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124784?id=124784&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2137, 124774, '', '', 'Wild Gladiator\'s Waistguard of Cruelty', 'a335ee', 'inv_belt_mail_raidhunter_p_01', 'Wild Gladiator\'s Waistguard of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Waist Mail<br />139 Armor<br />+361 Stamina<br />+172 Haste<br />+149 Mastery<br />+241 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323929, '{"id":124774,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Waistguard of Cruelty","icon":"inv_belt_mail_raidhunter_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":241},{"stat":49,"amount":149},{"stat":36,"amount":172},{"stat":7,"amount":361}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":6,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":222868,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":139,"hasSockets":false,"isAuctionable":false,"armor":139,"displayInfoId":141773,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:48 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1885","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1026","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124774?id=124774&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2138, 124926, '', '', 'Wild Combatant\'s Chain Leggings', '0070dd', 'inv_pant_mail_draenorhonors2_c_01', 'Wild Combatant\'s Chain Leggings<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Legs Mail<br />191 Armor<br />+242 Agility<br />+364 Stamina<br />+162 Haste<br />+162 Mastery<br />Classes: Hunter <br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 100 / 100 <br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323930, '{"id":124926,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Chain Leggings","icon":"inv_pant_mail_draenorhonors2_c_01","stackable":1,"allowableClasses":[3],"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":49,"amount":162},{"stat":36,"amount":162},{"stat":7,"amount":364},{"stat":3,"amount":242}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":7,"equippable":true,"itemLevel":670,"itemSet":{"id":1222,"name":"Gladiator\'s Pursuit","setBonuses":[{"description":"For 6 sec after using Arcane Shot, your PvP power is increased by 795.","threshold":2},{"description":"Increases PvP power by 500.","threshold":2},{"description":"Increases the regeneration of your Focus by 25%.","threshold":4},{"description":"Increases PvP Power by 1,000.","threshold":4}],"items":[127050,127073,127084,127095,127106]},"maxCount":0,"maxDurability":100,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":253650,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":191,"hasSockets":false,"isAuctionable":false,"armor":191,"displayInfoId":142244,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"3","delta":15},{"statId":"7","delta":21},{"statId":"36","delta":9},{"statId":"49","delta":9}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:48 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-127.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1886","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1884","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124926?id=124926&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2139, 124971, '', '', 'Wild Combatant\'s Footguards of Prowess', '0070dd', 'inv_boot_mail_draenorhonors2_c_01', 'Wild Combatant\'s Footguards of Prowess<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Feet Mail<br />150 Armor<br />+273 Stamina<br />+112 Critical Strike<br />+130 Haste<br />+182 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 65 / 65 <br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323930, '{"id":124971,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Footguards of Prowess","icon":"inv_boot_mail_draenorhonors2_c_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":182},{"stat":36,"amount":130},{"stat":32,"amount":112},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":8,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":65,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":184062,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":150,"hasSockets":false,"isAuctionable":false,"armor":150,"displayInfoId":142239,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":4},{"statId":"73","delta":10},{"statId":"7","delta":16},{"statId":"32","delta":7},{"statId":"36","delta":8}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:48 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1887","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1452","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124971?id=124971&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2140, 124899, '', '', 'Wild Combatant\'s Ring of Cruelty', '0070dd', 'inv_60pvp_ring4b', 'Wild Combatant\'s Ring of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Finger Miscellaneous<br />+136 Agility<br />+204 Stamina<br />+97 Critical Strike<br />+84 Mastery<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323930, '{"id":124899,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Ring of Cruelty","icon":"inv_60pvp_ring4b","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":49,"amount":84},{"stat":32,"amount":97},{"stat":7,"amount":204},{"stat":3,"amount":136}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":167459,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"3","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"49","delta":5}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:49 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-120.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1888","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1386","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124899?id=124899&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}');
so this table is supposed to have indexes but they dont export? odd...
item_id context bl and locale are supposed to be the factors if the item exists or not.item_id and locale are required but bl and context can be blank
so i have the an item in the database and i query it say 124899, enUS so i have one of these in there but what if i had 2,
and a bl was set of 517 and a context of 88
so i query to see if the basic item is there item_id = 124899 locale = enUS it returns 2 matches not the basic item
also with inserting the items say i have the modified item in the database but i want to add the basic it queries to see if item_id = 124899 locale = enUS exists and gets a yes when it should get a no..
no any ideas?