mainconcept mainconceptx

## tmux-cheatsheet.markdown

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                mainconceptx
                / tmux-cheatsheet.markdown
            
            
              Created
              November 5, 2019 08:48
                — forked from MohamedAlaa/tmux-cheatsheet.markdown
            
              
                tmux shortcuts & cheatsheet
              
          
    tmux shortcuts & cheatsheet

start new:
tmux

start new with session name:
tmux new -s myname


## gist:9e21711f25c1f8cf33f908b19bf878c0
Select * from MeritData
Order by Date desc
Limit 10

## gist:3d843db920308cf09669e3e8961d8cd7
-- The Pharmacist <> LoyceV
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId
Where FromUser.UserName = "The Pharmacist" AND ToUser.UserName = "LoyceV"
);
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
	-- The Pharmacist <> LoyceV
	SELECT FromUser, ToUser, SUM(Merit) as Merit from (
	SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
	INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
	INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId
	Where FromUser.UserName = "The Pharmacist" AND ToUser.UserName = "LoyceV"
	);
	SELECT FromUser, ToUser, SUM(Merit) as Merit from (
	SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
	INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId