Ciao, if you consider an SQL query simple, here a possible solution:

SELECT
cv.name,
cvur.is_owner,
c.contact_name,
c.contact_email
FROM custom_views AS cv 
INNER JOIN custom_view_user_relation AS cvur ON cv.custom_view_id = cvur.custom_view_id
INNER JOIN contact AS c ON cvur.user_id = c.contact_id
WHERE cv.public = 1
;

And this is is the output on my test machine:

$ cat /tmp/public_custom_view.sql | mysql -u centreon -p centreon
Enter password:
name    is_owner        contact_name    contact_email
test public     1       Administrator_Centreon  root@localhost
test public     0       User    user@localhost

Thanks a lot Dalfo.

This is useful.