CREATE TABLE `irbis_indexing_index` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` int(11) NOT NULL DEFAULT '0',
  `stem` int(11) NOT NULL DEFAULT '0',
  `times` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_index_linkstem` (`link`,`stem`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `irbis_indexing_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uri` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `irbis_indexing_stem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stem` varchar(30) NOT NULL DEFAULT '',
  `sound` char(4) NOT NULL DEFAULT 'A000',
  PRIMARY KEY (`id`),
  KEY `idx_stem_stem` (`stem`(8)),
  KEY `idx_stem_sound` (`sound`(4))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

$res = mysqlQuery(
  'SELECT il.`id`, il.`uri`
   FROM `' . IRB_DBPREFIX . 'indexing_link` il,
        `' . IRB_DBPREFIX . 'indexing_index` ii,
        `' . IRB_DBPREFIX . "indexing_stem` iw
   WHERE iw.`stem` IN ('" . implode("', '", $stems) . "') 
     AND ii.`stem` = iw.`id` 
     AND il.`id` = ii.`link`
   GROUP BY il.`id` 
   ORDER BY ii.`times` DESC
  ");

id | uri
---|-----------------------------------------------
37 | http://localhost:8080/IRBIS-core/test/1.html
38 | http://localhost:8080/IRBIS-core/test/1-1.html

id   | stem        | sound
-----|-------------|------
6795 | domashn     | D525
6796 | stranic     | S365
6889 | programmist | P626

id | link | stem | times
-----|----|------|------
3535 | 37 | 6795 | 1
3536 | 37 | 6796 | 1
3537 | 37 | 6889 | 1
3629 | 38 | 6889 | 4

$stem = array('stranic', 'programmist');

array('http://localhost:8080/IRBIS-core/test/1-1.html', 'http://localhost:8080/IRBIS-core/test/1.html');

SELECT l.`id`, l.`uri`
    FROM `irbis_indexing_link` l
    LEFT JOIN `irbis_indexing_index` i ON l.id = i.link
    LEFT JOIN `irbis_indexing_stem` s  ON i.stem = s.id
    WHERE s.`stem` IN ('stranic', 'programmist') 
    GROUP BY l.`id` 
    ORDER BY i.`times` DESC

$result = mysql_query($query);
if($result){
    while($row = mysql_fetch_assoc($result)){
        $resArray[] = $row['uri'];
    }
}

$query = "SELECT * from `table` where `name` = 'vasja'";

Спустя 19 минут, 3 секунды (27.01.2011 - 01:37) Invis1ble написал(а):

inpost

Цитата

Предел нубства

Чьего нубства? Не совсем понял тебя, если чесно....