queries working on half an hour basis