i really can't understand the problem here. I added the above sql still seems to be a problem. this time products_results.php was running fine then it crashed again
well i have attached dw report as well as products_results page. I previewed products_results page i got this error on page: Unknown column 'ProductCategoryID' in 'field list'