--For the initial screen, that shows orders, that were placed during the current week,
--this query should be used:

SELECT
    Vendor.DisplayName,
    MasterList.ItemNumber,
    MasterList.Description,
    OrderList.OrderQty
FROM MasterList
        JOIN Vendor ON (MasterList.VendorId = Vendor.Id)
        JOIN OrderList ON (
            MasterList.VendorId = OrderList.VendorId AND
            MasterList.ItemNumber = OrderList.ItemNumber AND
            MasterList.Description = OrderList.Description AND
            OrderList.CreatedOn > dbo.weekStart() AND
             OrderList.StoreId = ${action.storeId}
        )
WHERE OrderList.StoreId = ${action.storeId}



--for the CombinedOrderList screen should be used another query.
--The unfiltered (and limited) one:

SELECT TOP 100
    ml.Id AS MLID,
    v.DisplayName , ml.ItemNumber , ml.Description, jo.lastWeekQuantity, jo.thisWeekQuantity, ml.ItemInventoryCount,
    ml.vendorId, jo.StoreId, jo.OrderId
FROM MasterList ml INNER JOIN Vendor v ON ml.VendorId = v.Id
                        LEFT JOIN JoinedOrders jo ON
                            ml.VendorId = jo.VendorId AND
                            ml.ItemNumber = jo.ItemNumber AND
                            ml.Description = jo.Description AND
                            jo.StoreId = ${action.storeId}
WHERE ml.Id > 0
ORDER BY ml.Id
--(initially ML.Id > 0, after next scrolling ML.Id > 100 …)



-- CombinedOrderList screen with example of applied filters:

SELECT TOP 100
    ml.Id AS MLID,
    v.DisplayName , ml.ItemNumber , ml.Description, jo.lastWeekQuantity, jo.thisWeekQuantity, ml.ItemInventoryCount,
    ml.vendorId, jo.StoreId, jo.OrderId
FROM MasterList ml INNER JOIN Vendor v ON ml.VendorId = v.Id
                        LEFT JOIN JoinedOrders jo ON
                            ml.VendorId = jo.VendorId AND
                            ml.ItemNumber = jo.ItemNumber AND
                            ml.Description = jo.Description AND
                            jo.StoreId = ${action.storeId}
WHERE ml.Id > 0
    AND V.DisplayName LIKE '%PD%'
    AND ML.ItemNumber LIKE '%1024%'
    AND ML.Description LIKE '%Glory%'

ORDER BY ml.Id
--(initially ML.Id > 0, after next scrolling ML.Id > 100 …)