Allow memory size exhausted problem!

Im positive on the query string I wrote since it is just joined query of many tables and it is proven to work with result without a flaw for 3 three years. I am further investigating, perhaps some pre-actions that cause memory exhausted just before it calls the
query