DROP TABLE IF EXISTS `preMadeReply`;

CREATE TABLE `preMadeReply`

(

    `preReplyId` int UNSIGNED NOT NULL AUTO_INCREMENT,

    `slug`   VARCHAR(255) NOT NULL,

    `reply` TEXT NOT NULL,

`question`   VARCHAR(255) NOT NULL,

    `createdAt` datetime NOT NULL,

    PRIMARY KEY (`preReplyId`)

);


select distinct users.userId,users.commission,users.username,users.email,users.emailConfirmed,users.givenName,

users.tokenBalance,users.contributed,users.lastLogin,users.countryId,users.city,users.created_at,users.surname

from devdb_pylon_token.transactions  join wallets ON wallets.walletId = transactions.walletId

 join users ON users.userId = wallets.userId  WHERE transactionId In (SELECT distinct(transactions.transactionReference)

 FROM devdb_pylon_token.transactions where walletId = 2079 

 and transactionTypeId = 5 and createdAt >= DATE('2022-12-22'));