{"STATUS":"OK","TIPO":"GET","MESSAGGIO":"Ordini recuperati: 30","QUERY":"SELECT o.*, cu.CustomerName, em.FirstName, em.LastName, sh.ShipperName \r\n          FROM Orders o\r\n          LEFT JOIN Customers cu ON o.CustomerID = cu.CustomerID\r\n          LEFT JOIN Employees em ON o.EmployeeID = em.EmployeeID\r\n          LEFT JOIN Shippers sh ON o.ShipperID = sh.ShipperID\r\n          WHERE 1=1 ORDER BY o.OrderDate DESC","DATI":[{"OrderID":"10277","CustomerID":"52","EmployeeID":"2","OrderDate":"1996-08-09","ShipperID":"3","CustomerName":null,"FirstName":"Andrew","LastName":"Fuller","ShipperName":"Federal Shipping"},{"OrderID":"10276","CustomerID":"80","EmployeeID":"8","OrderDate":"1996-08-08","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10275","CustomerID":"49","EmployeeID":"1","OrderDate":"1996-08-07","ShipperID":"1","CustomerName":null,"FirstName":"Nancy","LastName":"Davolio","ShipperName":"Speedy Express"},{"OrderID":"10274","CustomerID":"85","EmployeeID":"6","OrderDate":"1996-08-06","ShipperID":"1","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Speedy Express"},{"OrderID":"10273","CustomerID":"63","EmployeeID":"3","OrderDate":"1996-08-05","ShipperID":"3","CustomerName":null,"FirstName":"Janet","LastName":"Leverling","ShipperName":"Federal Shipping"},{"OrderID":"10272","CustomerID":"65","EmployeeID":"6","OrderDate":"1996-08-02","ShipperID":"2","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"United Package"},{"OrderID":"10271","CustomerID":"75","EmployeeID":"6","OrderDate":"1996-08-01","ShipperID":"2","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"United Package"},{"OrderID":"10270","CustomerID":"87","EmployeeID":"1","OrderDate":"1996-08-01","ShipperID":"1","CustomerName":null,"FirstName":"Nancy","LastName":"Davolio","ShipperName":"Speedy Express"},{"OrderID":"10269","CustomerID":"89","EmployeeID":"5","OrderDate":"1996-07-31","ShipperID":"1","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Speedy Express"},{"OrderID":"10268","CustomerID":"33","EmployeeID":"8","OrderDate":"1996-07-30","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10267","CustomerID":"25","EmployeeID":"4","OrderDate":"1996-07-29","ShipperID":"1","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Speedy Express"},{"OrderID":"10266","CustomerID":"87","EmployeeID":"3","OrderDate":"1996-07-26","ShipperID":"3","CustomerName":null,"FirstName":"Janet","LastName":"Leverling","ShipperName":"Federal Shipping"},{"OrderID":"10265","CustomerID":"72","EmployeeID":"2","OrderDate":"1996-07-25","ShipperID":"1","CustomerName":null,"FirstName":"Andrew","LastName":"Fuller","ShipperName":"Speedy Express"},{"OrderID":"10264","CustomerID":"24","EmployeeID":"6","OrderDate":"1996-07-24","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10263","CustomerID":"20","EmployeeID":"9","OrderDate":"1996-07-23","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10262","CustomerID":"65","EmployeeID":"8","OrderDate":"1996-07-22","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10261","CustomerID":"61","EmployeeID":"4","OrderDate":"1996-07-19","ShipperID":"2","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"United Package"},{"OrderID":"10260","CustomerID":"55","EmployeeID":"4","OrderDate":"1996-07-19","ShipperID":"1","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Speedy Express"},{"OrderID":"10259","CustomerID":"13","EmployeeID":"4","OrderDate":"1996-07-18","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10258","CustomerID":"20","EmployeeID":"1","OrderDate":"1996-07-17","ShipperID":"1","CustomerName":null,"FirstName":"Nancy","LastName":"Davolio","ShipperName":"Speedy Express"},{"OrderID":"10257","CustomerID":"35","EmployeeID":"4","OrderDate":"1996-07-16","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10256","CustomerID":"88","EmployeeID":"3","OrderDate":"1996-07-15","ShipperID":"2","CustomerName":null,"FirstName":"Janet","LastName":"Leverling","ShipperName":"United Package"},{"OrderID":"10255","CustomerID":"68","EmployeeID":"9","OrderDate":"1996-07-12","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"},{"OrderID":"10254","CustomerID":"14","EmployeeID":"5","OrderDate":"1996-07-11","ShipperID":"2","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"United Package"},{"OrderID":"10253","CustomerID":"34","EmployeeID":"3","OrderDate":"1996-07-10","ShipperID":"2","CustomerName":null,"FirstName":"Janet","LastName":"Leverling","ShipperName":"United Package"},{"OrderID":"10252","CustomerID":"76","EmployeeID":"4","OrderDate":"1996-07-09","ShipperID":"2","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"United Package"},{"OrderID":"10251","CustomerID":"84","EmployeeID":"3","OrderDate":"1996-07-08","ShipperID":"1","CustomerName":null,"FirstName":"Janet","LastName":"Leverling","ShipperName":"Speedy Express"},{"OrderID":"10250","CustomerID":"34","EmployeeID":"4","OrderDate":"1996-07-08","ShipperID":"2","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"United Package"},{"OrderID":"10249","CustomerID":"81","EmployeeID":"6","OrderDate":"1996-07-05","ShipperID":"1","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Speedy Express"},{"OrderID":"10248","CustomerID":"90","EmployeeID":"5","OrderDate":"1996-07-04","ShipperID":"3","CustomerName":null,"FirstName":null,"LastName":null,"ShipperName":"Federal Shipping"}]}