SELECT cointransaction.datefunded, coin.coinnumber, coin.coinname, cointransaction.cointransactionamount AS coinvalue, player.playername, cointransaction.coinparcel
FROM cointransaction
JOIN player ON cointransaction.playeruuid = player.playeruuid
LEFT JOIN coin ON cointransaction.coinuuid = coin.coinuuid
WHERE cointransaction.cointransactionamount > 1
AND cointransaction.transactiontype = 'Pay Player' 

and cointransaction.coinparcel = 'Rosetta Stone' 
and datefunded >= '2016-8-1' 
ORDER BY coin.coinuuid, cointransaction.datefunded DESC