SQL query on Content table

In our WEM, we have a content instances of a particular CTD, associated to site channels, and some which are not associated to any channel.
I would like to find  by SQL query on the Content table, Content items which are associated to a particular channel or any channel.
Is there a way to do it by SQL query?

Comments