| 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('sparset_filter_0','coolbox_filter_0','freezebox_filter_3','freezebox_filter_2','coolbox_filter_1','fleischart_15470','family_693','art_der_suessigkeiten_34384','vendor_531','family_1232','family_1078','vendor_458','family_1220','family_1152','modelname_40223','vendor_1377','family_1286','family_932','family_999','fleischart_15474','laenderkueche_36350','family_1211','vendor_42','vendor_716','art_der_suessigkeiten_34102','family_1035','family_1072','family_880','vendor_529','art_der_suessigkeiten_40017','art_der_suessigkeiten_42806','family_1275','family_716','family_1101','fischart_29660','vendor_196','vendor_380','vendor_751','vendor_860','art_der_beeren_53566','family_1169','family_1213','family_1228','family_1233','family_376','family_692','family_760','fischart_29998','laenderkueche_36349','vendor_1016','vendor_1226','vendor_134','vendor_1409','art_der_suessigkeiten_39611','art_der_suessigkeiten_40018','art_der_suessigkeiten_40113','art_der_suessigkeiten_46435','art_der_suessigkeiten_56942','family_1080','family_1106','family_1291','family_687','family_688','family_865','fleischart_47539','serie_44736','serie_44880','vendor_1179','vendor_1255','vendor_1317','vendor_1373','vendor_1549','vendor_357','vendor_489','vendor_666','vendor_752','vendor_944','art_der_beeren_53100','art_der_beeren_53103','art_der_beeren_53106','art_der_beeren_54004','art_der_beeren_54286','art_der_beeren_54717','family_1074','family_1077','family_1129','family_1225','family_1227','family_1234','family_1266','family_1279','family_686','family_854','family_922','family_981','fischart_29999','fischart_53820','fischart_54769','getreideart_23711','serie_27405','serie_39534','vendor_1015','vendor_1020','vendor_1070','vendor_1125','vendor_1152','vendor_1276','vendor_1330','vendor_1385','vendor_1458','vendor_150','vendor_1521','vendor_1555','vendor_156','vendor_1577','vendor_1598','vendor_221','vendor_223','vendor_224','vendor_404','vendor_759','vendor_862','vendor_881','vendor_910','vendor_914','art_der_beeren_54072','art_der_beeren_54397','art_der_beeren_56092','art_der_beeren_56094','art_der_beeren_56099','art_der_suessigkeiten_36995','art_der_suessigkeiten_52757','family_1043','family_1118','family_1173','family_1209','family_1212','family_1226','family_1231','family_1238','family_1246','family_1253','family_1260','family_1262','family_1265','family_462','family_594','family_689','family_711','family_771','family_866','family_886','family_980','fischart_29664','fischart_35526','fischart_36125','fischart_37803','fischart_43299','fischart_43337','fischart_52490','fischart_52914','fischart_54243','fischart_54516','fischart_56343','fischart_57685','fleischart_30153','fleischart_47119','getreideart_25277','laenderkueche_36352','laenderkueche_50808','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','netto_fuellmenge_filter_5','serie_39537','serie_39540','serie_41382','serie_53680','serie_54749','serie_54773','serie_55386','teigwarenart_25243','vendor_1025','vendor_1113','vendor_1114','vendor_1141','vendor_1153','vendor_1157','vendor_1158','vendor_1205','vendor_1206','vendor_1232','vendor_1240','vendor_1247','vendor_1262','vendor_1292','vendor_1316','vendor_1348','vendor_1357','vendor_1372','vendor_1383','vendor_1386','vendor_1394','vendor_1463','vendor_1486','vendor_1495','vendor_1506','vendor_1508','vendor_153','vendor_1547','vendor_1590','vendor_1595','vendor_1631','vendor_1648','vendor_1660','vendor_181','vendor_216','vendor_265','vendor_267','vendor_381','vendor_449','vendor_519','vendor_608','vendor_621','vendor_639','vendor_649','vendor_664','vendor_725','vendor_738','vendor_750','vendor_762','vendor_770','vendor_874','vendor_895','vendor_897','vendor_909','vendor_919','vendor_962','vendor_972','vendor_981','vendor_984','vendor_989') 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',
'family_693',
'art_der_suessigkeiten_34384',
'vendor_531',
'family_1232',
'family_1078',
'vendor_458',
'family_1220',
'family_1152',
'modelname_40223',
'vendor_1377',
'family_1286',
'family_932',
'family_999',
'fleischart_15474',
'laenderkueche_36350',
'family_1211',
'vendor_42',
'vendor_716',
'art_der_suessigkeiten_34102',
'family_1035',
'family_1072',
'family_880',
'vendor_529',
'art_der_suessigkeiten_40017',
'art_der_suessigkeiten_42806',
'family_1275',
'family_716',
'family_1101',
'fischart_29660',
'vendor_196',
'vendor_380',
'vendor_751',
'vendor_860',
'art_der_beeren_53566',
'family_1169',
'family_1213',
'family_1228',
'family_1233',
'family_376',
'family_692',
'family_760',
'fischart_29998',
'laenderkueche_36349',
'vendor_1016',
'vendor_1226',
'vendor_134',
'vendor_1409',
'art_der_suessigkeiten_39611',
'art_der_suessigkeiten_40018',
'art_der_suessigkeiten_40113',
'art_der_suessigkeiten_46435',
'art_der_suessigkeiten_56942',
'family_1080',
'family_1106',
'family_1291',
'family_687',
'family_688',
'family_865',
'fleischart_47539',
'serie_44736',
'serie_44880',
'vendor_1179',
'vendor_1255',
'vendor_1317',
'vendor_1373',
'vendor_1549',
'vendor_357',
'vendor_489',
'vendor_666',
'vendor_752',
'vendor_944',
'art_der_beeren_53100',
'art_der_beeren_53103',
'art_der_beeren_53106',
'art_der_beeren_54004',
'art_der_beeren_54286',
'art_der_beeren_54717',
'family_1074',
'family_1077',
'family_1129',
'family_1225',
'family_1227',
'family_1234',
'family_1266',
'family_1279',
'family_686',
'family_854',
'family_922',
'family_981',
'fischart_29999',
'fischart_53820',
'fischart_54769',
'getreideart_23711',
'serie_27405',
'serie_39534',
'vendor_1015',
'vendor_1020',
'vendor_1070',
'vendor_1125',
'vendor_1152',
'vendor_1276',
'vendor_1330',
'vendor_1385',
'vendor_1458',
'vendor_150',
'vendor_1521',
'vendor_1555',
'vendor_156',
'vendor_1577',
'vendor_1598',
'vendor_221',
'vendor_223',
'vendor_224',
'vendor_404',
'vendor_759',
'vendor_862',
'vendor_881',
'vendor_910',
'vendor_914',
'art_der_beeren_54072',
'art_der_beeren_54397',
'art_der_beeren_56092',
'art_der_beeren_56094',
'art_der_beeren_56099',
'art_der_suessigkeiten_36995',
'art_der_suessigkeiten_52757',
'family_1043',
'family_1118',
'family_1173',
'family_1209',
'family_1212',
'family_1226',
'family_1231',
'family_1238',
'family_1246',
'family_1253',
'family_1260',
'family_1262',
'family_1265',
'family_462',
'family_594',
'family_689',
'family_711',
'family_771',
'family_866',
'family_886',
'family_980',
'fischart_29664',
'fischart_35526',
'fischart_36125',
'fischart_37803',
'fischart_43299',
'fischart_43337',
'fischart_52490',
'fischart_52914',
'fischart_54243',
'fischart_54516',
'fischart_56343',
'fischart_57685',
'fleischart_30153',
'fleischart_47119',
'getreideart_25277',
'laenderkueche_36352',
'laenderkueche_50808',
'netto_fuellmenge_filter_2',
'netto_fuellmenge_filter_4',
'netto_fuellmenge_filter_5',
'serie_39537',
'serie_39540',
'serie_41382',
'serie_53680',
'serie_54749',
'serie_54773',
'serie_55386',
'teigwarenart_25243',
'vendor_1025',
'vendor_1113',
'vendor_1114',
'vendor_1141',
'vendor_1153',
'vendor_1157',
'vendor_1158',
'vendor_1205',
'vendor_1206',
'vendor_1232',
'vendor_1240',
'vendor_1247',
'vendor_1262',
'vendor_1292',
'vendor_1316',
'vendor_1348',
'vendor_1357',
'vendor_1372',
'vendor_1383',
'vendor_1386',
'vendor_1394',
'vendor_1463',
'vendor_1486',
'vendor_1495',
'vendor_1506',
'vendor_1508',
'vendor_153',
'vendor_1547',
'vendor_1590',
'vendor_1595',
'vendor_1631',
'vendor_1648',
'vendor_1660',
'vendor_181',
'vendor_216',
'vendor_265',
'vendor_267',
'vendor_381',
'vendor_449',
'vendor_519',
'vendor_608',
'vendor_621',
'vendor_639',
'vendor_649',
'vendor_664',
'vendor_725',
'vendor_738',
'vendor_750',
'vendor_762',
'vendor_770',
'vendor_874',
'vendor_895',
'vendor_897',
'vendor_909',
'vendor_919',
'vendor_962',
'vendor_972',
'vendor_981',
'vendor_984',
'vendor_989'
)
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','family_693','art_der_suessigkeiten_34384','vendor_531','family_1232','family_1078','vendor_458','family_1220','family_1152','modelname_40223','vendor_1377','family_1286','family_932','family_999','fleischart_15474','laenderkueche_36350','family_1211','vendor_42','vendor_716','art_der_suessigkeiten_34102','family_1035','family_1072','family_880','vendor_529','art_der_suessigkeiten_40017','art_der_suessigkeiten_42806','family_1275','family_716','family_1101','fischart_29660','vendor_196','vendor_380','vendor_751','vendor_860','art_der_beeren_53566','family_1169','family_1213','family_1228','family_1233','family_376','family_692','family_760','fischart_29998','laenderkueche_36349','vendor_1016','vendor_1226','vendor_134','vendor_1409','art_der_suessigkeiten_39611','art_der_suessigkeiten_40018','art_der_suessigkeiten_40113','art_der_suessigkeiten_46435','art_der_suessigkeiten_56942','family_1080','family_1106','family_1291','family_687','family_688','family_865','fleischart_47539','serie_44736','serie_44880','vendor_1179','vendor_1255','vendor_1317','vendor_1373','vendor_1549','vendor_357','vendor_489','vendor_666','vendor_752','vendor_944','art_der_beeren_53100','art_der_beeren_53103','art_der_beeren_53106','art_der_beeren_54004','art_der_beeren_54286','art_der_beeren_54717','family_1074','family_1077','family_1129','family_1225','family_1227','family_1234','family_1266','family_1279','family_686','family_854','family_922','family_981','fischart_29999','fischart_53820','fischart_54769','getreideart_23711','serie_27405','serie_39534','vendor_1015','vendor_1020','vendor_1070','vendor_1125','vendor_1152','vendor_1276','vendor_1330','vendor_1385','vendor_1458','vendor_150','vendor_1521','vendor_1555','vendor_156','vendor_1577','vendor_1598','vendor_221','vendor_223','vendor_224','vendor_404','vendor_759','vendor_862','vendor_881','vendor_910','vendor_914','art_der_beeren_54072','art_der_beeren_54397','art_der_beeren_56092','art_der_beeren_56094','art_der_beeren_56099','art_der_suessigkeiten_36995','art_der_suessigkeiten_52757','family_1043','family_1118','family_1173','family_1209','family_1212','family_1226','family_1231','family_1238','family_1246','family_1253','family_1260','family_1262','family_1265','family_462','family_594','family_689','family_711','family_771','family_866','family_886','family_980','fischart_29664','fischart_35526','fischart_36125','fischart_37803','fischart_43299','fischart_43337','fischart_52490','fischart_52914','fischart_54243','fischart_54516','fischart_56343','fischart_57685','fleischart_30153','fleischart_47119','getreideart_25277','laenderkueche_36352','laenderkueche_50808','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','netto_fuellmenge_filter_5','serie_39537','serie_39540','serie_41382','serie_53680','serie_54749','serie_54773','serie_55386','teigwarenart_25243','vendor_1025','vendor_1113','vendor_1114','vendor_1141','vendor_1153','vendor_1157','vendor_1158','vendor_1205','vendor_1206','vendor_1232','vendor_1240','vendor_1247','vendor_1262','vendor_1292','vendor_1316','vendor_1348','vendor_1357','vendor_1372','vendor_1383','vendor_1386','vendor_1394','vendor_1463','vendor_1486','vendor_1495','vendor_1506','vendor_1508','vendor_153','vendor_1547','vendor_1590','vendor_1595','vendor_1631','vendor_1648','vendor_1660','vendor_181','vendor_216','vendor_265','vendor_267','vendor_381','vendor_449','vendor_519','vendor_608','vendor_621','vendor_639','vendor_649','vendor_664','vendor_725','vendor_738','vendor_750','vendor_762','vendor_770','vendor_874','vendor_895','vendor_897','vendor_909','vendor_919','vendor_962','vendor_972','vendor_981','vendor_984','vendor_989') AND a.is_filterable = true;
|