Hi Eric,

Kindly find my response for your inquiries below:

Can you tell me in which table are the "I like" a page?

-> Seems like this inquiry you've already submit in this ticket https://stackideas.com/forums/tables-groups-pages
Perhaps, you can try it as my colleague suggest there

And also the notifications of the pages?

-> For notification of the page you can find it in the table '#_social_notifications' with type ='pages' and 'context_ids' =(id of the page)

Hope this helps.

Hello,
thank You very much.
Excuse me, I did not express myself correctly, actually what my colleague suggested me works to count the number of 'I like'.
What I want now is to display the list of people who like the page. (I thought these people were identified in the "social_clusters_nodes" table, but this is obviously not the case)
Best regards.
Eric

I see, perhaps you can try these sql where you can change the cluster id value and the # to your database prefix
This will be print out the user that like the page excluded the admin

SELECT `a`.* FROM `#_social_clusters_nodes` AS `a` LEFT JOIN `#_social_block_users` AS `bus` ON `a`.`uid` = `bus`.`user_id` AND `bus`.`target_id` = '448' LEFT JOIN `#_users` AS `u` ON `a`.`uid` = `u`.`id` INNER JOIN `#_social_profiles_maps` AS `upm` ON `u`.`id` = `upm`.`user_id` INNER JOIN `#_social_profiles` AS `up` ON `upm`.`profile_id` = `up`.`id` AND `up`.`community_access` = '1' WHERE `bus`.`id` IS NULL AND `a`.`cluster_id` = '75' AND `u`.`block` = '0' AND `a`.`state` = '1' AND `admin`='0'

Hello,
Thank you very much for your help, but I look at what you suggest but do not understand the reasoning.
The table "social_block_users" contains exactly what?
I observe it but do not understand.


My need is to display the avatars of the members that we see for example here:
"/index.php/en/community/pages/id of the cluster - page alias / xx-followers"


Best regards.
Eric

Hi Eric,

Thank you very much for your help, but I look at what you suggest but do not understand the reasoning.
The table "social_block_users" contains exactly what?
I observe it but do not understand.

->The social_block_users actually table for user that has been blocked.

My need is to display the avatars of the members that we see for example here:
"/http://index.php/en/community/pages/id of the cluster - page alias / xx-followers"

-> This can be called as you parse the pageID and $options in the function getMembers (../administrator/components/com_easysocial/models/pages.php)
perhaps you can make as shown in the file:
.../media/com_easysocial/apps/page/followers/controllers/pages.php function filterFollowers
and render it as in the file:
.../media/com_easysocial/apps/page/followers/themes/default/pages/list.php line 21

Thak You very much

You are most welcome Eric

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry.

Have a nice day ahead