Unsupported nested scalar subselects

Getting error: MemSQL does not support this type of query: unsupported nested scalar subselects, while executing below query.

delete from XYZ where processing_dt = ((select distinct processing_dt from XYZ where processing_dt < (select processing_dt from ABC) order by processing_dt DESC LIMIT 2,1));

How to proceed on this.

We will be adding support for this in the next release