| 3 |
0.17 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','freezebox_filter_3','sparset_filter_0','family_376','family_1073','family_589','vendor_1258','vendor_482','vendor_1135','vendor_1016','family_699','family_629','family_886','vendor_486','vendor_186','vendor_1031','vendor_192','vendor_553','vendor_171','vendor_1133','vendor_316','vendor_743','vendor_1104','vendor_1422','vendor_414','vendor_991','vendor_1289','vendor_1297','vendor_1593','vendor_1606','vendor_552','vendor_772','netto_fuellmenge_filter_3','vendor_1483','vendor_166','vendor_274','vendor_745','netto_fuellmenge_filter_5','vendor_1018','vendor_114','vendor_1302','vendor_554','vendor_744','vendor_1138','vendor_1309','vendor_1319','vendor_1347','vendor_1440','vendor_1624','vendor_187','family_1055','netto_fuellmenge_filter_4','netto_fuellmenge_filter_6','sparset_filter_1','vendor_1091','vendor_1112','vendor_1213','vendor_1299','vendor_1354','vendor_1358','vendor_1394','vendor_1441','vendor_1461','vendor_1617','vendor_212','vendor_225','vendor_256','vendor_291','vendor_438','vendor_551','vendor_785') 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', 'freezebox_filter_3',
'sparset_filter_0', 'family_376',
'family_1073', 'family_589', 'vendor_1258',
'vendor_482', 'vendor_1135', 'vendor_1016',
'family_699', 'family_629', 'family_886',
'vendor_486', 'vendor_186', 'vendor_1031',
'vendor_192', 'vendor_553', 'vendor_171',
'vendor_1133', 'vendor_316', 'vendor_743',
'vendor_1104', 'vendor_1422', 'vendor_414',
'vendor_991', 'vendor_1289', 'vendor_1297',
'vendor_1593', 'vendor_1606', 'vendor_552',
'vendor_772', 'netto_fuellmenge_filter_3',
'vendor_1483', 'vendor_166', 'vendor_274',
'vendor_745', 'netto_fuellmenge_filter_5',
'vendor_1018', 'vendor_114', 'vendor_1302',
'vendor_554', 'vendor_744', 'vendor_1138',
'vendor_1309', 'vendor_1319', 'vendor_1347',
'vendor_1440', 'vendor_1624', 'vendor_187',
'family_1055', 'netto_fuellmenge_filter_4',
'netto_fuellmenge_filter_6', 'sparset_filter_1',
'vendor_1091', 'vendor_1112', 'vendor_1213',
'vendor_1299', 'vendor_1354', 'vendor_1358',
'vendor_1394', 'vendor_1441', 'vendor_1461',
'vendor_1617', 'vendor_212', 'vendor_225',
'vendor_256', 'vendor_291', 'vendor_438',
'vendor_551', 'vendor_785'
)
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','freezebox_filter_3','sparset_filter_0','family_376','family_1073','family_589','vendor_1258','vendor_482','vendor_1135','vendor_1016','family_699','family_629','family_886','vendor_486','vendor_186','vendor_1031','vendor_192','vendor_553','vendor_171','vendor_1133','vendor_316','vendor_743','vendor_1104','vendor_1422','vendor_414','vendor_991','vendor_1289','vendor_1297','vendor_1593','vendor_1606','vendor_552','vendor_772','netto_fuellmenge_filter_3','vendor_1483','vendor_166','vendor_274','vendor_745','netto_fuellmenge_filter_5','vendor_1018','vendor_114','vendor_1302','vendor_554','vendor_744','vendor_1138','vendor_1309','vendor_1319','vendor_1347','vendor_1440','vendor_1624','vendor_187','family_1055','netto_fuellmenge_filter_4','netto_fuellmenge_filter_6','sparset_filter_1','vendor_1091','vendor_1112','vendor_1213','vendor_1299','vendor_1354','vendor_1358','vendor_1394','vendor_1441','vendor_1461','vendor_1617','vendor_212','vendor_225','vendor_256','vendor_291','vendor_438','vendor_551','vendor_785') AND a.is_filterable = true;
|