SQL query for orders retrieval - LSSC Editor screenshot
General adapter meta-data - LSSC Editor screenshot
Failing SQL query - LSSC Editor screenshot