3
1.32 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' , 'sparset_filter_0' , 'freezebox_filter_3' , 'family_688' , 'freezebox_filter_2' , 'family_1002' , 'family_999' , 'family_711' , 'family_687' , 'vendor_531' , 'vendor_895' , 'family_1228' , 'vendor_196' , 'vendor_458' , 'vendor_897' , 'vendor_156' , 'vendor_380' , 'family_1280' , 'family_754' , 'family_757' , 'vendor_114' , 'vendor_1226' , 'vendor_178' , 'vendor_424' , 'vendor_1106' , 'vendor_759' , 'family_1249' , 'sparset_filter_1' , 'vendor_1459' , 'vendor_861' , 'family_1000' , 'family_1036' , 'vendor_111' , 'vendor_1310' , 'vendor_1337' , 'vendor_149' , 'family_1209' , 'vendor_1409' , 'vendor_1595' , 'vendor_386' , 'family_756' , 'serie_51965' , 'vendor_1145' , 'vendor_1207' , 'vendor_1241' , 'vendor_1261' , 'vendor_1277' , 'vendor_1456' , 'vendor_158' , 'vendor_164' , 'vendor_179' , 'vendor_309' , 'vendor_409' , 'vendor_579' , 'vendor_834' , 'family_1279' , 'family_695' , 'vendor_1298' , 'vendor_1435' , 'vendor_1458' , 'vendor_1582' , 'vendor_1641' , 'vendor_171' , 'vendor_216' , 'vendor_224' , 'vendor_251' , 'vendor_404' , 'vendor_457' , 'vendor_577' , 'vendor_582' , 'serie_53680' , 'serie_55666' , 'vendor_1049' , 'vendor_1077' , 'vendor_112' , 'vendor_1232' , 'vendor_1240' , 'vendor_1276' , 'vendor_1281' , 'vendor_1331' , 'vendor_1590' , 'vendor_1610' , 'vendor_166' , 'vendor_581' , 'vendor_637' , 'vendor_984' , 'coolbox_filter_1' , 'family_1167' , 'family_770' , 'serie_54773' , 'serie_55669' , 'vendor_1072' , 'vendor_1075' , 'vendor_1206' , 'vendor_1214' , 'vendor_1280' , 'vendor_134' , 'vendor_135' , 'vendor_1351' , 'vendor_1489' , 'vendor_1531' , 'vendor_1547' , 'vendor_200' , 'vendor_271' , 'vendor_336' , 'vendor_408' , 'vendor_437' , 'vendor_786' , 'vendor_845' , 'vendor_919' , 'vendor_954' , 'vendor_979' , 'vendor_980' ) 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' , 'sparset_filter_0' ,
'freezebox_filter_3' , 'family_688' ,
'freezebox_filter_2' , 'family_1002' ,
'family_999' , 'family_711' , 'family_687' ,
'vendor_531' , 'vendor_895' , 'family_1228' ,
'vendor_196' , 'vendor_458' , 'vendor_897' ,
'vendor_156' , 'vendor_380' , 'family_1280' ,
'family_754' , 'family_757' , 'vendor_114' ,
'vendor_1226' , 'vendor_178' , 'vendor_424' ,
'vendor_1106' , 'vendor_759' , 'family_1249' ,
'sparset_filter_1' , 'vendor_1459' ,
'vendor_861' , 'family_1000' , 'family_1036' ,
'vendor_111' , 'vendor_1310' , 'vendor_1337' ,
'vendor_149' , 'family_1209' , 'vendor_1409' ,
'vendor_1595' , 'vendor_386' , 'family_756' ,
'serie_51965' , 'vendor_1145' , 'vendor_1207' ,
'vendor_1241' , 'vendor_1261' , 'vendor_1277' ,
'vendor_1456' , 'vendor_158' , 'vendor_164' ,
'vendor_179' , 'vendor_309' , 'vendor_409' ,
'vendor_579' , 'vendor_834' , 'family_1279' ,
'family_695' , 'vendor_1298' , 'vendor_1435' ,
'vendor_1458' , 'vendor_1582' , 'vendor_1641' ,
'vendor_171' , 'vendor_216' , 'vendor_224' ,
'vendor_251' , 'vendor_404' , 'vendor_457' ,
'vendor_577' , 'vendor_582' , 'serie_53680' ,
'serie_55666' , 'vendor_1049' , 'vendor_1077' ,
'vendor_112' , 'vendor_1232' , 'vendor_1240' ,
'vendor_1276' , 'vendor_1281' , 'vendor_1331' ,
'vendor_1590' , 'vendor_1610' , 'vendor_166' ,
'vendor_581' , 'vendor_637' , 'vendor_984' ,
'coolbox_filter_1' , 'family_1167' ,
'family_770' , 'serie_54773' , 'serie_55669' ,
'vendor_1072' , 'vendor_1075' , 'vendor_1206' ,
'vendor_1214' , 'vendor_1280' , 'vendor_134' ,
'vendor_135' , 'vendor_1351' , 'vendor_1489' ,
'vendor_1531' , 'vendor_1547' , 'vendor_200' ,
'vendor_271' , 'vendor_336' , 'vendor_408' ,
'vendor_437' , 'vendor_786' , 'vendor_845' ,
'vendor_919' , 'vendor_954' , 'vendor_979' ,
'vendor_980'
)
AND a . is_filterable = true
Copy
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' , 'sparset_filter_0' , 'freezebox_filter_3' , 'family_688' , 'freezebox_filter_2' , 'family_1002' , 'family_999' , 'family_711' , 'family_687' , 'vendor_531' , 'vendor_895' , 'family_1228' , 'vendor_196' , 'vendor_458' , 'vendor_897' , 'vendor_156' , 'vendor_380' , 'family_1280' , 'family_754' , 'family_757' , 'vendor_114' , 'vendor_1226' , 'vendor_178' , 'vendor_424' , 'vendor_1106' , 'vendor_759' , 'family_1249' , 'sparset_filter_1' , 'vendor_1459' , 'vendor_861' , 'family_1000' , 'family_1036' , 'vendor_111' , 'vendor_1310' , 'vendor_1337' , 'vendor_149' , 'family_1209' , 'vendor_1409' , 'vendor_1595' , 'vendor_386' , 'family_756' , 'serie_51965' , 'vendor_1145' , 'vendor_1207' , 'vendor_1241' , 'vendor_1261' , 'vendor_1277' , 'vendor_1456' , 'vendor_158' , 'vendor_164' , 'vendor_179' , 'vendor_309' , 'vendor_409' , 'vendor_579' , 'vendor_834' , 'family_1279' , 'family_695' , 'vendor_1298' , 'vendor_1435' , 'vendor_1458' , 'vendor_1582' , 'vendor_1641' , 'vendor_171' , 'vendor_216' , 'vendor_224' , 'vendor_251' , 'vendor_404' , 'vendor_457' , 'vendor_577' , 'vendor_582' , 'serie_53680' , 'serie_55666' , 'vendor_1049' , 'vendor_1077' , 'vendor_112' , 'vendor_1232' , 'vendor_1240' , 'vendor_1276' , 'vendor_1281' , 'vendor_1331' , 'vendor_1590' , 'vendor_1610' , 'vendor_166' , 'vendor_581' , 'vendor_637' , 'vendor_984' , 'coolbox_filter_1' , 'family_1167' , 'family_770' , 'serie_54773' , 'serie_55669' , 'vendor_1072' , 'vendor_1075' , 'vendor_1206' , 'vendor_1214' , 'vendor_1280' , 'vendor_134' , 'vendor_135' , 'vendor_1351' , 'vendor_1489' , 'vendor_1531' , 'vendor_1547' , 'vendor_200' , 'vendor_271' , 'vendor_336' , 'vendor_408' , 'vendor_437' , 'vendor_786' , 'vendor_845' , 'vendor_919' , 'vendor_954' , 'vendor_979' , 'vendor_980' ) AND a . is_filterable = true ;
Copy