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