return transaction {
      PostDAO.wrapRows(
        Posts
          .innerJoin(PostsTags, {Posts.id}, {<http://PostsTags.post|PostsTags.post>})
          .innerJoin(Tags, {Tags.id}, {PostsTags.tag})
          .selectAll()
          .andWhere {
            Posts.title like "%$query%" or (Tags.name inList tags)
          }
          .withDistinct()
      ).map {
        it.toModel()
      }
      .distinct()
      .toList()
    }

select {}

selectAll().andWhere{}

select

where