| 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('vendor_357','freezebox_filter_3','verpackung_4205','coolbox_filter_1','art_2163','coolbox_filter_0','family_1072','netto_gewicht_filter_4','netto_gewicht_filter_3','family_577','art_56006','netto_gewicht_filter_6','art_23066','art_56007','fischart_38548','fischart_29660','netto_gewicht_filter_2','verpackung_37215','fischart_37803','altergruppierung_54019','art_23067','family_418','feiertage_820','fischart_37812','fleischart_15470','grossen_38388','materialgruppierung_33495','typ_55466','verpackung_3948','family_1078','art_14443','family_1080','family_724','farbgruppierung_579','netto_gewicht_filter_1','netto_gewicht_filter_5','art_22724','art_22832','art_22836','art_22870','art_22876','art_39784','art_22663','art_22806','art_22810','art_22844','art_22868','art_37170','art_37171','art_7540','farbgruppierung_578','fischart_37804','geschmack_23754','verpackung_3840','art_14447','art_22813','art_22815','art_22848','art_22921','art_23546','art_37210','art_40599','family_1106','family_462','family_682','farbgruppierung_586','geschmack_23753','geschmack_23755','handelsform_5911','netto_fuellmenge_filter_2','typ_16198','verwendungszweck_9715') 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(
'vendor_357', 'freezebox_filter_3',
'verpackung_4205', 'coolbox_filter_1',
'art_2163', 'coolbox_filter_0',
'family_1072', 'netto_gewicht_filter_4',
'netto_gewicht_filter_3', 'family_577',
'art_56006', 'netto_gewicht_filter_6',
'art_23066', 'art_56007', 'fischart_38548',
'fischart_29660', 'netto_gewicht_filter_2',
'verpackung_37215', 'fischart_37803',
'altergruppierung_54019', 'art_23067',
'family_418', 'feiertage_820', 'fischart_37812',
'fleischart_15470', 'grossen_38388',
'materialgruppierung_33495', 'typ_55466',
'verpackung_3948', 'family_1078',
'art_14443', 'family_1080', 'family_724',
'farbgruppierung_579', 'netto_gewicht_filter_1',
'netto_gewicht_filter_5', 'art_22724',
'art_22832', 'art_22836', 'art_22870',
'art_22876', 'art_39784', 'art_22663',
'art_22806', 'art_22810', 'art_22844',
'art_22868', 'art_37170', 'art_37171',
'art_7540', 'farbgruppierung_578',
'fischart_37804', 'geschmack_23754',
'verpackung_3840', 'art_14447',
'art_22813', 'art_22815', 'art_22848',
'art_22921', 'art_23546', 'art_37210',
'art_40599', 'family_1106', 'family_462',
'family_682', 'farbgruppierung_586',
'geschmack_23753', 'geschmack_23755',
'handelsform_5911', 'netto_fuellmenge_filter_2',
'typ_16198', 'verwendungszweck_9715'
)
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('vendor_357','freezebox_filter_3','verpackung_4205','coolbox_filter_1','art_2163','coolbox_filter_0','family_1072','netto_gewicht_filter_4','netto_gewicht_filter_3','family_577','art_56006','netto_gewicht_filter_6','art_23066','art_56007','fischart_38548','fischart_29660','netto_gewicht_filter_2','verpackung_37215','fischart_37803','altergruppierung_54019','art_23067','family_418','feiertage_820','fischart_37812','fleischart_15470','grossen_38388','materialgruppierung_33495','typ_55466','verpackung_3948','family_1078','art_14443','family_1080','family_724','farbgruppierung_579','netto_gewicht_filter_1','netto_gewicht_filter_5','art_22724','art_22832','art_22836','art_22870','art_22876','art_39784','art_22663','art_22806','art_22810','art_22844','art_22868','art_37170','art_37171','art_7540','farbgruppierung_578','fischart_37804','geschmack_23754','verpackung_3840','art_14447','art_22813','art_22815','art_22848','art_22921','art_23546','art_37210','art_40599','family_1106','family_462','family_682','farbgruppierung_586','geschmack_23753','geschmack_23755','handelsform_5911','netto_fuellmenge_filter_2','typ_16198','verwendungszweck_9715') AND a.is_filterable = true;
|