this command works, and gives expected result, only problem is its performance, since there are multiple warehouses(companies) command has to job for all, so it takes a lot of time. I am looking to improve sql queries, and maybe avoid use looping companies somehow.