SELECT
    Planning.pId,
    Shop.sId,
    PlanningShopTask.KmReq,
    PlanningShopTask.EndShopTimeReq,
    Task.tId,
    Planning.pStartdate,
    Planning.pEnddate,
    Planning.ptId,
    PlanningShopTask.Note,
    Planning.pdelete
FROM  dbo.PlanningShopTask
    INNER JOIN dbo.Shop ON PlanningShopTask.sId = Shop.sId
    INNER JOIN dbo.Task ON PlanningShopTask.tId = Task.tId
    INNER JOIN dbo.Planning ON PlanningShopTask.pId = Planning.pId
WHERE
    (Planning.uId = @uid) AND
    (Planning.pReceived = 0) AND
    (PlanningShopTask.taskfinished = 0)
ORDER BY
    Planning.pdelete DESC,
    Planning.pId ASC,
    Planning.pStartdate ASC,
    Shop.sId ASC