| 3 |
0.39 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','family_693','freezebox_filter_2','family_491','art_der_suessigkeiten_40113','coolbox_filter_1','netto_fuellmenge_filter_3','art_der_suessigkeiten_34384','hauttyp_351','vendor_1661','anwendungsgebiet_30906','anwendungsgebiet_30890','fleischart_15470','haar_typ_1819','vendor_1659','vendor_380','anwendungsgebiet_30910','haar_typ_1823','serie_57779','vendor_531','vendor_873','family_1002','family_880','laenderkueche_36352','netto_fuellmenge_filter_4','vendor_1373','family_1152','family_1220','family_1228','family_1254','family_1275','family_688','family_850','family_921','family_970','fleischart_15474','laenderkueche_43012','modelname_40223','vendor_966','art_der_suessigkeiten_40017','art_der_suessigkeiten_40018','family_1072','family_1213','family_1291','family_526','family_689','family_760','family_935','family_981','fischart_53820','fischart_54823','getreideart_15473','hauttyp_2285','hauttyp_355','hauttyp_357','netto_fuellmenge_filter_1','netto_fuellmenge_filter_2','netto_fuellmenge_filter_5','teigwarenart_25243','vendor_1226','vendor_1276','vendor_1313','vendor_1476','vendor_1573','vendor_1658','vendor_224','vendor_29','vendor_489','vendor_944','anwendungsgebiet_30918','anwendungsgebiet_44681','art_der_suessigkeiten_34102','art_der_suessigkeiten_35208','art_der_suessigkeiten_42806','art_der_suessigkeiten_52757','family_1033','family_1035','family_1043','family_1044','family_1065','family_1074','family_1078','family_1101','family_1211','family_1226','family_1232','family_1233','family_1260','family_1286','family_214','family_216','family_222','family_289','family_376','family_577','family_60','family_683','family_699','family_754','family_922','family_926','family_932','family_999','fischart_29999','fischart_43325','fleischart_47119','fleischart_47539','grossen_13213','hauttyp_353','hoehe_7382','laenderkueche_36350','laenge_57741','materialgruppierung_1520','materialgruppierung_25881','sparset_filter_1','stahldicke_4087','vendor_1077','vendor_1140','vendor_116','vendor_1183','vendor_1300','vendor_1317','vendor_1372','vendor_1390','vendor_1395','vendor_1406','vendor_1434','vendor_1463','vendor_1472','vendor_1483','vendor_1540','vendor_1596','vendor_1608','vendor_1613','vendor_1617','vendor_1619','vendor_1660','vendor_1662','vendor_1663','vendor_1664','vendor_196','vendor_216','vendor_230','vendor_231','vendor_274','vendor_386','vendor_458','vendor_46','vendor_477','vendor_511','vendor_529','vendor_681','vendor_750','vendor_767','vendor_861','vendor_881','vendor_910','vendor_958') 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',
'family_693',
'freezebox_filter_2',
'family_491',
'art_der_suessigkeiten_40113',
'coolbox_filter_1',
'netto_fuellmenge_filter_3',
'art_der_suessigkeiten_34384',
'hauttyp_351',
'vendor_1661',
'anwendungsgebiet_30906',
'anwendungsgebiet_30890',
'fleischart_15470',
'haar_typ_1819',
'vendor_1659',
'vendor_380',
'anwendungsgebiet_30910',
'haar_typ_1823',
'serie_57779',
'vendor_531',
'vendor_873',
'family_1002',
'family_880',
'laenderkueche_36352',
'netto_fuellmenge_filter_4',
'vendor_1373',
'family_1152',
'family_1220',
'family_1228',
'family_1254',
'family_1275',
'family_688',
'family_850',
'family_921',
'family_970',
'fleischart_15474',
'laenderkueche_43012',
'modelname_40223',
'vendor_966',
'art_der_suessigkeiten_40017',
'art_der_suessigkeiten_40018',
'family_1072',
'family_1213',
'family_1291',
'family_526',
'family_689',
'family_760',
'family_935',
'family_981',
'fischart_53820',
'fischart_54823',
'getreideart_15473',
'hauttyp_2285',
'hauttyp_355',
'hauttyp_357',
'netto_fuellmenge_filter_1',
'netto_fuellmenge_filter_2',
'netto_fuellmenge_filter_5',
'teigwarenart_25243',
'vendor_1226',
'vendor_1276',
'vendor_1313',
'vendor_1476',
'vendor_1573',
'vendor_1658',
'vendor_224',
'vendor_29',
'vendor_489',
'vendor_944',
'anwendungsgebiet_30918',
'anwendungsgebiet_44681',
'art_der_suessigkeiten_34102',
'art_der_suessigkeiten_35208',
'art_der_suessigkeiten_42806',
'art_der_suessigkeiten_52757',
'family_1033',
'family_1035',
'family_1043',
'family_1044',
'family_1065',
'family_1074',
'family_1078',
'family_1101',
'family_1211',
'family_1226',
'family_1232',
'family_1233',
'family_1260',
'family_1286',
'family_214',
'family_216',
'family_222',
'family_289',
'family_376',
'family_577',
'family_60',
'family_683',
'family_699',
'family_754',
'family_922',
'family_926',
'family_932',
'family_999',
'fischart_29999',
'fischart_43325',
'fleischart_47119',
'fleischart_47539',
'grossen_13213',
'hauttyp_353',
'hoehe_7382',
'laenderkueche_36350',
'laenge_57741',
'materialgruppierung_1520',
'materialgruppierung_25881',
'sparset_filter_1',
'stahldicke_4087',
'vendor_1077',
'vendor_1140',
'vendor_116',
'vendor_1183',
'vendor_1300',
'vendor_1317',
'vendor_1372',
'vendor_1390',
'vendor_1395',
'vendor_1406',
'vendor_1434',
'vendor_1463',
'vendor_1472',
'vendor_1483',
'vendor_1540',
'vendor_1596',
'vendor_1608',
'vendor_1613',
'vendor_1617',
'vendor_1619',
'vendor_1660',
'vendor_1662',
'vendor_1663',
'vendor_1664',
'vendor_196',
'vendor_216',
'vendor_230',
'vendor_231',
'vendor_274',
'vendor_386',
'vendor_458',
'vendor_46',
'vendor_477',
'vendor_511',
'vendor_529',
'vendor_681',
'vendor_750',
'vendor_767',
'vendor_861',
'vendor_881',
'vendor_910',
'vendor_958'
)
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','family_693','freezebox_filter_2','family_491','art_der_suessigkeiten_40113','coolbox_filter_1','netto_fuellmenge_filter_3','art_der_suessigkeiten_34384','hauttyp_351','vendor_1661','anwendungsgebiet_30906','anwendungsgebiet_30890','fleischart_15470','haar_typ_1819','vendor_1659','vendor_380','anwendungsgebiet_30910','haar_typ_1823','serie_57779','vendor_531','vendor_873','family_1002','family_880','laenderkueche_36352','netto_fuellmenge_filter_4','vendor_1373','family_1152','family_1220','family_1228','family_1254','family_1275','family_688','family_850','family_921','family_970','fleischart_15474','laenderkueche_43012','modelname_40223','vendor_966','art_der_suessigkeiten_40017','art_der_suessigkeiten_40018','family_1072','family_1213','family_1291','family_526','family_689','family_760','family_935','family_981','fischart_53820','fischart_54823','getreideart_15473','hauttyp_2285','hauttyp_355','hauttyp_357','netto_fuellmenge_filter_1','netto_fuellmenge_filter_2','netto_fuellmenge_filter_5','teigwarenart_25243','vendor_1226','vendor_1276','vendor_1313','vendor_1476','vendor_1573','vendor_1658','vendor_224','vendor_29','vendor_489','vendor_944','anwendungsgebiet_30918','anwendungsgebiet_44681','art_der_suessigkeiten_34102','art_der_suessigkeiten_35208','art_der_suessigkeiten_42806','art_der_suessigkeiten_52757','family_1033','family_1035','family_1043','family_1044','family_1065','family_1074','family_1078','family_1101','family_1211','family_1226','family_1232','family_1233','family_1260','family_1286','family_214','family_216','family_222','family_289','family_376','family_577','family_60','family_683','family_699','family_754','family_922','family_926','family_932','family_999','fischart_29999','fischart_43325','fleischart_47119','fleischart_47539','grossen_13213','hauttyp_353','hoehe_7382','laenderkueche_36350','laenge_57741','materialgruppierung_1520','materialgruppierung_25881','sparset_filter_1','stahldicke_4087','vendor_1077','vendor_1140','vendor_116','vendor_1183','vendor_1300','vendor_1317','vendor_1372','vendor_1390','vendor_1395','vendor_1406','vendor_1434','vendor_1463','vendor_1472','vendor_1483','vendor_1540','vendor_1596','vendor_1608','vendor_1613','vendor_1617','vendor_1619','vendor_1660','vendor_1662','vendor_1663','vendor_1664','vendor_196','vendor_216','vendor_230','vendor_231','vendor_274','vendor_386','vendor_458','vendor_46','vendor_477','vendor_511','vendor_529','vendor_681','vendor_750','vendor_767','vendor_861','vendor_881','vendor_910','vendor_958') AND a.is_filterable = true;
|