Query items with the highest watch counts for the entire site or for a specific category. The top items are determined by the Watch Count totals from the preceding day. Ranking of the Most Watched Items is calculated with the latest Watch Count information.
Table Specific Information
The only columns that can be used to filter are CategoryId, AffiliateCustomId, AffiliateNetworkId, and AffiliateTrackingId. These filters are optional.
SELECT * FROM MostWatchedItems
SELECT * FROM MostWatchedItems WHERE CategoryId = '277'
|ItemId [KEY]||String||The Id that uniquely identifies the item listing. The Id is generated by eBay after an item is listed.|
|Title||String||Name of the item as it appears in the listing or search results.|
|Subtitle||String||Subtitle of the item. Only returned if the seller included a subtitle for the listing.|
|WatchCount||Integer||The number of watches placed on this item from the My eBay accounts of the buyers.|
|BidCount||Integer||The number of bids that have been placed on the item.|
|BuyItNowPrice||Decimal||The Buy It Now Price of the item (if any), in the currency of the site on which the item was listed.|
|Currency||String||The 3-digit ISO 4217 currency codes for the currency used by the site.|
|OriginalRetailPrice||Decimal||The actual retail price set by the manufacturer (OEM).|
|PricingTreatment||String||Using OriginalRetailPrice, MinimumAdvertisedPrice, and StartPrice values, eBay identifies whether the listing falls under MAP or STP (aka OriginalRetailPrice).|
|SoldOffEbay||Boolean||Used by the eBay UK and eBay Germany (DE) sites, this flag indicates that the discount price (specified as StartPrice) is the price for which the seller offered the same (or similar) item for sale on a Web site or offline store other than eBay in the previous 30 days. The discount price is always in reference to the price for the item set by the seller.|
|SoldOnEbay||Boolean||Used by the eBay UK and eBay Germany (DE) sites, this flag indicates that the discount price (specified as StartPrice) is the price for which the seller offered the same (or similar) item for sale on eBay in the previous 30 days. The discount price is always in reference to the price for the item set by the seller.|
|GlobalId||String||The site upon which the item is listed. Returns a Global Id, which is a unique identifier for combinations of site, language, and territory.|
|ImageURL||String||URL for a picture used as the Gallery thumbnail, if any. The image uses one of the following graphics formats: JPEG, BMP, TIF, or GIF. Only returned if the seller chose to show a gallery image.|
|OriginalPrice||Decimal||Original price of an item whose price a seller has reduced with the Promotional Price Display feature. Only returned if the price has been revised.|
|PrimaryCategoryId||String||Numeric Id of the first (or only) category in which the item is listed. (Listings can appear in more than one category.)|
|PrimaryCategoryName||String||Display name of the first (or only) category in which the item is listed. This is a fully qualified category breadcrumb (e.g., Computers & Networking:Laptops, Notebooks).|
|ShippingCost||Decimal||The shipping cost associated with the first shipping service. Only returned when ShippingType is flat.|
|ShippingType||String||The shipping cost model offered by the seller.|
|TimeLeft||String||Time left before the item listing ends. The duration is represented in the ISO 8601 duration format (PnDTnHnMnS). For ended listings, the time left is P0DT0H0M0S (zero days, zero hours, zero minutes, and zero seconds).|
|ViewItemURL||String||The URL of the Web page where a user can view the listing. On the U.S. site, this is called the View Item page. If you enabled affiliate tracking in the call, ViewItemURL contains a string that includes affiliate tracking information (see the eBay Partner Network).|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|CategoryId||String||Specifies the category from which to retrieve item listings.|
|AffiliateCustomId||String||Need not be specified. You can define an AffiliateCustomId to better monitor your marketing efforts. If you are using the eBay Partner Network, and you provide an AffiliateCustomId, the tracking URL returned by the eBay Partner Network will contain the AffiliateUserId.|
|AffiliateNetworkId||String||Specifies your tracking partner for affiliate commissions.|
|AffiliateTrackingId||String||The value you specify is obtained from your tracking partner.|