manufacture period query