Link on top 'most comments' possible ??

[danyball]

Hi!
Is there any way to create a link to see the pictures with the most comments?! like 'newest comments' ....

thanks!!!!
daniel

[danyball]

The SQL-Query i want is:

Code Select Expand

SELECT pid, count(*) as summe FROM `cpg148_comments` group by pid order by summe desc

i only need help in which file i have to copy it. i want a thumbnail-site with these pictures....

thanks!

[Joachim Müller]

You need to create a new set of meta-albums. Take a look at index.php and include/functions.inc.php: search for the case selectors there and come up with a new case for your meta album.