| 3 |
0.19 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','freezebox_filter_2','coolbox_filter_1','fleischart_15470','vendor_531','family_693','art_der_suessigkeiten_34384','modelname_40223','family_1072','fleischart_15474','family_1152','fleischart_47539','art_der_suessigkeiten_40017','family_1035','family_1078','family_1275','fischart_29740','getreideart_25277','serie_51387','vendor_1298','vendor_386','art_der_suessigkeiten_40113','family_376','family_688','family_724','family_789','family_980','getreideart_23707','laenderkueche_36350','vendor_196','vendor_529','vendor_716','family_1211','family_589','family_865','family_880','family_935','family_981','fischart_29660','fischart_43299','getreideart_15473','getreideart_23671','laenderkueche_43012','vendor_1258','vendor_357','vendor_42','vendor_679','art_der_suessigkeiten_34102','art_der_suessigkeiten_40018','art_der_suessigkeiten_42806','family_1002','family_716','fischart_29659','fischart_29998','fischart_36125','fischart_37803','fischart_43320','laenderkueche_36349','vendor_1152','vendor_1373','vendor_1409','vendor_156','vendor_171','vendor_231','vendor_404','vendor_477','vendor_862','vendor_938','art_der_beeren_53100','art_der_beeren_53106','art_der_beeren_53566','art_der_suessigkeiten_36995','art_der_suessigkeiten_39611','art_der_suessigkeiten_52757','family_1026','family_1073','family_1077','family_1101','family_1120','family_1129','family_1210','family_1212','family_1213','family_1220','family_1228','family_1232','family_1233','family_1234','family_1238','family_1241','family_1253','family_1254','family_1260','family_1286','family_685','family_692','family_752','family_778','family_850','family_854','family_920','family_922','family_978','fischart_30000','fischart_37804','fischart_43293','fischart_43325','fischart_52858','fischart_54823','fischart_57425','fleischart_15475','fleischart_30153','fleischart_47119','getreideart_15480','getreideart_15481','getreideart_25279','laenderkueche_36352','netto_fuellmenge_filter_6','pastete_sorten_29724','serie_34905','serie_39534','serie_39538','serie_44880','serie_51965','teigwarenart_25243','teigwarenart_38803','vendor_1015','vendor_1020','vendor_1027','vendor_1088','vendor_1107','vendor_1125','vendor_1157','vendor_1179','vendor_1216','vendor_1232','vendor_1255','vendor_1261','vendor_1292','vendor_1318','vendor_1330','vendor_140','vendor_1406','vendor_1422','vendor_1428','vendor_1459','vendor_150','vendor_1529','vendor_154','vendor_1555','vendor_159','vendor_162','vendor_178','vendor_198','vendor_216','vendor_316','vendor_380','vendor_438','vendor_458','vendor_489','vendor_511','vendor_639','vendor_642','vendor_785','vendor_852','vendor_910','weinart_53885') 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',
'freezebox_filter_2',
'coolbox_filter_1',
'fleischart_15470',
'vendor_531',
'family_693',
'art_der_suessigkeiten_34384',
'modelname_40223',
'family_1072',
'fleischart_15474',
'family_1152',
'fleischart_47539',
'art_der_suessigkeiten_40017',
'family_1035',
'family_1078',
'family_1275',
'fischart_29740',
'getreideart_25277',
'serie_51387',
'vendor_1298',
'vendor_386',
'art_der_suessigkeiten_40113',
'family_376',
'family_688',
'family_724',
'family_789',
'family_980',
'getreideart_23707',
'laenderkueche_36350',
'vendor_196',
'vendor_529',
'vendor_716',
'family_1211',
'family_589',
'family_865',
'family_880',
'family_935',
'family_981',
'fischart_29660',
'fischart_43299',
'getreideart_15473',
'getreideart_23671',
'laenderkueche_43012',
'vendor_1258',
'vendor_357',
'vendor_42',
'vendor_679',
'art_der_suessigkeiten_34102',
'art_der_suessigkeiten_40018',
'art_der_suessigkeiten_42806',
'family_1002',
'family_716',
'fischart_29659',
'fischart_29998',
'fischart_36125',
'fischart_37803',
'fischart_43320',
'laenderkueche_36349',
'vendor_1152',
'vendor_1373',
'vendor_1409',
'vendor_156',
'vendor_171',
'vendor_231',
'vendor_404',
'vendor_477',
'vendor_862',
'vendor_938',
'art_der_beeren_53100',
'art_der_beeren_53106',
'art_der_beeren_53566',
'art_der_suessigkeiten_36995',
'art_der_suessigkeiten_39611',
'art_der_suessigkeiten_52757',
'family_1026',
'family_1073',
'family_1077',
'family_1101',
'family_1120',
'family_1129',
'family_1210',
'family_1212',
'family_1213',
'family_1220',
'family_1228',
'family_1232',
'family_1233',
'family_1234',
'family_1238',
'family_1241',
'family_1253',
'family_1254',
'family_1260',
'family_1286',
'family_685',
'family_692',
'family_752',
'family_778',
'family_850',
'family_854',
'family_920',
'family_922',
'family_978',
'fischart_30000',
'fischart_37804',
'fischart_43293',
'fischart_43325',
'fischart_52858',
'fischart_54823',
'fischart_57425',
'fleischart_15475',
'fleischart_30153',
'fleischart_47119',
'getreideart_15480',
'getreideart_15481',
'getreideart_25279',
'laenderkueche_36352',
'netto_fuellmenge_filter_6',
'pastete_sorten_29724',
'serie_34905',
'serie_39534',
'serie_39538',
'serie_44880',
'serie_51965',
'teigwarenart_25243',
'teigwarenart_38803',
'vendor_1015',
'vendor_1020',
'vendor_1027',
'vendor_1088',
'vendor_1107',
'vendor_1125',
'vendor_1157',
'vendor_1179',
'vendor_1216',
'vendor_1232',
'vendor_1255',
'vendor_1261',
'vendor_1292',
'vendor_1318',
'vendor_1330',
'vendor_140',
'vendor_1406',
'vendor_1422',
'vendor_1428',
'vendor_1459',
'vendor_150',
'vendor_1529',
'vendor_154',
'vendor_1555',
'vendor_159',
'vendor_162',
'vendor_178',
'vendor_198',
'vendor_216',
'vendor_316',
'vendor_380',
'vendor_438',
'vendor_458',
'vendor_489',
'vendor_511',
'vendor_639',
'vendor_642',
'vendor_785',
'vendor_852',
'vendor_910',
'weinart_53885'
)
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','freezebox_filter_2','coolbox_filter_1','fleischart_15470','vendor_531','family_693','art_der_suessigkeiten_34384','modelname_40223','family_1072','fleischart_15474','family_1152','fleischart_47539','art_der_suessigkeiten_40017','family_1035','family_1078','family_1275','fischart_29740','getreideart_25277','serie_51387','vendor_1298','vendor_386','art_der_suessigkeiten_40113','family_376','family_688','family_724','family_789','family_980','getreideart_23707','laenderkueche_36350','vendor_196','vendor_529','vendor_716','family_1211','family_589','family_865','family_880','family_935','family_981','fischart_29660','fischart_43299','getreideart_15473','getreideart_23671','laenderkueche_43012','vendor_1258','vendor_357','vendor_42','vendor_679','art_der_suessigkeiten_34102','art_der_suessigkeiten_40018','art_der_suessigkeiten_42806','family_1002','family_716','fischart_29659','fischart_29998','fischart_36125','fischart_37803','fischart_43320','laenderkueche_36349','vendor_1152','vendor_1373','vendor_1409','vendor_156','vendor_171','vendor_231','vendor_404','vendor_477','vendor_862','vendor_938','art_der_beeren_53100','art_der_beeren_53106','art_der_beeren_53566','art_der_suessigkeiten_36995','art_der_suessigkeiten_39611','art_der_suessigkeiten_52757','family_1026','family_1073','family_1077','family_1101','family_1120','family_1129','family_1210','family_1212','family_1213','family_1220','family_1228','family_1232','family_1233','family_1234','family_1238','family_1241','family_1253','family_1254','family_1260','family_1286','family_685','family_692','family_752','family_778','family_850','family_854','family_920','family_922','family_978','fischart_30000','fischart_37804','fischart_43293','fischart_43325','fischart_52858','fischart_54823','fischart_57425','fleischart_15475','fleischart_30153','fleischart_47119','getreideart_15480','getreideart_15481','getreideart_25279','laenderkueche_36352','netto_fuellmenge_filter_6','pastete_sorten_29724','serie_34905','serie_39534','serie_39538','serie_44880','serie_51965','teigwarenart_25243','teigwarenart_38803','vendor_1015','vendor_1020','vendor_1027','vendor_1088','vendor_1107','vendor_1125','vendor_1157','vendor_1179','vendor_1216','vendor_1232','vendor_1255','vendor_1261','vendor_1292','vendor_1318','vendor_1330','vendor_140','vendor_1406','vendor_1422','vendor_1428','vendor_1459','vendor_150','vendor_1529','vendor_154','vendor_1555','vendor_159','vendor_162','vendor_178','vendor_198','vendor_216','vendor_316','vendor_380','vendor_438','vendor_458','vendor_489','vendor_511','vendor_639','vendor_642','vendor_785','vendor_852','vendor_910','weinart_53885') AND a.is_filterable = true;
|