Daniel Posted March 5 Share Posted March 5 Somebody on invisioncommunity.com asked about a way how to find the topics with most attachments. Here's a query to get the top topics: select id1 as topic_id ,count(*) as total FROM core_attachments_map where location_key = 'forums_Forums' group by id1 order by total desc Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.