Forum Discussion

shayl's avatar
4 years ago

Select messages containing video by LiQL query

How to select messages containing video by LiQL query?

  • The answer has been found:

    SELECT id, view_href, subject, videos, videos.count(*) FROM messages WHERE videos.count(*) > 0

1 Reply

  • The answer has been found:

    SELECT id, view_href, subject, videos, videos.count(*) FROM messages WHERE videos.count(*) > 0