| 7 |
0.29 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','freezebox_filter_3','coolbox_filter_0','family_376','family_692','getreideart_15473','family_971','family_724','getreideart_25277','vendor_386','vendor_1298','family_980','family_921','family_922','family_1026','family_589','vendor_531','laenderkueche_36352','family_932','family_711','vendor_159','vendor_198','laenderkueche_36354','art_der_suessigkeiten_42806','vendor_1258','netto_fuellmenge_filter_5','vendor_1016','vendor_1135','family_693','vendor_114','art_der_suessigkeiten_34384','family_1044','vendor_458','vendor_922','family_778','coolbox_filter_1','getreideart_15476','vendor_231','family_850','family_986','getreideart_23671','getreideart_23707','netto_fuellmenge_filter_3','family_1027','family_462','family_978','laenderkueche_36350','family_771','family_973','getreideart_15480','getreideart_15481','vendor_165','family_441','family_629','family_975','family_1028','family_760','freezebox_filter_2','getreideart_23711','netto_fuellmenge_filter_4','vendor_1412','vendor_499','serie_39543','vendor_1395','vendor_404','art_der_suessigkeiten_34102','family_688','laenderkueche_36349','vendor_1191','vendor_1228','vendor_224','vendor_449','family_691','family_886','family_976','family_977','family_981','getreideart_23709','vendor_1158','vendor_1374','vendor_140','vendor_186','vendor_529','vendor_553','family_1074','family_854','laenderkueche_43012','netto_fuellmenge_filter_2','vendor_171','vendor_192','vendor_962','art_der_suessigkeiten_39960','family_1102','family_1168','sparset_filter_1','vendor_1028','vendor_1133','vendor_1292','vendor_158','vendor_316','vendor_431','vendor_924','family_1009','family_1031','family_1036','family_1268','family_682','family_974','serie_34905','vendor_1104','vendor_1310','vendor_1328','vendor_1422','vendor_1659','vendor_414','vendor_511','vendor_743','vendor_785','vendor_834','vendor_960','family_1002','family_1032','family_1033','family_1120','family_1213','family_1275','family_1280','family_880','family_972','getreideart_15482','getreideart_23708','laenderkueche_50808','teigwarenart_25229','vendor_1015','vendor_1218','vendor_1255','vendor_1289','vendor_1296','vendor_1348','vendor_1593','vendor_1606','vendor_170','vendor_405','vendor_413','vendor_432','vendor_537','vendor_991','family_1072','family_1273','family_526','family_686','family_769','family_926','getreideart_25278','getreideart_25279','netto_fuellmenge_filter_7','vendor_1018','vendor_1232','vendor_1337','vendor_1483','vendor_156','vendor_157','vendor_164','vendor_274','vendor_403','vendor_430','vendor_457','vendor_533','vendor_538','vendor_552','vendor_637','vendor_745','vendor_873','vendor_881','vendor_895','vendor_923','vendor_967','art_der_suessigkeiten_46435','family_1024','family_1030','family_1045','family_1046','family_1075','family_1100','family_1270','family_697','family_754','family_773','laenderkueche_43013','laenderkueche_48797','teigwarenart_25243','teigwarenart_38803','vendor_1113','vendor_1205','vendor_1302','vendor_150','vendor_1521','vendor_1527','vendor_1529','vendor_1630','vendor_1639','vendor_1641','vendor_179','vendor_459','vendor_477','vendor_489','vendor_535','vendor_547','vendor_554','vendor_608','vendor_744','vendor_770','vendor_861','vendor_897','family_1000','family_1021','family_1023','family_1115','family_1269','family_1296','family_759','family_868','family_935','getreideart_38595','laenderkueche_36355','laenderkueche_47654','vendor_1025','vendor_1054','vendor_112','vendor_1145','vendor_1187','vendor_1197','vendor_1211','vendor_1216','vendor_1260','vendor_1319','vendor_1331','vendor_1333','vendor_1377','vendor_1388','vendor_143','vendor_1440','vendor_1463','vendor_1522','vendor_1543','vendor_1567','vendor_1591','vendor_1596','vendor_1610','vendor_1623','vendor_1624','vendor_1651','vendor_187','vendor_196','vendor_248','vendor_346','vendor_490','vendor_500','vendor_534','vendor_689','vendor_715','vendor_836','vendor_928','vendor_952','vendor_961','family_1016','family_1018','family_1022','family_1034','family_1049','family_1055','family_1067','family_1099','family_1142','family_1144','family_1287','family_755','family_866','fischart_29999','getreideart_38553','laenderkueche_43129','laenderkueche_43210','netto_fuellmenge_filter_1','netto_fuellmenge_filter_6','netto_fuellmenge_filter_8','serie_55241','teigwarenart_25246','vendor_1031','vendor_1106','vendor_1112','vendor_1114','vendor_1121','vendor_1140','vendor_116','vendor_1165','vendor_1206','vendor_1213','vendor_125','vendor_1313','vendor_1354','vendor_1358','vendor_1387','vendor_139','vendor_1394','vendor_144','vendor_1441','vendor_1451','vendor_1457','vendor_1488','vendor_149','vendor_1492','vendor_1508','vendor_1514','vendor_1530','vendor_1535','vendor_1541','vendor_1542','vendor_1619','vendor_1637','vendor_1649','vendor_1650','vendor_1656','vendor_1667','vendor_212','vendor_221','vendor_225','vendor_235','vendor_256','vendor_277','vendor_280','vendor_313','vendor_357','vendor_383','vendor_385','vendor_402','vendor_42','vendor_437','vendor_438','vendor_448','vendor_461','vendor_473','vendor_479','vendor_481','vendor_513','vendor_551','vendor_636','vendor_644','vendor_649','vendor_699','vendor_716','vendor_717','vendor_782','vendor_786','vendor_835','vendor_869','vendor_892','vendor_893','vendor_915','vendor_938','vendor_956','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',
'freezebox_filter_3',
'coolbox_filter_0',
'family_376',
'family_692',
'getreideart_15473',
'family_971',
'family_724',
'getreideart_25277',
'vendor_386',
'vendor_1298',
'family_980',
'family_921',
'family_922',
'family_1026',
'family_589',
'vendor_531',
'laenderkueche_36352',
'family_932',
'family_711',
'vendor_159',
'vendor_198',
'laenderkueche_36354',
'art_der_suessigkeiten_42806',
'vendor_1258',
'netto_fuellmenge_filter_5',
'vendor_1016',
'vendor_1135',
'family_693',
'vendor_114',
'art_der_suessigkeiten_34384',
'family_1044',
'vendor_458',
'vendor_922',
'family_778',
'coolbox_filter_1',
'getreideart_15476',
'vendor_231',
'family_850',
'family_986',
'getreideart_23671',
'getreideart_23707',
'netto_fuellmenge_filter_3',
'family_1027',
'family_462',
'family_978',
'laenderkueche_36350',
'family_771',
'family_973',
'getreideart_15480',
'getreideart_15481',
'vendor_165',
'family_441',
'family_629',
'family_975',
'family_1028',
'family_760',
'freezebox_filter_2',
'getreideart_23711',
'netto_fuellmenge_filter_4',
'vendor_1412',
'vendor_499',
'serie_39543',
'vendor_1395',
'vendor_404',
'art_der_suessigkeiten_34102',
'family_688',
'laenderkueche_36349',
'vendor_1191',
'vendor_1228',
'vendor_224',
'vendor_449',
'family_691',
'family_886',
'family_976',
'family_977',
'family_981',
'getreideart_23709',
'vendor_1158',
'vendor_1374',
'vendor_140',
'vendor_186',
'vendor_529',
'vendor_553',
'family_1074',
'family_854',
'laenderkueche_43012',
'netto_fuellmenge_filter_2',
'vendor_171',
'vendor_192',
'vendor_962',
'art_der_suessigkeiten_39960',
'family_1102',
'family_1168',
'sparset_filter_1',
'vendor_1028',
'vendor_1133',
'vendor_1292',
'vendor_158',
'vendor_316',
'vendor_431',
'vendor_924',
'family_1009',
'family_1031',
'family_1036',
'family_1268',
'family_682',
'family_974',
'serie_34905',
'vendor_1104',
'vendor_1310',
'vendor_1328',
'vendor_1422',
'vendor_1659',
'vendor_414',
'vendor_511',
'vendor_743',
'vendor_785',
'vendor_834',
'vendor_960',
'family_1002',
'family_1032',
'family_1033',
'family_1120',
'family_1213',
'family_1275',
'family_1280',
'family_880',
'family_972',
'getreideart_15482',
'getreideart_23708',
'laenderkueche_50808',
'teigwarenart_25229',
'vendor_1015',
'vendor_1218',
'vendor_1255',
'vendor_1289',
'vendor_1296',
'vendor_1348',
'vendor_1593',
'vendor_1606',
'vendor_170',
'vendor_405',
'vendor_413',
'vendor_432',
'vendor_537',
'vendor_991',
'family_1072',
'family_1273',
'family_526',
'family_686',
'family_769',
'family_926',
'getreideart_25278',
'getreideart_25279',
'netto_fuellmenge_filter_7',
'vendor_1018',
'vendor_1232',
'vendor_1337',
'vendor_1483',
'vendor_156',
'vendor_157',
'vendor_164',
'vendor_274',
'vendor_403',
'vendor_430',
'vendor_457',
'vendor_533',
'vendor_538',
'vendor_552',
'vendor_637',
'vendor_745',
'vendor_873',
'vendor_881',
'vendor_895',
'vendor_923',
'vendor_967',
'art_der_suessigkeiten_46435',
'family_1024',
'family_1030',
'family_1045',
'family_1046',
'family_1075',
'family_1100',
'family_1270',
'family_697',
'family_754',
'family_773',
'laenderkueche_43013',
'laenderkueche_48797',
'teigwarenart_25243',
'teigwarenart_38803',
'vendor_1113',
'vendor_1205',
'vendor_1302',
'vendor_150',
'vendor_1521',
'vendor_1527',
'vendor_1529',
'vendor_1630',
'vendor_1639',
'vendor_1641',
'vendor_179',
'vendor_459',
'vendor_477',
'vendor_489',
'vendor_535',
'vendor_547',
'vendor_554',
'vendor_608',
'vendor_744',
'vendor_770',
'vendor_861',
'vendor_897',
'family_1000',
'family_1021',
'family_1023',
'family_1115',
'family_1269',
'family_1296',
'family_759',
'family_868',
'family_935',
'getreideart_38595',
'laenderkueche_36355',
'laenderkueche_47654',
'vendor_1025',
'vendor_1054',
'vendor_112',
'vendor_1145',
'vendor_1187',
'vendor_1197',
'vendor_1211',
'vendor_1216',
'vendor_1260',
'vendor_1319',
'vendor_1331',
'vendor_1333',
'vendor_1377',
'vendor_1388',
'vendor_143',
'vendor_1440',
'vendor_1463',
'vendor_1522',
'vendor_1543',
'vendor_1567',
'vendor_1591',
'vendor_1596',
'vendor_1610',
'vendor_1623',
'vendor_1624',
'vendor_1651',
'vendor_187',
'vendor_196',
'vendor_248',
'vendor_346',
'vendor_490',
'vendor_500',
'vendor_534',
'vendor_689',
'vendor_715',
'vendor_836',
'vendor_928',
'vendor_952',
'vendor_961',
'family_1016',
'family_1018',
'family_1022',
'family_1034',
'family_1049',
'family_1055',
'family_1067',
'family_1099',
'family_1142',
'family_1144',
'family_1287',
'family_755',
'family_866',
'fischart_29999',
'getreideart_38553',
'laenderkueche_43129',
'laenderkueche_43210',
'netto_fuellmenge_filter_1',
'netto_fuellmenge_filter_6',
'netto_fuellmenge_filter_8',
'serie_55241',
'teigwarenart_25246',
'vendor_1031',
'vendor_1106',
'vendor_1112',
'vendor_1114',
'vendor_1121',
'vendor_1140',
'vendor_116',
'vendor_1165',
'vendor_1206',
'vendor_1213',
'vendor_125',
'vendor_1313',
'vendor_1354',
'vendor_1358',
'vendor_1387',
'vendor_139',
'vendor_1394',
'vendor_144',
'vendor_1441',
'vendor_1451',
'vendor_1457',
'vendor_1488',
'vendor_149',
'vendor_1492',
'vendor_1508',
'vendor_1514',
'vendor_1530',
'vendor_1535',
'vendor_1541',
'vendor_1542',
'vendor_1619',
'vendor_1637',
'vendor_1649',
'vendor_1650',
'vendor_1656',
'vendor_1667',
'vendor_212',
'vendor_221',
'vendor_225',
'vendor_235',
'vendor_256',
'vendor_277',
'vendor_280',
'vendor_313',
'vendor_357',
'vendor_383',
'vendor_385',
'vendor_402',
'vendor_42',
'vendor_437',
'vendor_438',
'vendor_448',
'vendor_461',
'vendor_473',
'vendor_479',
'vendor_481',
'vendor_513',
'vendor_551',
'vendor_636',
'vendor_644',
'vendor_649',
'vendor_699',
'vendor_716',
'vendor_717',
'vendor_782',
'vendor_786',
'vendor_835',
'vendor_869',
'vendor_892',
'vendor_893',
'vendor_915',
'vendor_938',
'vendor_956',
'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','freezebox_filter_3','coolbox_filter_0','family_376','family_692','getreideart_15473','family_971','family_724','getreideart_25277','vendor_386','vendor_1298','family_980','family_921','family_922','family_1026','family_589','vendor_531','laenderkueche_36352','family_932','family_711','vendor_159','vendor_198','laenderkueche_36354','art_der_suessigkeiten_42806','vendor_1258','netto_fuellmenge_filter_5','vendor_1016','vendor_1135','family_693','vendor_114','art_der_suessigkeiten_34384','family_1044','vendor_458','vendor_922','family_778','coolbox_filter_1','getreideart_15476','vendor_231','family_850','family_986','getreideart_23671','getreideart_23707','netto_fuellmenge_filter_3','family_1027','family_462','family_978','laenderkueche_36350','family_771','family_973','getreideart_15480','getreideart_15481','vendor_165','family_441','family_629','family_975','family_1028','family_760','freezebox_filter_2','getreideart_23711','netto_fuellmenge_filter_4','vendor_1412','vendor_499','serie_39543','vendor_1395','vendor_404','art_der_suessigkeiten_34102','family_688','laenderkueche_36349','vendor_1191','vendor_1228','vendor_224','vendor_449','family_691','family_886','family_976','family_977','family_981','getreideart_23709','vendor_1158','vendor_1374','vendor_140','vendor_186','vendor_529','vendor_553','family_1074','family_854','laenderkueche_43012','netto_fuellmenge_filter_2','vendor_171','vendor_192','vendor_962','art_der_suessigkeiten_39960','family_1102','family_1168','sparset_filter_1','vendor_1028','vendor_1133','vendor_1292','vendor_158','vendor_316','vendor_431','vendor_924','family_1009','family_1031','family_1036','family_1268','family_682','family_974','serie_34905','vendor_1104','vendor_1310','vendor_1328','vendor_1422','vendor_1659','vendor_414','vendor_511','vendor_743','vendor_785','vendor_834','vendor_960','family_1002','family_1032','family_1033','family_1120','family_1213','family_1275','family_1280','family_880','family_972','getreideart_15482','getreideart_23708','laenderkueche_50808','teigwarenart_25229','vendor_1015','vendor_1218','vendor_1255','vendor_1289','vendor_1296','vendor_1348','vendor_1593','vendor_1606','vendor_170','vendor_405','vendor_413','vendor_432','vendor_537','vendor_991','family_1072','family_1273','family_526','family_686','family_769','family_926','getreideart_25278','getreideart_25279','netto_fuellmenge_filter_7','vendor_1018','vendor_1232','vendor_1337','vendor_1483','vendor_156','vendor_157','vendor_164','vendor_274','vendor_403','vendor_430','vendor_457','vendor_533','vendor_538','vendor_552','vendor_637','vendor_745','vendor_873','vendor_881','vendor_895','vendor_923','vendor_967','art_der_suessigkeiten_46435','family_1024','family_1030','family_1045','family_1046','family_1075','family_1100','family_1270','family_697','family_754','family_773','laenderkueche_43013','laenderkueche_48797','teigwarenart_25243','teigwarenart_38803','vendor_1113','vendor_1205','vendor_1302','vendor_150','vendor_1521','vendor_1527','vendor_1529','vendor_1630','vendor_1639','vendor_1641','vendor_179','vendor_459','vendor_477','vendor_489','vendor_535','vendor_547','vendor_554','vendor_608','vendor_744','vendor_770','vendor_861','vendor_897','family_1000','family_1021','family_1023','family_1115','family_1269','family_1296','family_759','family_868','family_935','getreideart_38595','laenderkueche_36355','laenderkueche_47654','vendor_1025','vendor_1054','vendor_112','vendor_1145','vendor_1187','vendor_1197','vendor_1211','vendor_1216','vendor_1260','vendor_1319','vendor_1331','vendor_1333','vendor_1377','vendor_1388','vendor_143','vendor_1440','vendor_1463','vendor_1522','vendor_1543','vendor_1567','vendor_1591','vendor_1596','vendor_1610','vendor_1623','vendor_1624','vendor_1651','vendor_187','vendor_196','vendor_248','vendor_346','vendor_490','vendor_500','vendor_534','vendor_689','vendor_715','vendor_836','vendor_928','vendor_952','vendor_961','family_1016','family_1018','family_1022','family_1034','family_1049','family_1055','family_1067','family_1099','family_1142','family_1144','family_1287','family_755','family_866','fischart_29999','getreideart_38553','laenderkueche_43129','laenderkueche_43210','netto_fuellmenge_filter_1','netto_fuellmenge_filter_6','netto_fuellmenge_filter_8','serie_55241','teigwarenart_25246','vendor_1031','vendor_1106','vendor_1112','vendor_1114','vendor_1121','vendor_1140','vendor_116','vendor_1165','vendor_1206','vendor_1213','vendor_125','vendor_1313','vendor_1354','vendor_1358','vendor_1387','vendor_139','vendor_1394','vendor_144','vendor_1441','vendor_1451','vendor_1457','vendor_1488','vendor_149','vendor_1492','vendor_1508','vendor_1514','vendor_1530','vendor_1535','vendor_1541','vendor_1542','vendor_1619','vendor_1637','vendor_1649','vendor_1650','vendor_1656','vendor_1667','vendor_212','vendor_221','vendor_225','vendor_235','vendor_256','vendor_277','vendor_280','vendor_313','vendor_357','vendor_383','vendor_385','vendor_402','vendor_42','vendor_437','vendor_438','vendor_448','vendor_461','vendor_473','vendor_479','vendor_481','vendor_513','vendor_551','vendor_636','vendor_644','vendor_649','vendor_699','vendor_716','vendor_717','vendor_782','vendor_786','vendor_835','vendor_869','vendor_892','vendor_893','vendor_915','vendor_938','vendor_956','vendor_958') AND a.is_filterable = true;
|