| 7 |
1.18 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('sparset_filter_0','hauttyp_351','anwendungsgebiet_30910','family_270','anwendungsgebiet_30919','netto_fuellmenge_filter_4','vendor_1040','family_491','vendor_873','anwendungsgebiet_30890','netto_fuellmenge_filter_5','family_290','haar_typ_1819','family_230','netto_fuellmenge_filter_2','serie_54623','hauttyp_355','netto_fuellmenge_filter_3','serie_54615','vendor_1393','vendor_1367','vendor_1425','family_474','vendor_1615','vendor_1209','vendor_546','anwendungsgebiet_30906','family_231','hauttyp_357','netto_fuellmenge_filter_1','anwendungsgebiet_36414','hauttyp_353','netto_fuellmenge_filter_6','serie_54613','vendor_1101','vendor_1628','vendor_876','anwendungsgebiet_53765','family_255','family_299','serie_29565','vendor_137','vendor_1434','vendor_1647','vendor_29','vendor_847','anwendungsgebiet_36174','coolbox_filter_0','family_190','family_325','family_441','family_450','family_985','form_2157','freezebox_filter_3','grossen_53509','grossen_53536','grossen_53539','hauttyp_354','inschrift_47123','materialgruppierung_1524','materialgruppierung_17837','materialgruppierung_53538','materialgruppierung_5629','serie_54616','sparset_filter_1','vendor_1042','vendor_1108','vendor_1400','vendor_469','vendor_676','vendor_878') 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(
'sparset_filter_0', 'hauttyp_351',
'anwendungsgebiet_30910', 'family_270',
'anwendungsgebiet_30919', 'netto_fuellmenge_filter_4',
'vendor_1040', 'family_491', 'vendor_873',
'anwendungsgebiet_30890', 'netto_fuellmenge_filter_5',
'family_290', 'haar_typ_1819', 'family_230',
'netto_fuellmenge_filter_2', 'serie_54623',
'hauttyp_355', 'netto_fuellmenge_filter_3',
'serie_54615', 'vendor_1393', 'vendor_1367',
'vendor_1425', 'family_474', 'vendor_1615',
'vendor_1209', 'vendor_546', 'anwendungsgebiet_30906',
'family_231', 'hauttyp_357', 'netto_fuellmenge_filter_1',
'anwendungsgebiet_36414', 'hauttyp_353',
'netto_fuellmenge_filter_6', 'serie_54613',
'vendor_1101', 'vendor_1628', 'vendor_876',
'anwendungsgebiet_53765', 'family_255',
'family_299', 'serie_29565', 'vendor_137',
'vendor_1434', 'vendor_1647', 'vendor_29',
'vendor_847', 'anwendungsgebiet_36174',
'coolbox_filter_0', 'family_190',
'family_325', 'family_441', 'family_450',
'family_985', 'form_2157', 'freezebox_filter_3',
'grossen_53509', 'grossen_53536',
'grossen_53539', 'hauttyp_354',
'inschrift_47123', 'materialgruppierung_1524',
'materialgruppierung_17837', 'materialgruppierung_53538',
'materialgruppierung_5629', 'serie_54616',
'sparset_filter_1', 'vendor_1042',
'vendor_1108', 'vendor_1400', 'vendor_469',
'vendor_676', 'vendor_878'
)
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('sparset_filter_0','hauttyp_351','anwendungsgebiet_30910','family_270','anwendungsgebiet_30919','netto_fuellmenge_filter_4','vendor_1040','family_491','vendor_873','anwendungsgebiet_30890','netto_fuellmenge_filter_5','family_290','haar_typ_1819','family_230','netto_fuellmenge_filter_2','serie_54623','hauttyp_355','netto_fuellmenge_filter_3','serie_54615','vendor_1393','vendor_1367','vendor_1425','family_474','vendor_1615','vendor_1209','vendor_546','anwendungsgebiet_30906','family_231','hauttyp_357','netto_fuellmenge_filter_1','anwendungsgebiet_36414','hauttyp_353','netto_fuellmenge_filter_6','serie_54613','vendor_1101','vendor_1628','vendor_876','anwendungsgebiet_53765','family_255','family_299','serie_29565','vendor_137','vendor_1434','vendor_1647','vendor_29','vendor_847','anwendungsgebiet_36174','coolbox_filter_0','family_190','family_325','family_441','family_450','family_985','form_2157','freezebox_filter_3','grossen_53509','grossen_53536','grossen_53539','hauttyp_354','inschrift_47123','materialgruppierung_1524','materialgruppierung_17837','materialgruppierung_53538','materialgruppierung_5629','serie_54616','sparset_filter_1','vendor_1042','vendor_1108','vendor_1400','vendor_469','vendor_676','vendor_878') AND a.is_filterable = true;
|