Emaze Auction: Edit Category SELECT categoryID, categoryLotCount, categoryViewCount, categoryName, categoryName1, categoryName2, categoryName3, categoryName4, categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID > 0 ORDER BY categoryName1, categoryName2, categoryName3, categoryName4 SELECT Sum(lotViewCount) AS SumLotViewCount, Category.categoryID FROM Lot INNER JOIN Category ON Lot.categoryID = Category.categoryID GROUP BY Category.categoryID
Edit Lots Lots Classified Procure Lot Summary Winning Bids Delete
ID Cat.
Views
Lot
Views
Count Category Name (1 | 2 | 3 | 4)
#getCategories.categoryID# #categoryViewCount# #Int(ListGetAt(ValueList(getLotCounts.SumLotViewCount),catID))# 0 #categoryLotCount# #getCategories.categoryName1# #subCategorySeparator##getCategories.categoryName2# #subCategorySeparator##getCategories.categoryName3# #subCategorySeparator##getCategories.categoryName4#

Here is a quick description of the above headings:
Delete: Delete category. Must have no lots.
View: Number of page views of category homepage. |
Total page views of lot pages in category.
Edit: Click to edit category options.
Lots: Lists all lots in category with various options.
Summ: Summary of lot statuses.
Win: List of winning bidders for all lots in category.
Count: Number of lots in category.