Hello/Hi/Greetings,

With:

select `image_id`, count(*)  FROM `history` where `date`="today" and ( `image_type`="picture" or `image_type`="high") group by `image_id` order by count( *) desc limit 1

There is a plugin with which to publish this photo automatically on facebook / twitter


Piwigo version: 2.8.6
PHP version:
MySQL version:
Piwigo URL: http://coyacios.es/piwigo