Макс
Ничего не изменилось работает и возвращает тот же результат что и предидущий запрос...
Вот структура таблиц:
[B]TABLE `post`[/B] (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default \'0\',
`username` varchar(50) NOT NULL default \'\',
`userid` int(10) unsigned NOT NULL default \'0\',
`title` varchar(100) NOT NULL default \'\',
`dateline` int(10) unsigned NOT NULL default \'0\',
`attachmentid` smallint(5) unsigned NOT NULL default \'0\',
`pagetext` mediumtext NOT NULL,
`allowsmilie` smallint(6) NOT NULL default \'0\',
`showsignature` smallint(6) NOT NULL default \'0\',
`ipaddress` varchar(16) NOT NULL default \'\',
`iconid` smallint(5) unsigned NOT NULL default \'0\',
`visible` smallint(6) NOT NULL default \'0\',
`edituserid` int(10) unsigned NOT NULL default \'0\',
`editdate` int(10) unsigned NOT NULL default \'0\',
PRIMARY KEY (`postid`),
KEY `iconid` (`iconid`),
KEY `userid` (`userid`),
KEY `threadid` (`threadid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
[B]TABLE `thread`[/B] (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default \'\',
`lastpost` int(10) unsigned NOT NULL default \'0\',
`forumid` smallint(5) unsigned NOT NULL default \'0\',
`pollid` int(10) unsigned NOT NULL default \'0\',
`open` tinyint(4) NOT NULL default \'0\',
`replycount` int(10) unsigned NOT NULL default \'0\',
`postusername` varchar(50) NOT NULL default \'\',
`postuserid` int(10) unsigned NOT NULL default \'0\',
`lastposter` varchar(50) NOT NULL default \'\',
`dateline` int(10) unsigned NOT NULL default \'0\',
`views` int(10) unsigned NOT NULL default \'0\',
`iconid` smallint(5) unsigned NOT NULL default \'0\',
`notes` varchar(250) NOT NULL default \'\',
`visible` smallint(6) NOT NULL default \'0\',
`sticky` smallint(6) NOT NULL default \'0\',
`votenum` smallint(5) unsigned NOT NULL default \'0\',
`votetotal` smallint(5) unsigned NOT NULL default \'0\',
`attach` smallint(5) unsigned NOT NULL default \'0\',
PRIMARY KEY (`threadid`),
KEY `iconid` (`iconid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;