SELECT * FROM (SELECT UpcomingProjects.Name, Watchlist.User_ID, Watchlist.Project_ID, UsersWatchlist.Project_ID as InUsersWatchlist, UpcomingProjects.ID as ProjectID
          FROM proveq.Projects UpcomingProjects
          LEFT JOIN proveq.Watchlist UsersWatchlist ON UpcomingProjects.ID = UsersWatchlist.Project_ID AND UsersWatchlist.User_ID = '289' AND UsersWatchlist.Status='1'
            INNER JOIN proveq.Watchlist Watchlist ON ProjectID.ID=Watchlist.Project_ID AND Watchlist.User_ID  IN (220,289,179, 505)  AND Watchlist.Status='1'
          WHERE UpcomingProjects.Sale_Status='Upcoming'
          GROUP BY UpcomingProjects.Name
          ORDER BY str_to_date(UpcomingProjects.Start_Date,'%m/%d/%Y') ASC) as upcoming
          UNION all
          SELECT * FROM (SELECT ActiveProjects.Name, Watchlist.User_ID, Watchlist.Project_ID, UsersWatchlist.Project_ID as InUsersWatchlist, ActiveProjects.ID as ProjectID
          FROM proveq.Projects ActiveProjects
          LEFT JOIN proveq.Watchlist UsersWatchlist ON ActiveProjects.ID = UsersWatchlist.Project_ID AND UsersWatchlist.User_ID = '289' AND UsersWatchlist.Status='1'
            INNER JOIN proveq.Watchlist Watchlist ON ProjectID.ID=Watchlist.Project_ID AND Watchlist.User_ID  IN (220,289,179, 505)  AND Watchlist.Status='1'
          WHERE ActiveProjects.Sale_Status='Active'
          GROUP BY ActiveProjects.Name
          ORDER BY str_to_date(ActiveProjects.End_Date,'%m/%d/%Y') ASC) as active
          UNION all
          SELECT * FROM (SELECT ConcludedProjects.Name,Watchlist.User_ID, Watchlist.Project_ID, UsersWatchlist.Project_ID as InUsersWatchlist, ConcludedProjects.ID as ProjectID
          FROM proveq.Projects ConcludedProjects
          LEFT JOIN proveq.Watchlist UsersWatchlist ON ConcludedProjects.ID = UsersWatchlist.Project_ID AND UsersWatchlist.User_ID = '289' AND UsersWatchlist.Status='1'
            INNER JOIN proveq.Watchlist Watchlist ON ProjectID.ID=Watchlist.Project_ID AND Watchlist.User_ID  IN (220,289,179, 505)  AND Watchlist.Status='1'
          WHERE ConcludedProjects.Sale_Status='Concluded'
          GROUP BY ConcludedProjects.Name
          ORDER BY str_to_date(ConcludedProjects.End_Date,'%m/%d/%Y') ASC) as active
          UNION all
          SELECT * FROM (SELECT TBDProjects.Name, Watchlist.User_ID, Watchlist.Project_ID, UsersWatchlist.Project_ID as InUsersWatchlist, TBDProjects.ID as ProjectID
          FROM proveq.Projects TBDProjects
          LEFT JOIN proveq.Watchlist UsersWatchlist ON TBDProjects.ID = UsersWatchlist.Project_ID AND UsersWatchlist.User_ID = '289' AND UsersWatchlist.Status='1'
          INNER JOIN proveq.Watchlist Watchlist ON ProjectID.ID=Watchlist.Project_ID AND Watchlist.User_ID  IN (220,289,179, 505)  AND Watchlist.Status='1'
          WHERE TBDProjects.Sale_Status='TBD'
          GROUP BY TBDProjects.Name
          ORDER BY CAST(TBDProjects.Completion AS UNSIGNED) ASC) as tbd
          LIMIT 30