| 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('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
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;
|