#
# Структура таблицы `tbaddaccess`
#

CREATE TABLE `tbaddaccess` (
  `idAddAccess` int( 2 ) NOT NULL auto_increment,
  `StrAddAccess` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idAddAccess`),
  KEY `idAddAccess` (`idAddAccess`)
) TYPE=MyISAM COMMENT='Таблица дополнительных принадлежностей' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbaddaccess`
#

INSERT INTO `tbaddaccess` VALUES ( 1 , 'Какие-то дополнительные принадлежности');
INSERT INTO `tbaddaccess` VALUES ( 2 , 'Ещё доп. Принадлежности');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbcodename`
#

CREATE TABLE `tbcodename` (
  `idMCode` int( 2 ) NOT NULL auto_increment,
  `StrCodeName` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idMCode`),
  KEY `idMCode` (`idMCode`)
) TYPE=MyISAM COMMENT='Таблица кодов товара' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbcodename`
#

INSERT INTO `tbcodename` VALUES ( 1 , '1B');
INSERT INTO `tbcodename` VALUES ( 2 , '1B.1D');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbcolor`
#

CREATE TABLE `tbcolor` (
  `idColor` int( 2 ) NOT NULL auto_increment,
  `StrColor` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idColor`),
  KEY `idColor` (`idColor`)
) TYPE=MyISAM COMMENT='Таблица цветов покрытия' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbcolor`
#

INSERT INTO `tbcolor` VALUES ( 1 , 'Серебристый металлик');
INSERT INTO `tbcolor` VALUES ( 2 , 'Белый');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbcomments`
#

CREATE TABLE `tbcomments` (
  `idComment` int( 2 ) NOT NULL auto_increment,
  `StrComment` varchar( 50 ) NOT NULL default '',
  PRIMARY KEY  (`idComment`),
  KEY `idComment` (`idComment`)
) TYPE=MyISAM COMMENT='Таблица примечаний' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbcomments`
#

INSERT INTO `tbcomments` VALUES ( 1 , 'Какие-то дополнения 1');
INSERT INTO `tbcomments` VALUES ( 2 , 'Какие-то дополнения 2');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbcurrency`
#

CREATE TABLE `tbcurrency` (
  `idCurrency` int( 2 ) NOT NULL auto_increment,
  `StrCurrency` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idCurrency`),
  KEY `idCurrency` (`idCurrency`)
) TYPE=MyISAM COMMENT='Таблица валют' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbcurrency`
#

INSERT INTO `tbcurrency` VALUES ( 1 , 'Доллары США');
INSERT INTO `tbcurrency` VALUES ( 2 , 'Рубли');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbdescrconf`
#

CREATE TABLE `tbdescrconf` (
  `idDescrConf` int( 2 ) NOT NULL auto_increment,
  `StrDescrConf` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idDescrConf`),
  KEY `idDescrConf` (`idDescrConf`)
) TYPE=MyISAM COMMENT='Таблица описаний конфигурации товаров' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbdescrconf`
#

INSERT INTO `tbdescrconf` VALUES ( 1 , 'Одночашечная');
INSERT INTO `tbdescrconf` VALUES ( 2 , 'С крылом');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbdescrform`
#

CREATE TABLE `tbdescrform` (
  `idDescrForm` int( 2 ) NOT NULL auto_increment,
  `StrDescrForm` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idDescrForm`),
  KEY `idDescrForm` (`idDescrForm`)
) TYPE=MyISAM COMMENT='Таблица описаний форм моек' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbdescrform`
#

INSERT INTO `tbdescrform` VALUES ( 1 , 'Круглая');
INSERT INTO `tbdescrform` VALUES ( 2 , 'Овальная');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbdescrsink`
#

CREATE TABLE `tbdescrsink` (
  `idDescrSink` int( 2 ) NOT NULL auto_increment,
  `StrDescrSink` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idDescrSink`),
  KEY `idDescrSink` (`idDescrSink`)
) TYPE=MyISAM COMMENT='Таблица описания слива' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbdescrsink`
#

INSERT INTO `tbdescrsink` VALUES ( 1 , 'Простой');
INSERT INTO `tbdescrsink` VALUES ( 2 , 'Сложный');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbfamily`
#

CREATE TABLE `tbfamily` (
  `idFamily` int( 2 ) NOT NULL auto_increment,
  `StrFamilyName` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idFamily`),
  KEY `idFamily` (`idFamily`),
  KEY `idFamily_2` (`idFamily`)
) TYPE=MyISAM COMMENT='Таблица семейств моек' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbfamily`
#

INSERT INTO `tbfamily` VALUES ( 1 , 'Beta');
INSERT INTO `tbfamily` VALUES ( 2 , 'Regent');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbgroups`
#

