refined queries for drug stock reports