20,359
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `fproduct` (
`f_id` INT(11) NOT NULL AUTO_INCREMENT,
`f_show` INT(11) DEFAULT '1', COMMENT '0不显示,1显示',
`f_date` BIGINT(20) DEFAULT '0',
PRIMARY KEY (`f_id`)
) ENGINE=INNODB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8
CREATE TABLE `comment` (
`c_id` INT(11) NOT NULL AUTO_INCREMENT,
`c_fid` INT(11) DEFAULT '0', COMMENT '对应产品表f_id',
`c_verify` INT(11) DEFAULT '0' COMMENT '0为未审核(不显示),1为审核(显示)',
`c_date` BIGINT(20) DEFAULT '0',
PRIMARY KEY (`c_id`)
) ENGINE=INNODB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8
SELECT COUNT(f_id) FROM `comment`,fproduct WHERE c_fid=f_id AND c_verify=1 AND f_show=1 ORDER BY c_date DESC;