CREATE TABLE `tbgroups` (
  `idGroup` int( 2 ) NOT NULL auto_increment,
  `StrGroupName` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idGroup`),
  KEY `idGroup` (`idGroup`)
) TYPE=MyISAM COMMENT='Таблица групп моек' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbgroups`
#

INSERT INTO `tbgroups` VALUES ( 1 , 'Мойка');
INSERT INTO `tbgroups` VALUES ( 2 , 'Смеситель');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbgtd`
#

CREATE TABLE `tbgtd` (
  `idGTD` int( 2 ) NOT NULL auto_increment,
  `StrGTD` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idGTD`),
  KEY `idGTD` (`idGTD`)
) TYPE=MyISAM COMMENT='Таблица кодов ГТД' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbgtd`
#

INSERT INTO `tbgtd` VALUES ( 1 , '1111');
INSERT INTO `tbgtd` VALUES ( 2 , '2222');

#  --------------------------------------------------------
 

#
# Структура таблицы `tblr`
#

CREATE TABLE `tblr` (
  `idLR` int( 2 ) NOT NULL auto_increment,
  `StrLeftRight` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idLR`),
  KEY `idLR` (`idLR`)
) TYPE=MyISAM COMMENT='Таблица (левая/правая)' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tblr`
#

INSERT INTO `tblr` VALUES ( 1 , 'Левая');
INSERT INTO `tblr` VALUES ( 2 , 'Правая');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbmaterial`
#

CREATE TABLE `tbmaterial` (
  `idDescrMaterial` int( 2 ) NOT NULL auto_increment,
  `StrDescrMaterial` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idDescrMaterial`),
  KEY `idDescrMaterial` (`idDescrMaterial`)
) TYPE=MyISAM COMMENT='Таблица материалов' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbmaterial`
#

INSERT INTO `tbmaterial` VALUES ( 1 , 'Гранит');
INSERT INTO `tbmaterial` VALUES ( 2 , 'Сталь');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbnds`
#

CREATE TABLE `tbnds` (
  `idNDS` int( 2 ) NOT NULL auto_increment,
  `snNDS` decimal( 10 , 2 ) NOT NULL default '0.00',
  PRIMARY KEY  (`idNDS`),
  KEY `idNDS` (`idNDS`)
) TYPE=MyISAM COMMENT='Таблица ставок НДС' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbnds`
#

INSERT INTO `tbnds` VALUES ( 1 , '10.00');
INSERT INTO `tbnds` VALUES ( 2 , '15.00');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbpackage`
#

CREATE TABLE `tbpackage` (
  `idPackage` int( 2 ) NOT NULL auto_increment,
  `StrPackage` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idPackage`),
  KEY `idPackage` (`idPackage`)
) TYPE=MyISAM COMMENT='Таблица упаковок' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbpackage`
#

INSERT INTO `tbpackage` VALUES ( 1 , 'Палета');
INSERT INTO `tbpackage` VALUES ( 2 , 'Коробка');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbprodtypes`
#

