revised queries, product with isactive column, itempage for closed sales