<b>Dotaz:</b> 
					SELECT
						V.group_id,
						V.id AS value_id,
						V.value_pl AS value_name,
						COUNT(DISTINCT R.product_id) AS cnt,
						V.color,
						V.rank AS value_rank,
						GROUP_CONCAT(DISTINCT R.product_id) AS product_ids
					FROM product_properties_values V
					INNER JOIN product_properties_related R ON R.product_properties_values_id = V.id
					INNER JOIN (
					SELECT DISTINCT P.id
					FROM product P
					LEFT JOIN product_multicategory M ON P.id = M.product_id
					WHERE
						P.active = 1
						AND (P.category_id IN (2205) OR M.category_id IN (2205))
						AND NOT EXISTS (
							SELECT 1 FROM product_multicategory PM
							WHERE PM.product_id = P.id AND PM.category_id IN (2125,2139,2140,2141,2142,2131,2132,2130,2138,2187,2194,2188,2189,2193,2190,2191,2192,2376,2196,2197,2198,2199,2200,2389)
						)
				) VP ON VP.id = R.product_id
					WHERE
						V.group_id IN (32,36,37,18,23,28,21,19,33,30,35,10)
						AND V.group_id != 32
					GROUP BY V.group_id, V.id

					UNION ALL

					SELECT
						V.group_id,
						V.id AS value_id,
						V.value_pl AS value_name,
						COUNT(DISTINCT R.product_id) AS cnt,
						V.color,
						V.rank AS value_rank,
						GROUP_CONCAT(DISTINCT R.product_id) AS product_ids
					FROM product_properties_values V
					INNER JOIN product_properties_values PPV_C ON PPV_C.related_property_value_id = V.id
					INNER JOIN product_properties_related R ON R.product_properties_values_id = PPV_C.id
					INNER JOIN (
					SELECT DISTINCT P.id
					FROM product P
					LEFT JOIN product_multicategory M ON P.id = M.product_id
					WHERE
						P.active = 1
						AND (P.category_id IN (2205) OR M.category_id IN (2205))
						AND NOT EXISTS (
							SELECT 1 FROM product_multicategory PM
							WHERE PM.product_id = P.id AND PM.category_id IN (2125,2139,2140,2141,2142,2131,2132,2130,2138,2187,2194,2188,2189,2193,2190,2191,2192,2376,2196,2197,2198,2199,2200,2389)
						)
				) VP ON VP.id = R.product_id
					WHERE
						V.group_id = 32
					GROUP BY V.group_id, V.id
					ORDER BY 1, 6, 3
				<br><b>Chyba:</b> Can't create/write to file '/tmp/#sql-temptable-717-2758329-fa5b.MAI' (Errcode: 28 "No space left on device")