CREATE TABLE `tbprodtypes` (
  `idProdType` int( 2 ) NOT NULL auto_increment,
  `StrProdType` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idProdType`),
  KEY `idProdType` (`idProdType`)
) TYPE=MyISAM COMMENT='Таблица типов товаров' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbprodtypes`
#

INSERT INTO `tbprodtypes` VALUES ( 1 , 'Комплект');
INSERT INTO `tbprodtypes` VALUES ( 2 , 'Товар');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbproducts`
#

CREATE TABLE `tbproducts` (
  `idProd` int( 11 ) NOT NULL auto_increment,
  `IntCode` int( 11 ) default NULL,
  `idProdType` int( 2 ) NOT NULL default '0',
  `idNDS` int( 11 ) NOT NULL default '0',
  `IntOKDP` int( 11 ) default NULL,
  `StrName` varchar( 255 ) default NULL,
  `idCurrency` int( 11 ) NOT NULL default '0',
  `idUnit` int( 11 ) NOT NULL default '0',
  `BlCat1` enum('Y','N') NOT NULL default 'N',
  `BlCat2` enum('Y','N') NOT NULL default 'N',
  `idGTD` int( 11 ) NOT NULL default '0',
  `IntMinRest` int( 11 ) default NULL,
  `idVendors` int( 11 ) NOT NULL default '0',
  `idGroup` int( 11 ) NOT NULL default '0',
  `idFamily` int( 11 ) NOT NULL default '0',
  `idMCode` int( 11 ) NOT NULL default '0',
  `idSurf` int( 11 ) NOT NULL default '0',
  `idSinks` int( 11 ) NOT NULL default '0',
  `idLR` int( 11 ) NOT NULL default '0',
  `idPackage` int( 11 ) NOT NULL default '0',
  `idComment` int( 11 ) NOT NULL default '0',
  `StrNewName` varchar( 255 ) default NULL,
  `LnWidth` int( 11 ) default NULL,
  `LnLenght` int( 11 ) default NULL,
  `LnDepth` int( 11 ) default NULL,
  `LnHoleWidth` int( 11 ) default NULL,
  `LnHoleLenght` int( 11 ) default NULL,
  `LnTumbaWidth` int( 11 ) default NULL,
  `LnTumbaLenght` int( 11 ) default NULL,
  `idDescrForm` int( 11 ) NOT NULL default '0',
  `idDescrConf` int( 11 ) NOT NULL default '0',
  `idDescrSink` int( 11 ) NOT NULL default '0',
  `idDescrMaterial` int( 11 ) NOT NULL default '0',
  `LnTickness` int( 11 ) default NULL,
  `idStandartCompl` int( 11 ) NOT NULL default '0',
  `idAddAccess` int( 11 ) NOT NULL default '0',
  `BlSinkHole` enum('Y','N') NOT NULL default 'N',
  `idColor` int( 11 ) NOT NULL default '0',
  PRIMARY KEY  (`idProd`),
  KEY `idProd` (`idProd`),
  KEY `StrName` (`StrName`)
) TYPE=MyISAM COMMENT='Таблица товаров' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbproducts`
#

INSERT INTO `tbproducts` VALUES ( 1 ,  123 ,  1 ,  1 ,  321 , 'Товар №1',  1 ,  1 , 'Y', 'N',  1 ,  5 ,  1 ,  1 ,  1 ,  1 ,  1 ,  1 ,  1 ,  1 ,  1 , 'Новое название товара №1',  4 ,  5 ,  6 ,  7 ,  8 ,  9 ,  20 ,  1 ,  1 ,  1 ,  1 ,  21 ,  1 ,  1 , 'Y',  1 );
INSERT INTO `tbproducts` VALUES ( 2 ,  456 ,  2 ,  2 ,  789 , 'Товар №2',  2 ,  2 , 'N', 'Y',  2 ,  9 ,  2 ,  2 ,  2 ,  2 ,  2 ,  2 ,  2 ,  2 ,  2 , 'Новое название №2',  30 ,  31 ,  32 ,  33 ,  34 ,  35 ,  36 ,  2 ,  2 ,  2 ,  2 ,  37 ,  2 ,  2 , 'N',  2 );

#  --------------------------------------------------------
 

#
# Структура таблицы `tbsinknames`
#

CREATE TABLE `tbsinknames` (
  `idSinks` int( 2 ) NOT NULL auto_increment,
  `StrSinkName` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idSinks`),
  KEY `idSinks` (`idSinks`)
) TYPE=MyISAM COMMENT='Таблица сливов 2' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbsinknames`
#

INSERT INTO `tbsinknames` VALUES ( 1 , '2,5" с железной пробкой');
INSERT INTO `tbsinknames` VALUES ( 2 , '3,5" без пробки');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbstandartcompl`
#

CREATE TABLE `tbstandartcompl` (
  `idStandartCompl` int( 2 ) NOT NULL auto_increment,
  `StrStandartCompl` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idStandartCompl`),
  KEY `idStandartCompl` (`idStandartCompl`)
) TYPE=MyISAM COMMENT='Таблица описания стандартной комплектации' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbstandartcompl`
#

INSERT INTO `tbstandartcompl` VALUES ( 1 , 'Стандартная комплектация 1');
INSERT INTO `tbstandartcompl` VALUES ( 2 , 'Стандартная комплектация 2');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbsurfaces`
#

