In various example embodiments, systems and methods for providing category aspect information by mining historical data is provided. In example embodiments, a table comprising joined data is accessed. The table includes historical data that comprises user behavior data based on actions performed with past queries by users, data describing publication, and a determined category for each publication. Demand scores based on the joined data are determined. The determined demand scores are used to determine most relevant aspect name and aspect value pairs for a category. Publications having at least one of the most relevant aspect name and aspect value pairs are displayed visually distinguished from less relevant publications that exclude the most relevant aspect name and aspect value pairs.