| 4 |
0.16 ms |
SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort,
a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code,
a.group_sort, a.group_name_ru, a.group_name_de,
av.uid as value_id, av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('family_61','netto_gewicht_filter_4','farbgruppierung_576','farbgruppierung_587','materialgruppierung_1535','volumen_2164','verpackung_3948','serie_56072','modelname_56090','beschriftungssprache_25380','netto_gewicht_filter_5','anzahl_der_artikel_2679','modelname_56204','beschriftungssprache_25379','modelname_56203','modelname_56202','modelname_56188','modelname_56187','modelname_56186','modelname_56185','modelname_56184','modelname_56183','modelname_56182','modelname_56181','modelname_56180','modelname_56179','modelname_56167','modelname_56166','modelname_56165','modelname_56164','modelname_56163','modelname_56156','modelname_56155','modelname_56154','modelname_56153','modelname_56152','modelname_56150','modelname_56151','modelname_56149','modelname_56118','modelname_56117','modelname_56104','modelname_56103','modelname_56091','modelname_56060','beschriftungssprache_25548') AND a.is_filterable = true
SELECT
a.id as group_id,
a.code,
a.name_ru,
a.name_de,
a.sort,
a.is_metric,
a.is_deeplink,
a.is_filterable,
a.use_deeplink_code,
a.group_sort,
a.group_name_ru,
a.group_name_de,
av.uid as value_id,
av.name_ru as value_ru,
av.name_de as value_de
FROM
attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE
av.uid IN(
'family_61', 'netto_gewicht_filter_4',
'farbgruppierung_576', 'farbgruppierung_587',
'materialgruppierung_1535', 'volumen_2164',
'verpackung_3948', 'serie_56072',
'modelname_56090', 'beschriftungssprache_25380',
'netto_gewicht_filter_5', 'anzahl_der_artikel_2679',
'modelname_56204', 'beschriftungssprache_25379',
'modelname_56203', 'modelname_56202',
'modelname_56188', 'modelname_56187',
'modelname_56186', 'modelname_56185',
'modelname_56184', 'modelname_56183',
'modelname_56182', 'modelname_56181',
'modelname_56180', 'modelname_56179',
'modelname_56167', 'modelname_56166',
'modelname_56165', 'modelname_56164',
'modelname_56163', 'modelname_56156',
'modelname_56155', 'modelname_56154',
'modelname_56153', 'modelname_56152',
'modelname_56150', 'modelname_56151',
'modelname_56149', 'modelname_56118',
'modelname_56117', 'modelname_56104',
'modelname_56103', 'modelname_56091',
'modelname_56060', 'beschriftungssprache_25548'
)
AND a.is_filterable = true
SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort,
a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code,
a.group_sort, a.group_name_ru, a.group_name_de,
av.uid as value_id, av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('family_61','netto_gewicht_filter_4','farbgruppierung_576','farbgruppierung_587','materialgruppierung_1535','volumen_2164','verpackung_3948','serie_56072','modelname_56090','beschriftungssprache_25380','netto_gewicht_filter_5','anzahl_der_artikel_2679','modelname_56204','beschriftungssprache_25379','modelname_56203','modelname_56202','modelname_56188','modelname_56187','modelname_56186','modelname_56185','modelname_56184','modelname_56183','modelname_56182','modelname_56181','modelname_56180','modelname_56179','modelname_56167','modelname_56166','modelname_56165','modelname_56164','modelname_56163','modelname_56156','modelname_56155','modelname_56154','modelname_56153','modelname_56152','modelname_56150','modelname_56151','modelname_56149','modelname_56118','modelname_56117','modelname_56104','modelname_56103','modelname_56091','modelname_56060','beschriftungssprache_25548') AND a.is_filterable = true;
|