FIND PUBLICATION LIST ID USING SQL

/* FIND THE PUBLICATION LIST DETAILS LIKE NAME, ID USING SQL
CXXXXX – NEED TO RESPECTIVE MID : EX:- C101010
WE HAVE TO EXECUTE IN CENTRO*/

SELECT
LISTNAME,
LISTID
FROM CXXXXXX.[_LISTSUBSCRIBERS]
WHERE LISTTYPE = ‘PUBLICATION LIST’
GROUP BY LISTNAME, LISTID