EVE Technology Lab

Would someone be able to explain a descrepency I'm seeing between my understanding of the dbo.crpNPCCorporationTrades table from the SQL static dump, and in-game reality? Any info sources would be most appreciated if easily available so I might learn more than just the quick-answer.

According to the info I found at Eve-Development (http://wiki.eve-id.net/CrpNPCCorporationTrades_%28CCP_DB%29), this table should just be a list of what NPC corps trade in what goods, without specifying if they are buyers or sellers or any other info. However, the very first test query I ran on it turned up an entry that I'm not actually seeing in game.

There are fourteen records for Nanite Repair Paste (typeID 28668) including one for Republic Fleet (corporationID 1000051). The full list of NPC Corps matches the list on Chruker's site for this item (http://games.chruker.dk/eve_online/item.php?type_id=28668). However, a quick check of the Heimatar regional market, which includes several Republic Fleet stations, shows no NPC buy or sell orders; all order expiration times are less than 90 days out.

While I wasn't really expecting to see a player-producable good that was also NPC seeded or purchased, this means I've either just found a errant entry (unlikely) or I have no idea what I'm doing (always a safe bet) and could use a better explanation. Web and forums searches turned up nothing. What I'm hoping is that someone could explain what I'm not understanding about this table, or failing that, suggest an alternate and reliable way of filtering for NPC-seeded or purchased goods?

Static Data Dump Version Incarna_1.1.45834_db (2011-08-29)

~ JD