Hey there,

You can try to run the following SQL query to check it out:

For cluster(group, event, page)

SELECT COUNT(1) FROM `jos_social_photos` WHERE `type` != 'user';

For a user --> replace 477 to the user id that you want

SELECT COUNT(1) FROM `jos_social_photos` WHERE `user_id` = 477;

Take note that you need to replace 'jos' with your table prefix before you run it.

Hello.

For cluster(group, event, page)

SELECT COUNT(1) FROM `jos_social_photos` WHERE `type` != 'user';

This one display 27977 photos. In group, event, page?

For a user --> replace 477 to the user id that you want

SELECT COUNT(1) FROM `jos_social_photos` WHERE `user_id` = 477;

But how to see all users photos (not one)?
Thanks.

I want to display on site homepage statistic that "There is 90 000+ photos total on site". Thanks.

Hey there,

This one display 27977 photos. In group, event, page?

It includes all group, event and page.

But how to see all users photos (not one)?

You can try to run the following SQL query to check it out:

SELECT COUNT(1) FROM `jos_social_photos` WHERE `type` = 'user';