bug 893: replaced some * by 1 in select statments