"community2collection.collection_id=collection.collection_id AND " + "community2collection.community_id=" + getID() + ";");
"community2collection.collection_id=collection.collection_id " + "AND community2collection.community_id=" + getID() + ";");
    public Collection[] getCollections()        throws SQLException    {        List collections = new ArrayList();        // Get the table rows        TableRowIterator tri = DatabaseManager.query(ourContext,            "collection",            "SELECT collection.* FROM collection, community2collection WHERE " +                "community2collection.collection_id=collection.collection_id AND " +                "community2collection.community_id=" + getID() + ";");        // Make Collection objects        while (tri.hasNext())        {            collections.add(new Collection(ourContext, tri.next()));        }        // Put them in an array        Collection[] collectionArray = new Collection[collections.size()];        collectionArray = (Collection[]) collections.toArray(collectionArray);                return collectionArray;    }