| 3 |
0.14 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','coolbox_filter_0','freezebox_filter_3','family_693','art_der_suessigkeiten_34384','family_62','materialgruppierung_23844','groesse_3393','groesse_3394','modelname_22823','modelname_22824','modelname_22825','modelname_22826','modelname_22827','modelname_22828','modelname_32417','modelname_32418','modelname_32419','modelname_32420','modelname_32421','modelname_32423','modelname_32424','modelname_32425','modelname_36717','family_418','modelname_32422','netto_fuellmenge_filter_5','vendor_1240','vendor_196','vendor_267','art_der_suessigkeiten_35208','beschriftungssprache_25379','vendor_230','family_312','family_335','grossen_35939','grossen_7693','hoehe_13180','hoehe_3066','inschrift_22385','materialgruppierung_1524','materialgruppierung_1638','materialgruppierung_3960','modelname_54587','modelname_54588') 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', 'coolbox_filter_0',
'freezebox_filter_3', 'family_693',
'art_der_suessigkeiten_34384',
'family_62', 'materialgruppierung_23844',
'groesse_3393', 'groesse_3394',
'modelname_22823', 'modelname_22824',
'modelname_22825', 'modelname_22826',
'modelname_22827', 'modelname_22828',
'modelname_32417', 'modelname_32418',
'modelname_32419', 'modelname_32420',
'modelname_32421', 'modelname_32423',
'modelname_32424', 'modelname_32425',
'modelname_36717', 'family_418',
'modelname_32422', 'netto_fuellmenge_filter_5',
'vendor_1240', 'vendor_196', 'vendor_267',
'art_der_suessigkeiten_35208',
'beschriftungssprache_25379', 'vendor_230',
'family_312', 'family_335', 'grossen_35939',
'grossen_7693', 'hoehe_13180', 'hoehe_3066',
'inschrift_22385', 'materialgruppierung_1524',
'materialgruppierung_1638', 'materialgruppierung_3960',
'modelname_54587', 'modelname_54588'
)
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','coolbox_filter_0','freezebox_filter_3','family_693','art_der_suessigkeiten_34384','family_62','materialgruppierung_23844','groesse_3393','groesse_3394','modelname_22823','modelname_22824','modelname_22825','modelname_22826','modelname_22827','modelname_22828','modelname_32417','modelname_32418','modelname_32419','modelname_32420','modelname_32421','modelname_32423','modelname_32424','modelname_32425','modelname_36717','family_418','modelname_32422','netto_fuellmenge_filter_5','vendor_1240','vendor_196','vendor_267','art_der_suessigkeiten_35208','beschriftungssprache_25379','vendor_230','family_312','family_335','grossen_35939','grossen_7693','hoehe_13180','hoehe_3066','inschrift_22385','materialgruppierung_1524','materialgruppierung_1638','materialgruppierung_3960','modelname_54587','modelname_54588') AND a.is_filterable = true;
|