CREATE TABLE IF NOT EXISTS `filters` (
`id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'название фильтра',
  `service_type_id` int(10) unsigned NOT NULL COMMENT 'категория',
  `user_id` int(10) unsigned NOT NULL COMMENT 'владелец фильтра',
  `add_date` datetime DEFAULT NULL COMMENT 'дата добавления',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active' COMMENT 'статус фильтра'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='фильтры' AUTO_INCREMENT=22 ;

CREATE TABLE IF NOT EXISTS `filter_vs_article` (
`id` int(10) unsigned NOT NULL,
  `filter_id` int(10) unsigned NOT NULL COMMENT 'фильтр',
  `service_article_id` int(10) unsigned NOT NULL COMMENT 'группа запчастей или услуг'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='фильтры - группы запчастей или услуг' AUTO_INCREMENT=376 ;

CREATE TABLE IF NOT EXISTS `filter_vs_made_year` (
`id` int(10) unsigned NOT NULL,
  `filter_id` int(10) unsigned NOT NULL,
  `made_year` year(4) NOT NULL COMMENT 'года выпуска'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='фильтры - года производства' AUTO_INCREMENT=457 ;

CREATE TABLE IF NOT EXISTS `filter_vs_model` (
`id` int(10) unsigned NOT NULL,
  `filter_id` int(10) unsigned NOT NULL COMMENT 'фильтер',
  `car_model_id` int(10) NOT NULL COMMENT 'модель'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='фильтры - модели' AUTO_INCREMENT=492 ;

CREATE TABLE IF NOT EXISTS `filter_vs_region` (
`id` int(10) unsigned NOT NULL,
  `filter_id` int(10) unsigned NOT NULL COMMENT 'фильтр',
  `region_id` int(10) unsigned NOT NULL COMMENT 'регион'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='фильтры - регионы' AUTO_INCREMENT=298 ;

SELECT 
f.user_id,
f.add_date,
f.name,
GROUP_CONCAT(f_vs_year.made_year) years,
GROUP_CONCAT(distinct f_vs_article.service_article_id) articles,
GROUP_CONCAT(distinct mark.name) marks,
GROUP_CONCAT(distinct model.name) models

FROM filters f 

JOIN filter_vs_made_year f_vs_year ON f_vs_year.filter_id = f.id

JOIN filter_vs_model f_vs_model ON f_vs_model.filter_id = f.id
JOIN car_model model ON model.id_car_model = f_vs_model.car_model_id
JOIN car_mark mark ON mark.id_car_mark = model.id_car_mark

JOIN filter_vs_article f_vs_article ON f_vs_article.filter_id = f.id
JOIN service_articles s_articles ON s_article.id = f_vs_article.service_article_id

WHERE f.user_id = 36

GROUP BY f.id    ORDER BY f.add_date LIMIT 0,14

SELECT 
f.id,
f.user_id,
f.add_date,
f.name,
years.years,
models.models,
models.marks,
regions.regions,
services.services

FROM filters f 

JOIN 

(SELECT 
 	GROUP_CONCAT(made_year) As years,
 	filter_id 
 	FROM filter_vs_made_year 
 	group by filter_id
) 
As years ON years.filter_id = f.id

JOIN 

(SELECT 
 	GROUP_CONCAT(model.name) As models,
    GROUP_CONCAT(mark.name) As marks,
 	filter_id 
 	FROM filter_vs_model f_vs_model 
    JOIN car_model model ON model.id_car_model = f_vs_model.car_model_id
    JOIN car_mark mark ON mark.id_car_mark = model.id_car_mark
 	group by filter_id
 )
As models ON models.filter_id = f.id

JOIN

 (SELECT GROUP_CONCAT(r.name) As regions,filter_id 
  FROM filter_vs_region f_vs_region
  JOIN regions r ON r.rid = f_vs_region.region_id
  
  group by filter_id
  )
As regions ON regions.filter_id = f.id

JOIN

 (SELECT GROUP_CONCAT(s.name_ru) As services,filter_id 
  FROM filter_vs_article f_vs_service
  JOIN service_article s ON s.id = f_vs_service.service_article_id
  
  group by filter_id
  )
As services ON services.filter_id = f.id


WHERE f.user_id = 36