SELECT pr.name,
       pr.id AS property_id,
       pv.value,
       pv.id AS property_value_id,
       pv.description AS description
FROM products AS p
INNER JOIN product_properties AS pp ON p.id = pp.product_id
INNER JOIN properties AS pr ON pp.property_id = pr.id
INNER JOIN property_values AS pv ON pp.property_value_id = pv.id
WHERE p.id IN
    (SELECT p.id
     FROM products p
     INNER JOIN product_properties AS pp2 ON p.id = pp2.product_id
     INNER JOIN properties AS pr2 ON pp2.property_id = pr2.id
     INNER JOIN property_values AS pv2 ON pp2.property_value_id = pv2.id
     WHERE p.product_type_id IN (28)
       AND pp2.property_value_id =41
     GROUP BY p.id)
  AND pr.property_type = 'list'
GROUP BY pp.property_value_id
ORDER BY pp.property_id,
         pv.value




CREATE TABLE `products` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `full_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `article` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `description` text COLLATE utf8_unicode_ci,
 `product_type_id` int(11) DEFAULT NULL,
 `is_visible` int(11) DEFAULT NULL,
 `deleted` tinyint(4) DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `NewIndex4` (`article`) USING BTREE,
 KEY `NewIndex3` (`product_type_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10090 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `properties` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `property_type` varchar(7) COLLATE utf8_unicode_ci DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `NewIndex5` (`property_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `property_values` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `property_id` int(11) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `NewIndex1` (`property_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=508 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `product_types` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`id`),
 KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `property_values` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `property_id` int(11) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `NewIndex1` (`property_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=508 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci