-- 
-- Структура таблиці `articles`
-- 

CREATE TABLE `articles` (
  `id` bigint(255) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `short` text,
  `text` text,
  `keywords` text,
  `date` datetime NOT NULL,
  `ip` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------

-- 
-- Структура таблиці `connection`
-- 

CREATE TABLE `connection` (
  `id_tag` bigint(255) NOT NULL,
  `id_article` bigint(255) NOT NULL,
  KEY `id_tag` (`id_tag`,`id_article`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------

-- 
-- Структура таблиці `tags`
-- 

CREATE TABLE `tags` (
  `id` bigint(255) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

SELECT `tags`.`id` AS `tags.id`,
	`tags`.`name` AS `tags.name`,
	`articles`.`id` AS `articles.id`, 
	`articles`.`name` AS `articles.name`, 
	`articles`.`short`, 
	`articles`.`date`, 
	`articles`.`ip`
FROM articles, tags, connection
WHERE articles.id = connection.id_article 
	and tags.id = connection.id_tag
	and articles.id IN (
			SELECT id_article
			FROM connection
			WHERE id_tag=17
		       )
ORDER BY articles.date

SELECT `tags`.`id` AS `tags.id`,
	`tags`.`name` AS `tags.name`,
	`articles`.`id` AS `articles.id`, 
	`articles`.`name` AS `articles.name`, 
	`articles`.`short`, 
	`articles`.`date`, 
	`articles`.`ip`
FROM articles, tags, connection
WHERE articles.id = connection.id_article 
	and tags.id = connection.id_tag
	and articles.id = 12
ORDER BY articles.date