| 3 |
0.15 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('coolbox_filter_0','family_693','freezebox_filter_3','verpackung_2954','netto_gewicht_filter_3','art_der_suessigkeiten_34384','fuellung_36388','art_2163','netto_gewicht_filter_4','feiertage_819','art_der_suessigkeiten_40018','art_der_suessigkeiten_35208','geschmack_26932','geschmack_29765','vendor_156','art_der_suessigkeiten_34102','feiertage_820','feiertage_825','fuellung_54431','netto_gewicht_filter_5','vendor_1597','feiertage_960','fuellung_36365','fuellung_46951','fuellung_52241','fuellung_55934','geschmack_23759','geschmack_23761','geschmack_23766','geschmack_23781','geschmack_31753','vendor_1292','vendor_152','vendor_1568','vendor_196','verpackung_4003','feiertage_1130','fuellung_39832','fuellung_52550','fuellung_52598','geschmack_23757','geschmack_26602','geschmack_29768','vendor_265','vendor_685','art_der_suessigkeiten_39991','fuellung_39651','geschmack_23762','geschmack_23783','geschmack_36384','geschmack_39002','serie_33808','vendor_1520','vendor_162','vendor_216','vendor_441','vendor_881','vendor_923','aroma_17796','art_56940','art_56994','art_der_suessigkeiten_36995','art_der_suessigkeiten_39611','art_der_suessigkeiten_40113','fuellung_36847','fuellung_42734','geschmack_23747','geschmack_23765','geschmack_25688','geschmack_26600','geschmack_26604','geschmack_26607','geschmack_39945','vendor_1240','vendor_135','vendor_1409','vendor_1433','vendor_1532','vendor_158','vendor_1582','vendor_230','vendor_236','vendor_267','vendor_531','vendor_695','vendor_896','verpackung_3154') 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(
'coolbox_filter_0', 'family_693',
'freezebox_filter_3', 'verpackung_2954',
'netto_gewicht_filter_3', 'art_der_suessigkeiten_34384',
'fuellung_36388', 'art_2163', 'netto_gewicht_filter_4',
'feiertage_819', 'art_der_suessigkeiten_40018',
'art_der_suessigkeiten_35208',
'geschmack_26932', 'geschmack_29765',
'vendor_156', 'art_der_suessigkeiten_34102',
'feiertage_820', 'feiertage_825',
'fuellung_54431', 'netto_gewicht_filter_5',
'vendor_1597', 'feiertage_960',
'fuellung_36365', 'fuellung_46951',
'fuellung_52241', 'fuellung_55934',
'geschmack_23759', 'geschmack_23761',
'geschmack_23766', 'geschmack_23781',
'geschmack_31753', 'vendor_1292',
'vendor_152', 'vendor_1568', 'vendor_196',
'verpackung_4003', 'feiertage_1130',
'fuellung_39832', 'fuellung_52550',
'fuellung_52598', 'geschmack_23757',
'geschmack_26602', 'geschmack_29768',
'vendor_265', 'vendor_685', 'art_der_suessigkeiten_39991',
'fuellung_39651', 'geschmack_23762',
'geschmack_23783', 'geschmack_36384',
'geschmack_39002', 'serie_33808',
'vendor_1520', 'vendor_162', 'vendor_216',
'vendor_441', 'vendor_881', 'vendor_923',
'aroma_17796', 'art_56940', 'art_56994',
'art_der_suessigkeiten_36995',
'art_der_suessigkeiten_39611',
'art_der_suessigkeiten_40113',
'fuellung_36847', 'fuellung_42734',
'geschmack_23747', 'geschmack_23765',
'geschmack_25688', 'geschmack_26600',
'geschmack_26604', 'geschmack_26607',
'geschmack_39945', 'vendor_1240',
'vendor_135', 'vendor_1409', 'vendor_1433',
'vendor_1532', 'vendor_158', 'vendor_1582',
'vendor_230', 'vendor_236', 'vendor_267',
'vendor_531', 'vendor_695', 'vendor_896',
'verpackung_3154'
)
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('coolbox_filter_0','family_693','freezebox_filter_3','verpackung_2954','netto_gewicht_filter_3','art_der_suessigkeiten_34384','fuellung_36388','art_2163','netto_gewicht_filter_4','feiertage_819','art_der_suessigkeiten_40018','art_der_suessigkeiten_35208','geschmack_26932','geschmack_29765','vendor_156','art_der_suessigkeiten_34102','feiertage_820','feiertage_825','fuellung_54431','netto_gewicht_filter_5','vendor_1597','feiertage_960','fuellung_36365','fuellung_46951','fuellung_52241','fuellung_55934','geschmack_23759','geschmack_23761','geschmack_23766','geschmack_23781','geschmack_31753','vendor_1292','vendor_152','vendor_1568','vendor_196','verpackung_4003','feiertage_1130','fuellung_39832','fuellung_52550','fuellung_52598','geschmack_23757','geschmack_26602','geschmack_29768','vendor_265','vendor_685','art_der_suessigkeiten_39991','fuellung_39651','geschmack_23762','geschmack_23783','geschmack_36384','geschmack_39002','serie_33808','vendor_1520','vendor_162','vendor_216','vendor_441','vendor_881','vendor_923','aroma_17796','art_56940','art_56994','art_der_suessigkeiten_36995','art_der_suessigkeiten_39611','art_der_suessigkeiten_40113','fuellung_36847','fuellung_42734','geschmack_23747','geschmack_23765','geschmack_25688','geschmack_26600','geschmack_26604','geschmack_26607','geschmack_39945','vendor_1240','vendor_135','vendor_1409','vendor_1433','vendor_1532','vendor_158','vendor_1582','vendor_230','vendor_236','vendor_267','vendor_531','vendor_695','vendor_896','verpackung_3154') AND a.is_filterable = true;
|