Before diving into techniques, it is critical to understand that searching for entertainment content is fundamentally different from searching for factual information.

async getCategoriesByType(type = 'entertainment') const sql = ` SELECT c.*, COUNT(ci.id) as content_count FROM categories c LEFT JOIN content_items ci ON ci.category_id = c.id WHERE c.type = ? GROUP BY c.id ORDER BY c.name `;