optima, optima2www

SELECT DfC_DfCId as ID, DfC_Nazwa as Nazwa, DfC_Typ from CDN.DefCeny ORDER BY DfC_DfCID


select Twr_Kod, DeA_Kod, Twr_Nazwa,TwC_Wartosc, Twr_URL, Twr_Opis, Twr_Stawka from CDN.Towary
    JOIN CDN.TwrAtrybuty ON TwA_TwrId = Twr_TwrId JOIN CDN.DefAtrybuty
    ON TwA_DeAId = DeA_DeAId JOIN CDN.TwrCeny ON TwC_TwrID = Twr_TwrId JOIN [CDN].[TwrIlosci] [A] ON Twr_TwrId = TwI_TwrId
    WHERE DeA_Kod  like '#%'

-- trzeba podmienić :ID_CENY na ID właściwej ceny z pierwszego zapytania
    AND TwC_TwcNumer = :ID_CENY

    AND TWI_Magid is null AND TwI_Ilosc > 0
    AND [TwI_Data]= (
    SELECT TOP 1 [B].[TwI_Data]
    FROM [CDN].[TwrIlosci] [B]
    WHERE [B].[TwI_TwrId] = [A].[TwI_TwrId]
    AND [B].[TwI_MagId] IS NULL
    AND [B].[TwI_Data] <= getdate() -- '2014-01-01'
    ORDER BY [B].[TwI_Data] DESC ) ORDER BY Twr_Kod