In case the message "HTTP ERROR 500 - Internal server error" occurs, it is possible that the query is producing an MTOM file exceeding the size limit of 750 Mb. In such case it is recommended to refine the query.