Group by Query help from multiple tables

Hello php_rocs,

Thank you for reply.

The tables are connected by these columns:

products (id) -> images (product_id)

products (user_id) -> users (id)

users (id) -> followers (following_id)



Edit:
uploaded test data "sql" file .. I can not see the uploaded file. So sharing link from googledrive.

https://drive.google.com/open?id=1tuctBn...pdViMWcLPm