Try ```val q = Medicine.slice(Medicine.id, disti...

# exposed

[tapac]

Try

val q = Medicine.slice(Medicine.id, distinctName, Medicine.company).select {
                Medicine.name like "$key%" and Medicine.deletedAt.isNull()
            }.orderBy(Medicine.id).limit(if (perPage > 25) 25 else perPage, if (page > 1) page - 1 else 0)
printLn(q.prepareSQL(QueryBuilder(false))) 
q.map {
                Summary(it[Medicine.id], it[distinctName], it[Medicine.company])
            }