Revert "one liner query"

This reverts commit 2ccd939baf66ac10786423d03abe8dfc68cfa8c0.
Revert "Revert "Revert "Implement recent_sold"""

This reverts commit 64768a82ee1a3c05bd7a35157ca48ea4ff499972.