---

SELECT TOP 20 *
FROM [X-SKUD].dbo.pLogData pld
LEFT JOIN [X-SKUD].dbo.pList pl ON pl.ID = pld.HozOrgan
WHERE pl.ID IS NOT NULL
ORDER BY pld.TimeVal DESC;