56,937
社区成员




CREATE TABLE IF NOT EXISTS `m_t` (
`name` varchar(15) NOT NULL,
`col` smallint(2) NOT NULL,
`index` varchar(30) NOT NULL,
`date` int(10) NOT NULL,
PRIMARY KEY (`index`,`name`,`col`),
KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SELECT * FROM
m_t a JOIN m_t b
ON a.name = b.name
WHERE
a.index='word1'
AND
b.index='word2'
Group by a.name
ORDER BY a.date
DESC LIMIT 10