CREATE TABLE `tbsurfaces` (
  `idSurf` int( 2 ) NOT NULL auto_increment,
  `StrSurfName` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idSurf`),
  KEY `idSurf` (`idSurf`)
) TYPE=MyISAM COMMENT='Таблица поверхностей' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbsurfaces`
#

INSERT INTO `tbsurfaces` VALUES ( 1 , 'Матовая');
INSERT INTO `tbsurfaces` VALUES ( 2 , 'Лакерованная');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbunits`
#

CREATE TABLE `tbunits` (
  `idUnit` int( 2 ) NOT NULL auto_increment,
  `StrUnitName` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idUnit`),
  KEY `idUnit` (`idUnit`)
) TYPE=MyISAM COMMENT='Таблица единиц измерения' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbunits`
#

INSERT INTO `tbunits` VALUES ( 1 , 'шт.');
INSERT INTO `tbunits` VALUES ( 2 , '100 шт.');

#  --------------------------------------------------------
 

#
# Структура таблицы `tbvendors`
#

CREATE TABLE `tbvendors` (
  `idVendors` int( 2 ) NOT NULL auto_increment,
  `StrVendorName` varchar( 50 ) default NULL,
  PRIMARY KEY  (`idVendors`),
  KEY `idVendors` (`idVendors`)
) TYPE=MyISAM COMMENT='Таблица производителей' AUTO_INCREMENT= 3  ;

#
# Дамп данных таблицы `tbvendors`
#

INSERT INTO `tbvendors` VALUES ( 1 , 'Reginox');
INSERT INTO `tbvendors` VALUES ( 2 , 'Teka');

# Запрос
SELECT 
	tbproducts.*, 
	tbprodtypes.StrProdType, 
	tbnds.snNDS, 
	tbcurrency.StrCurrency, 
	tbunits.StrUnitName, 
	tbgtd.StrGTD, 
	tbvendors.StrVendorName, 
	tbgroups.StrGroupName, 
	tbfamily.StrFamilyName, 
	tbcodename.StrCodeName, 
	tbsurfaces.StrSurfName, 
	tbsinknames.StrSinkName, 
	tblr.StrLeftRight, 
	tbpackage.StrPackage, 
	tbcomments.StrComment, 
	tbdescrform.StrDescrForm, 
	tbdescrconf.StrDescrConf, 
	tbdescrsink.StrDescrSink, 
	tbmaterial.StrDescrMaterial, 
	tbstandartcompl.StrStandartCompl, 
	tbaddaccess.StrAddAccess, 
	tbcolor.StrColor 
FROM 
	tbproducts, 
	tbprodtypes, 
	tbnds, 
	tbcurrency, 
	tbunits, 
	tbgtd, 
	tbvendors, 
	tbgroups, 
	tbfamily, 
	tbcodename, 
	tbsurfaces, 
	tbsinknames, 
	tblr, 
	tbpackage, 
	tbcomments, 
	tbdescrform, 
	tbdescrconf, 
	tbdescrsink, 
	tbmaterial, 
	tbstandartcompl, 
	tbaddaccess, 
	tbcolor 
WHERE 
	tbproducts.idProdType = tbprodtypes.idProdType AND 
	tbproducts.idNDS = tbnds.idNDS AND 
	tbproducts.idCurrency = tbcurrency.idCurrency AND 
	tbproducts.idUnit = tbunits.idUnit AND 
	tbproducts.idGTD = tbgtd.idGTD AND 
	tbproducts.idVendors = tbvendors.idVendors AND 
	tbproducts.idGroup = tbgroups.idGroup AND 
	tbproducts.idFamily = tbfamily.idFamily AND 
	tbproducts.idMCode = tbcodename.idMCode AND 
	tbproducts.idSurf = tbsurfaces.idSurf AND 
	tbproducts.idSinks = tbsinknames.idSinks AND 
	tbproducts.idLR = tblr.idLR AND 
	tbproducts.idPackage = tbpackage.idPackage AND 
	tbproducts.idComment = tbcomments.idComment AND 
	tbproducts.idDescrForm = tbdescrform.idDescrForm AND 
	tbproducts.idDescrConf = tbdescrconf.idDescrConf AND 
	tbproducts.idDescrSink = tbdescrsink.idDescrSink AND 
	tbproducts.idDescrMaterial = tbmaterial.idDescrMaterial AND 
	tbproducts.idStandartCompl = tbstandartcompl.idStandartCompl AND 
	tbproducts.idAddAccess = tbaddaccess.idAddAccess AND 
	tbproducts.idColor = tbcolor.idColor;

+ -----------------+--------+-----------------------------+---------+---------+----------------------------+------+-------+
 
| table           | type   | possible_keys               | key     | key_len | ref                        | rows | Extra |
+ -----------------+--------+-----------------------------+---------+---------+----------------------------+------+-------+
 
| tbproducts      | ALL    | idCurrency,idFamily,idGroup | NULL    |    NULL | NULL                       |     2  |       |
| tbprodtypes     | eq_ref | PRIMARY,idProdType          | PRIMARY |        4  | tbproducts.idProdType      |     1  |       |
| tbnds           | eq_ref | PRIMARY,idNDS               | PRIMARY |        4  | tbproducts.idNDS           |     1  |       |
| tbcurrency      | eq_ref | PRIMARY,idCurrency          | PRIMARY |        4  | tbproducts.idCurrency      |     1  |       |
| tbunits         | eq_ref | PRIMARY,idUnit              | PRIMARY |        4  | tbproducts.idUnit          |     1  |       |
| tbgtd           | eq_ref | PRIMARY,idGTD               | PRIMARY |        4  | tbproducts.idGTD           |     1  |       |
| tbvendors       | eq_ref | PRIMARY,idVendors           | PRIMARY |        4  | tbproducts.idVendors       |     1  |       |
| tbgroups        | eq_ref | PRIMARY,idGroup             | PRIMARY |        4  | tbproducts.idGroup         |     1  |       |
| tbfamily        | eq_ref | PRIMARY,idFamily,idFamily_2 | PRIMARY |        4  | tbproducts.idFamily        |     1  |       |
| tbcodename      | eq_ref | PRIMARY,idMCode             | PRIMARY |        4  | tbproducts.idMCode         |     1  |       |
| tbsurfaces      | eq_ref | PRIMARY,idSurf              | PRIMARY |        4  | tbproducts.idSurf          |     1  |       |
| tbsinknames     | eq_ref | PRIMARY,idSinks             | PRIMARY |        4  | tbproducts.idSinks         |     1  |       |
| tblr            | eq_ref | PRIMARY,idLR                | PRIMARY |        4  | tbproducts.idLR            |     1  |       |
| tbpackage       | eq_ref | PRIMARY,idPackage           | PRIMARY |        4  | tbproducts.idPackage       |     1  |       |
| tbcomments      | eq_ref | PRIMARY,idComment           | PRIMARY |        4  | tbproducts.idComment       |     1  |       |
| tbdescrform     | eq_ref | PRIMARY,idDescrForm         | PRIMARY |        4  | tbproducts.idDescrForm     |     1  |       |
| tbdescrconf     | eq_ref | PRIMARY,idDescrConf         | PRIMARY |        4  | tbproducts.idDescrConf     |     1  |       |
| tbdescrsink     | eq_ref | PRIMARY,idDescrSink         | PRIMARY |        4  | tbproducts.idDescrSink     |     1  |       |
| tbmaterial      | eq_ref | PRIMARY,idDescrMaterial     | PRIMARY |        4  | tbproducts.idDescrMaterial |     1  |       |
| tbstandartcompl | eq_ref | PRIMARY,idStandartCompl     | PRIMARY |        4  | tbproducts.idStandartCompl |     1  |       |
| tbaddaccess     | eq_ref | PRIMARY,idAddAccess         | PRIMARY |        4  | tbproducts.idAddAccess     |     1  |       |
| tbcolor         | eq_ref | PRIMARY,idColor             | PRIMARY |        4  | tbproducts.idColor         |     1  |       |
+-----------------+--------+-----------------------------+---------+---------+----------------------------+------+-------+