SELECT `goods`.`name` AS `name`, `goods`.`code` AS `code`, `goods`.`manufacturer_id` AS `manufacturer_id`, `goods`.`id` AS `id`, `goods`.`parent_id` AS `parent_id`, `price`.`price` AS `price`, `price`.`total` AS `total`, `manufacturer`.`name` AS `manufacturer_name`, `manufacturer`.`country` AS `manufacturer_country`, `provider`.`date` AS `provider_date`, `provider`.`id` AS `provider_id`, `basket`.`id` AS `basket_id` 
FROM `goods_car` 
LEFT JOIN `goods` ON `goods_car`.`code` = `goods`.`code` AND `goods_car`.`manufacturer_id` = `goods`.`manufacturer_id` 
LEFT JOIN `manufacturer` ON `goods`.`manufacturer_id` = `manufacturer`.`id` 
LEFT JOIN `price` ON `goods_car`.`code` = `price`.`code` AND `goods_car`.`manufacturer_id` = `price`.`manufacturer_id` 
LEFT JOIN `basket` ON `goods_car`.`code` = `basket`.`code` AND `goods_car`.`manufacturer_id` = `basket`.`manufacturer_id` AND `basket`.`status` = 1 
LEFT JOIN `provider` ON `price`.`provider_id` = `provider`.`id` 
WHERE `goods_car`.`car_id` = $car_id 
ORDER BY `goods`.`name` asc

CREATE TABLE `goods` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`parent_id` INT(11) NOT NULL,
	`name` VARCHAR(255) NOT NULL,
	`code` VARCHAR(255) NOT NULL,
	`search` VARCHAR(255) NOT NULL,
	`text` TEXT NOT NULL,
	`manufacturer_id` INT(11) NOT NULL,
	`photo` VARCHAR(100) NOT NULL,
	`status` TINYINT(4) NOT NULL DEFAULT '1',
	PRIMARY KEY (`id`),
	INDEX `manufacturer_id` (`manufacturer_id`),
	INDEX `parent_id` (`parent_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=112254
;

CREATE TABLE `manufacturer` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(255) NOT NULL,
	`country` VARCHAR(255) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=639
;

CREATE TABLE `goods_car` (
	`car_id` INT(11) NOT NULL,
	`code` VARCHAR(255) NOT NULL,
	`manufacturer_id` INT(11) NOT NULL,
	INDEX `manufacturer_id` (`manufacturer_id`),
	INDEX `car_id` (`car_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

CREATE TABLE `price` (
	`provider_id` INT(11) NOT NULL,
	`code` VARCHAR(255) NOT NULL,
	`price` DOUBLE NOT NULL,
	`manufacturer_id` INT(11) NOT NULL,
	`total` INT(11) NOT NULL DEFAULT '0',
	INDEX `provider_id` (`provider_id`),
	INDEX `manufacturer` (`manufacturer_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

CREATE TABLE `provider` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(250) NOT NULL,
	`phone` TEXT NOT NULL,
	`file` VARCHAR(150) NOT NULL,
	`text` TEXT NOT NULL,
	`date` BIGINT(20) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=2
;

CREATE TABLE `basket` (
	`id` VARCHAR(100) NOT NULL,
	`goods_id` INT(11) NOT NULL,
	`total` INT(11) NOT NULL DEFAULT '1',
	`name` VARCHAR(255) NOT NULL,
	`manufacturer_id` INT(11) NOT NULL,
	`code` VARCHAR(255) NOT NULL,
	`price` DOUBLE NOT NULL,
	`summa` DOUBLE NOT NULL,
	`provider_id` INT(11) NOT NULL,
	`status` TINYINT(4) NOT NULL DEFAULT '1',
	`date` BIGINT(20) NOT NULL,
	INDEX `id` (`id`)
)
COLLATE='utf8_general_ci'
ENGI