| 7 |
1.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('sparset_filter_0','coolbox_filter_0','freezebox_filter_3','family_693','materialgruppierung_23844','art_der_suessigkeiten_34384','family_62','groesse_3393','groesse_3394','family_65','inschrift_23487','art_der_suessigkeiten_35208','family_184','groesse_4188','inschrift_23488','materialgruppierung_33495','vendor_1240','vendor_267','family_61','groesse_35132','groesse_35133','hoehe_3085','materialgruppierung_1535','vendor_196','vendor_230','art_der_suessigkeiten_34102','beschriftungssprache_25379','einsatz_2579','family_127','family_27','family_370','family_376','form_2154','groesse_1011','groesse_13435','groesse_14207','grossen_17913','grossen_7626','laenge_2596','laenge_2597','legierung_1281','materialgruppierung_1527','materialgruppierung_1551','materialgruppierung_2386','modelname_24471','modelname_24661','modelname_25333','modelname_25372','modelname_25373','modelname_32492','modelname_32508','modelname_32519','modelname_36719','modelname_36773','modelname_40158','modelname_40160','modelname_40162','modelname_41231','modelname_41234','modelname_41235','modelname_46301','modelname_52072','muster_7594','serie_36315','serie_36641','vendor_134','vendor_156','vendor_216','vendor_316','vendor_394','vendor_923','weberei_46622') 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',
'materialgruppierung_23844', 'art_der_suessigkeiten_34384',
'family_62', 'groesse_3393', 'groesse_3394',
'family_65', 'inschrift_23487',
'art_der_suessigkeiten_35208',
'family_184', 'groesse_4188', 'inschrift_23488',
'materialgruppierung_33495', 'vendor_1240',
'vendor_267', 'family_61', 'groesse_35132',
'groesse_35133', 'hoehe_3085', 'materialgruppierung_1535',
'vendor_196', 'vendor_230', 'art_der_suessigkeiten_34102',
'beschriftungssprache_25379', 'einsatz_2579',
'family_127', 'family_27', 'family_370',
'family_376', 'form_2154', 'groesse_1011',
'groesse_13435', 'groesse_14207',
'grossen_17913', 'grossen_7626',
'laenge_2596', 'laenge_2597', 'legierung_1281',
'materialgruppierung_1527', 'materialgruppierung_1551',
'materialgruppierung_2386', 'modelname_24471',
'modelname_24661', 'modelname_25333',
'modelname_25372', 'modelname_25373',
'modelname_32492', 'modelname_32508',
'modelname_32519', 'modelname_36719',
'modelname_36773', 'modelname_40158',
'modelname_40160', 'modelname_40162',
'modelname_41231', 'modelname_41234',
'modelname_41235', 'modelname_46301',
'modelname_52072', 'muster_7594',
'serie_36315', 'serie_36641', 'vendor_134',
'vendor_156', 'vendor_216', 'vendor_316',
'vendor_394', 'vendor_923', 'weberei_46622'
)
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','materialgruppierung_23844','art_der_suessigkeiten_34384','family_62','groesse_3393','groesse_3394','family_65','inschrift_23487','art_der_suessigkeiten_35208','family_184','groesse_4188','inschrift_23488','materialgruppierung_33495','vendor_1240','vendor_267','family_61','groesse_35132','groesse_35133','hoehe_3085','materialgruppierung_1535','vendor_196','vendor_230','art_der_suessigkeiten_34102','beschriftungssprache_25379','einsatz_2579','family_127','family_27','family_370','family_376','form_2154','groesse_1011','groesse_13435','groesse_14207','grossen_17913','grossen_7626','laenge_2596','laenge_2597','legierung_1281','materialgruppierung_1527','materialgruppierung_1551','materialgruppierung_2386','modelname_24471','modelname_24661','modelname_25333','modelname_25372','modelname_25373','modelname_32492','modelname_32508','modelname_32519','modelname_36719','modelname_36773','modelname_40158','modelname_40160','modelname_40162','modelname_41231','modelname_41234','modelname_41235','modelname_46301','modelname_52072','muster_7594','serie_36315','serie_36641','vendor_134','vendor_156','vendor_216','vendor_316','vendor_394','vendor_923','weberei_46622') AND a.is_filterable = true;
|