| 3 |
0.18 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('freezebox_filter_3','sparset_filter_0','coolbox_filter_0','family_684','laenderkueche_36352','family_683','family_685','family_1026','fleischart_15470','vendor_386','family_920','vendor_114','vendor_531','vendor_458','fleischart_47539','coolbox_filter_1','family_1044','fischart_29659','vendor_224','laenderkueche_36350','family_986','family_1027','vendor_922','family_935','fischart_29740','family_1028','family_778','fleischart_15474','fischart_29999','vendor_402','vendor_944','fischart_35526','getreideart_15473','pastete_sorten_29724','pastete_sorten_29725','serie_55241','vendor_404','vendor_728','family_1074','vendor_1179','vendor_1191','fleischart_47119','vendor_637','family_1031','netto_fuellmenge_filter_5','pastete_sorten_29718','serie_39543','vendor_1374','vendor_227','vendor_431','family_1033','family_1072','family_1270','fischart_29998','getreideart_23671','getreideart_23707','vendor_1119','vendor_834','fischart_29661','pastete_sorten_29726','vendor_1028','vendor_1160','vendor_1255','vendor_403','vendor_914','family_1030','family_1046','fischart_52914','fleischart_54889','laenderkueche_36354','laenderkueche_47654','laenderkueche_48797','vendor_1054','vendor_1355','vendor_1380','vendor_1381','vendor_477','family_1115','family_1269','family_686','fischart_29665','laenderkueche_43127','netto_fuellmenge_filter_4','vendor_1025','vendor_1035','vendor_1064','vendor_1181','vendor_1322','vendor_1372','vendor_1388','vendor_1463','vendor_151','vendor_1543','vendor_347','vendor_348','vendor_412','vendor_430','vendor_459','vendor_814','vendor_836','vendor_869','vendor_928','vendor_952','family_1034','family_1043','family_1080','family_1287','fischart_29658','fischart_29663','fischart_30000','fleischart_15475','fleischart_54883','getreideart_15476','laenderkueche_36355','laenderkueche_43129','netto_fuellmenge_filter_1','pastete_sorten_50587','sparset_filter_1','vendor_1027','vendor_118','vendor_1205','vendor_144','vendor_1477','vendor_1526','vendor_1530','vendor_1619','vendor_204','vendor_277','vendor_280','vendor_295','vendor_383','vendor_457','vendor_490','vendor_511','vendor_635','vendor_679','vendor_699','vendor_717','vendor_775','vendor_779','vendor_782','vendor_835','vendor_910','vendor_915','vendor_956','vendor_983') 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(
'freezebox_filter_3',
'sparset_filter_0',
'coolbox_filter_0',
'family_684',
'laenderkueche_36352',
'family_683',
'family_685',
'family_1026',
'fleischart_15470',
'vendor_386',
'family_920',
'vendor_114',
'vendor_531',
'vendor_458',
'fleischart_47539',
'coolbox_filter_1',
'family_1044',
'fischart_29659',
'vendor_224',
'laenderkueche_36350',
'family_986',
'family_1027',
'vendor_922',
'family_935',
'fischart_29740',
'family_1028',
'family_778',
'fleischart_15474',
'fischart_29999',
'vendor_402',
'vendor_944',
'fischart_35526',
'getreideart_15473',
'pastete_sorten_29724',
'pastete_sorten_29725',
'serie_55241',
'vendor_404',
'vendor_728',
'family_1074',
'vendor_1179',
'vendor_1191',
'fleischart_47119',
'vendor_637',
'family_1031',
'netto_fuellmenge_filter_5',
'pastete_sorten_29718',
'serie_39543',
'vendor_1374',
'vendor_227',
'vendor_431',
'family_1033',
'family_1072',
'family_1270',
'fischart_29998',
'getreideart_23671',
'getreideart_23707',
'vendor_1119',
'vendor_834',
'fischart_29661',
'pastete_sorten_29726',
'vendor_1028',
'vendor_1160',
'vendor_1255',
'vendor_403',
'vendor_914',
'family_1030',
'family_1046',
'fischart_52914',
'fleischart_54889',
'laenderkueche_36354',
'laenderkueche_47654',
'laenderkueche_48797',
'vendor_1054',
'vendor_1355',
'vendor_1380',
'vendor_1381',
'vendor_477',
'family_1115',
'family_1269',
'family_686',
'fischart_29665',
'laenderkueche_43127',
'netto_fuellmenge_filter_4',
'vendor_1025',
'vendor_1035',
'vendor_1064',
'vendor_1181',
'vendor_1322',
'vendor_1372',
'vendor_1388',
'vendor_1463',
'vendor_151',
'vendor_1543',
'vendor_347',
'vendor_348',
'vendor_412',
'vendor_430',
'vendor_459',
'vendor_814',
'vendor_836',
'vendor_869',
'vendor_928',
'vendor_952',
'family_1034',
'family_1043',
'family_1080',
'family_1287',
'fischart_29658',
'fischart_29663',
'fischart_30000',
'fleischart_15475',
'fleischart_54883',
'getreideart_15476',
'laenderkueche_36355',
'laenderkueche_43129',
'netto_fuellmenge_filter_1',
'pastete_sorten_50587',
'sparset_filter_1',
'vendor_1027',
'vendor_118',
'vendor_1205',
'vendor_144',
'vendor_1477',
'vendor_1526',
'vendor_1530',
'vendor_1619',
'vendor_204',
'vendor_277',
'vendor_280',
'vendor_295',
'vendor_383',
'vendor_457',
'vendor_490',
'vendor_511',
'vendor_635',
'vendor_679',
'vendor_699',
'vendor_717',
'vendor_775',
'vendor_779',
'vendor_782',
'vendor_835',
'vendor_910',
'vendor_915',
'vendor_956',
'vendor_983'
)
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('freezebox_filter_3','sparset_filter_0','coolbox_filter_0','family_684','laenderkueche_36352','family_683','family_685','family_1026','fleischart_15470','vendor_386','family_920','vendor_114','vendor_531','vendor_458','fleischart_47539','coolbox_filter_1','family_1044','fischart_29659','vendor_224','laenderkueche_36350','family_986','family_1027','vendor_922','family_935','fischart_29740','family_1028','family_778','fleischart_15474','fischart_29999','vendor_402','vendor_944','fischart_35526','getreideart_15473','pastete_sorten_29724','pastete_sorten_29725','serie_55241','vendor_404','vendor_728','family_1074','vendor_1179','vendor_1191','fleischart_47119','vendor_637','family_1031','netto_fuellmenge_filter_5','pastete_sorten_29718','serie_39543','vendor_1374','vendor_227','vendor_431','family_1033','family_1072','family_1270','fischart_29998','getreideart_23671','getreideart_23707','vendor_1119','vendor_834','fischart_29661','pastete_sorten_29726','vendor_1028','vendor_1160','vendor_1255','vendor_403','vendor_914','family_1030','family_1046','fischart_52914','fleischart_54889','laenderkueche_36354','laenderkueche_47654','laenderkueche_48797','vendor_1054','vendor_1355','vendor_1380','vendor_1381','vendor_477','family_1115','family_1269','family_686','fischart_29665','laenderkueche_43127','netto_fuellmenge_filter_4','vendor_1025','vendor_1035','vendor_1064','vendor_1181','vendor_1322','vendor_1372','vendor_1388','vendor_1463','vendor_151','vendor_1543','vendor_347','vendor_348','vendor_412','vendor_430','vendor_459','vendor_814','vendor_836','vendor_869','vendor_928','vendor_952','family_1034','family_1043','family_1080','family_1287','fischart_29658','fischart_29663','fischart_30000','fleischart_15475','fleischart_54883','getreideart_15476','laenderkueche_36355','laenderkueche_43129','netto_fuellmenge_filter_1','pastete_sorten_50587','sparset_filter_1','vendor_1027','vendor_118','vendor_1205','vendor_144','vendor_1477','vendor_1526','vendor_1530','vendor_1619','vendor_204','vendor_277','vendor_280','vendor_295','vendor_383','vendor_457','vendor_490','vendor_511','vendor_635','vendor_679','vendor_699','vendor_717','vendor_775','vendor_779','vendor_782','vendor_835','vendor_910','vendor_915','vendor_956','vendor_983') AND a.is_filterable = true;
|