| 3 |
0.22 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','family_688','freezebox_filter_3','verpackung_2870','netto_gewicht_filter_3','netto_gewicht_filter_4','art_29796','vendor_424','art_55436','art_2163','art_36372','geschmack_26932','verpackung_2954','art_29791','art_29786','geschmack_23765','art_29787','geschmack_26601','geschmack_23761','netto_gewicht_filter_2','netto_gewicht_filter_5','verpackung_3948','netto_gewicht_filter_6','vendor_156','fuellung_36365','vendor_1241','geschmack_36384','vendor_458','vendor_573','fuellung_53397','geschmack_36155','verpackung_3121','art_39627','geschmack_23757','art_29789','vendor_216','vendor_579','verpackung_4003','art_29788','art_29792','geschmack_23753','vendor_1409','vendor_531','vendor_582','fuellung_39590','fuellung_51760','geschmack_23762','geschmack_23781','vendor_1207','vendor_1435','vendor_149','vendor_196','vendor_897','verpackung_9455','fuellung_36847','geschmack_25688','geschmack_36009','serie_51965','vendor_1106','vendor_1327','vendor_1489','vendor_494','vendor_566','art_54636','fuellung_29777','fuellung_36364','fuellung_54104','geschmack_26600','geschmack_29768','netto_gewicht_filter_1','vendor_1075','vendor_1459','vendor_380','vendor_577','vendor_834','art_55667','fuellung_39485','fuellung_39647','fuellung_51734','fuellung_55123','geschmack_23774','geschmack_29765','geschmack_32270','geschmack_35867','geschmack_36380','geschmack_36381','geschmack_39953','geschmack_45116','geschmack_54709','serie_55666','vendor_1428','fuellung_39488','fuellung_39651','fuellung_39832','fuellung_46951','fuellung_48937','fuellung_51969','fuellung_54682','fuellung_55284','geschmack_23747','geschmack_23754','geschmack_23756','geschmack_23758','geschmack_23769','geschmack_26331','geschmack_26612','geschmack_26964','geschmack_31753','geschmack_35745','geschmack_36851','geschmack_42730','geschmack_47953','geschmack_52741','vendor_114','vendor_1206','vendor_1214','vendor_134','vendor_1382','vendor_1453','vendor_164','vendor_166','vendor_171','vendor_179','vendor_271','vendor_305','vendor_437','vendor_580','vendor_759','vendor_923','vendor_954','verpackung_14402') 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',
'family_688',
'freezebox_filter_3',
'verpackung_2870',
'netto_gewicht_filter_3',
'netto_gewicht_filter_4',
'art_29796',
'vendor_424',
'art_55436',
'art_2163',
'art_36372',
'geschmack_26932',
'verpackung_2954',
'art_29791',
'art_29786',
'geschmack_23765',
'art_29787',
'geschmack_26601',
'geschmack_23761',
'netto_gewicht_filter_2',
'netto_gewicht_filter_5',
'verpackung_3948',
'netto_gewicht_filter_6',
'vendor_156',
'fuellung_36365',
'vendor_1241',
'geschmack_36384',
'vendor_458',
'vendor_573',
'fuellung_53397',
'geschmack_36155',
'verpackung_3121',
'art_39627',
'geschmack_23757',
'art_29789',
'vendor_216',
'vendor_579',
'verpackung_4003',
'art_29788',
'art_29792',
'geschmack_23753',
'vendor_1409',
'vendor_531',
'vendor_582',
'fuellung_39590',
'fuellung_51760',
'geschmack_23762',
'geschmack_23781',
'vendor_1207',
'vendor_1435',
'vendor_149',
'vendor_196',
'vendor_897',
'verpackung_9455',
'fuellung_36847',
'geschmack_25688',
'geschmack_36009',
'serie_51965',
'vendor_1106',
'vendor_1327',
'vendor_1489',
'vendor_494',
'vendor_566',
'art_54636',
'fuellung_29777',
'fuellung_36364',
'fuellung_54104',
'geschmack_26600',
'geschmack_29768',
'netto_gewicht_filter_1',
'vendor_1075',
'vendor_1459',
'vendor_380',
'vendor_577',
'vendor_834',
'art_55667',
'fuellung_39485',
'fuellung_39647',
'fuellung_51734',
'fuellung_55123',
'geschmack_23774',
'geschmack_29765',
'geschmack_32270',
'geschmack_35867',
'geschmack_36380',
'geschmack_36381',
'geschmack_39953',
'geschmack_45116',
'geschmack_54709',
'serie_55666',
'vendor_1428',
'fuellung_39488',
'fuellung_39651',
'fuellung_39832',
'fuellung_46951',
'fuellung_48937',
'fuellung_51969',
'fuellung_54682',
'fuellung_55284',
'geschmack_23747',
'geschmack_23754',
'geschmack_23756',
'geschmack_23758',
'geschmack_23769',
'geschmack_26331',
'geschmack_26612',
'geschmack_26964',
'geschmack_31753',
'geschmack_35745',
'geschmack_36851',
'geschmack_42730',
'geschmack_47953',
'geschmack_52741',
'vendor_114',
'vendor_1206',
'vendor_1214',
'vendor_134',
'vendor_1382',
'vendor_1453',
'vendor_164',
'vendor_166',
'vendor_171',
'vendor_179',
'vendor_271',
'vendor_305',
'vendor_437',
'vendor_580',
'vendor_759',
'vendor_923',
'vendor_954',
'verpackung_14402'
)
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','family_688','freezebox_filter_3','verpackung_2870','netto_gewicht_filter_3','netto_gewicht_filter_4','art_29796','vendor_424','art_55436','art_2163','art_36372','geschmack_26932','verpackung_2954','art_29791','art_29786','geschmack_23765','art_29787','geschmack_26601','geschmack_23761','netto_gewicht_filter_2','netto_gewicht_filter_5','verpackung_3948','netto_gewicht_filter_6','vendor_156','fuellung_36365','vendor_1241','geschmack_36384','vendor_458','vendor_573','fuellung_53397','geschmack_36155','verpackung_3121','art_39627','geschmack_23757','art_29789','vendor_216','vendor_579','verpackung_4003','art_29788','art_29792','geschmack_23753','vendor_1409','vendor_531','vendor_582','fuellung_39590','fuellung_51760','geschmack_23762','geschmack_23781','vendor_1207','vendor_1435','vendor_149','vendor_196','vendor_897','verpackung_9455','fuellung_36847','geschmack_25688','geschmack_36009','serie_51965','vendor_1106','vendor_1327','vendor_1489','vendor_494','vendor_566','art_54636','fuellung_29777','fuellung_36364','fuellung_54104','geschmack_26600','geschmack_29768','netto_gewicht_filter_1','vendor_1075','vendor_1459','vendor_380','vendor_577','vendor_834','art_55667','fuellung_39485','fuellung_39647','fuellung_51734','fuellung_55123','geschmack_23774','geschmack_29765','geschmack_32270','geschmack_35867','geschmack_36380','geschmack_36381','geschmack_39953','geschmack_45116','geschmack_54709','serie_55666','vendor_1428','fuellung_39488','fuellung_39651','fuellung_39832','fuellung_46951','fuellung_48937','fuellung_51969','fuellung_54682','fuellung_55284','geschmack_23747','geschmack_23754','geschmack_23756','geschmack_23758','geschmack_23769','geschmack_26331','geschmack_26612','geschmack_26964','geschmack_31753','geschmack_35745','geschmack_36851','geschmack_42730','geschmack_47953','geschmack_52741','vendor_114','vendor_1206','vendor_1214','vendor_134','vendor_1382','vendor_1453','vendor_164','vendor_166','vendor_171','vendor_179','vendor_271','vendor_305','vendor_437','vendor_580','vendor_759','vendor_923','vendor_954','verpackung_14402') AND a.is_filterable = true;
|