query distinct properties

[kay_be_]

I'm using lucene-indexing on a alfresco 3.4d. I want a list of unique companies (property from cmerson).
Is there a way to do distinct queries when I don't use SOLR?
When there is not, what are the alternatives? Will I have to use an algorithm to sort the result from a non distinct query? I think that would take a lot of time when there are a lot of users. Is there a way to do MySQL queries in JS?
Regards

[jpotts]

I think you're going to have to do this in either JavaScript or Java.

Jeff

[kay_be_]

I created a javascript querying for all persons using a lucene search, checking if the company is in an array of companies and pushing the companyname if not. Not very efficiënt though.