| 3 |
0.17 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('freezebox_filter_2','coolbox_filter_0','sparset_filter_0','family_1152','fleischart_15470','vendor_531','laenderkueche_36350','family_1211','fleischart_15474','sparset_filter_1','family_999','family_1220','vendor_458','family_1213','family_1232','laenderkueche_36349','laenderkueche_36352','fleischart_47539','family_1233','family_1228','serie_51387','family_1212','fleischart_47119','vendor_1507','vendor_862','family_1234','vendor_752','vendor_1373','family_1210','vendor_1317','vendor_1377','family_1254','vendor_1226','vendor_1330','family_1219','laenderkueche_50808','vendor_1476','vendor_639','vendor_1015','vendor_1020','vendor_196','art_der_beeren_53100','art_der_beeren_53566','family_1129','fischart_29659','vendor_1070','vendor_909','vendor_944','family_1118','family_1215','fischart_43337','vendor_1173','vendor_1598','art_der_beeren_53106','family_1214','family_778','fischart_29664','fischart_29999','vendor_1276','vendor_511','vendor_852','art_der_beeren_54072','laenderkueche_51124','vendor_1025','vendor_1179','vendor_1261','vendor_1277','vendor_1372','vendor_1376','vendor_1463','vendor_1529','vendor_1549','vendor_1621','vendor_759','vendor_850','vendor_851','vendor_910','vendor_914','art_der_beeren_53103','art_der_beeren_54286','family_1253','family_1256','fischart_36125','fleischart_15475','laenderkueche_36355','vendor_1033','vendor_1107','vendor_1157','vendor_1206','vendor_1385','vendor_1547','vendor_1608','vendor_855','art_der_beeren_54004','art_der_beeren_54397','art_der_beeren_54717','art_der_beeren_56092','family_1239','family_1251','family_1262','family_755','fischart_43320','fischart_53820','fischart_55177','laenderkueche_36354','netto_fuellmenge_filter_4','netto_fuellmenge_filter_6','serie_37454','serie_54773','vendor_1048','vendor_1262','vendor_1280','vendor_1357','vendor_1378','vendor_1386','vendor_1486','vendor_1590','vendor_1648','vendor_386','vendor_630','vendor_897','vendor_907','vendor_984','art_der_beeren_56094','art_der_beeren_56099','art_der_beeren_56100','coolbox_filter_1','family_1035','family_1043','fischart_29661','fischart_35526','fischart_52356','fischart_52490','fischart_52492','fischart_52914','fischart_54979','fischart_56343','fischart_57685','laenderkueche_36361','netto_fuellmenge_filter_5','serie_36417','serie_39536','serie_39543','serie_54749','vendor_1022','vendor_1049','vendor_1065','vendor_1077','vendor_1081','vendor_1149','vendor_1182','vendor_1205','vendor_1387','vendor_1410','vendor_1470','vendor_1509','vendor_1540','vendor_1546','vendor_1557','vendor_1638','vendor_224','vendor_679','vendor_872','vendor_884','vendor_908','vendor_979','vendor_980') 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(
'freezebox_filter_2',
'coolbox_filter_0',
'sparset_filter_0',
'family_1152',
'fleischart_15470',
'vendor_531',
'laenderkueche_36350',
'family_1211',
'fleischart_15474',
'sparset_filter_1',
'family_999',
'family_1220',
'vendor_458',
'family_1213',
'family_1232',
'laenderkueche_36349',
'laenderkueche_36352',
'fleischart_47539',
'family_1233',
'family_1228',
'serie_51387',
'family_1212',
'fleischart_47119',
'vendor_1507',
'vendor_862',
'family_1234',
'vendor_752',
'vendor_1373',
'family_1210',
'vendor_1317',
'vendor_1377',
'family_1254',
'vendor_1226',
'vendor_1330',
'family_1219',
'laenderkueche_50808',
'vendor_1476',
'vendor_639',
'vendor_1015',
'vendor_1020',
'vendor_196',
'art_der_beeren_53100',
'art_der_beeren_53566',
'family_1129',
'fischart_29659',
'vendor_1070',
'vendor_909',
'vendor_944',
'family_1118',
'family_1215',
'fischart_43337',
'vendor_1173',
'vendor_1598',
'art_der_beeren_53106',
'family_1214',
'family_778',
'fischart_29664',
'fischart_29999',
'vendor_1276',
'vendor_511',
'vendor_852',
'art_der_beeren_54072',
'laenderkueche_51124',
'vendor_1025',
'vendor_1179',
'vendor_1261',
'vendor_1277',
'vendor_1372',
'vendor_1376',
'vendor_1463',
'vendor_1529',
'vendor_1549',
'vendor_1621',
'vendor_759',
'vendor_850',
'vendor_851',
'vendor_910',
'vendor_914',
'art_der_beeren_53103',
'art_der_beeren_54286',
'family_1253',
'family_1256',
'fischart_36125',
'fleischart_15475',
'laenderkueche_36355',
'vendor_1033',
'vendor_1107',
'vendor_1157',
'vendor_1206',
'vendor_1385',
'vendor_1547',
'vendor_1608',
'vendor_855',
'art_der_beeren_54004',
'art_der_beeren_54397',
'art_der_beeren_54717',
'art_der_beeren_56092',
'family_1239',
'family_1251',
'family_1262',
'family_755',
'fischart_43320',
'fischart_53820',
'fischart_55177',
'laenderkueche_36354',
'netto_fuellmenge_filter_4',
'netto_fuellmenge_filter_6',
'serie_37454',
'serie_54773',
'vendor_1048',
'vendor_1262',
'vendor_1280',
'vendor_1357',
'vendor_1378',
'vendor_1386',
'vendor_1486',
'vendor_1590',
'vendor_1648',
'vendor_386',
'vendor_630',
'vendor_897',
'vendor_907',
'vendor_984',
'art_der_beeren_56094',
'art_der_beeren_56099',
'art_der_beeren_56100',
'coolbox_filter_1',
'family_1035',
'family_1043',
'fischart_29661',
'fischart_35526',
'fischart_52356',
'fischart_52490',
'fischart_52492',
'fischart_52914',
'fischart_54979',
'fischart_56343',
'fischart_57685',
'laenderkueche_36361',
'netto_fuellmenge_filter_5',
'serie_36417',
'serie_39536',
'serie_39543',
'serie_54749',
'vendor_1022',
'vendor_1049',
'vendor_1065',
'vendor_1077',
'vendor_1081',
'vendor_1149',
'vendor_1182',
'vendor_1205',
'vendor_1387',
'vendor_1410',
'vendor_1470',
'vendor_1509',
'vendor_1540',
'vendor_1546',
'vendor_1557',
'vendor_1638',
'vendor_224',
'vendor_679',
'vendor_872',
'vendor_884',
'vendor_908',
'vendor_979',
'vendor_980'
)
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('freezebox_filter_2','coolbox_filter_0','sparset_filter_0','family_1152','fleischart_15470','vendor_531','laenderkueche_36350','family_1211','fleischart_15474','sparset_filter_1','family_999','family_1220','vendor_458','family_1213','family_1232','laenderkueche_36349','laenderkueche_36352','fleischart_47539','family_1233','family_1228','serie_51387','family_1212','fleischart_47119','vendor_1507','vendor_862','family_1234','vendor_752','vendor_1373','family_1210','vendor_1317','vendor_1377','family_1254','vendor_1226','vendor_1330','family_1219','laenderkueche_50808','vendor_1476','vendor_639','vendor_1015','vendor_1020','vendor_196','art_der_beeren_53100','art_der_beeren_53566','family_1129','fischart_29659','vendor_1070','vendor_909','vendor_944','family_1118','family_1215','fischart_43337','vendor_1173','vendor_1598','art_der_beeren_53106','family_1214','family_778','fischart_29664','fischart_29999','vendor_1276','vendor_511','vendor_852','art_der_beeren_54072','laenderkueche_51124','vendor_1025','vendor_1179','vendor_1261','vendor_1277','vendor_1372','vendor_1376','vendor_1463','vendor_1529','vendor_1549','vendor_1621','vendor_759','vendor_850','vendor_851','vendor_910','vendor_914','art_der_beeren_53103','art_der_beeren_54286','family_1253','family_1256','fischart_36125','fleischart_15475','laenderkueche_36355','vendor_1033','vendor_1107','vendor_1157','vendor_1206','vendor_1385','vendor_1547','vendor_1608','vendor_855','art_der_beeren_54004','art_der_beeren_54397','art_der_beeren_54717','art_der_beeren_56092','family_1239','family_1251','family_1262','family_755','fischart_43320','fischart_53820','fischart_55177','laenderkueche_36354','netto_fuellmenge_filter_4','netto_fuellmenge_filter_6','serie_37454','serie_54773','vendor_1048','vendor_1262','vendor_1280','vendor_1357','vendor_1378','vendor_1386','vendor_1486','vendor_1590','vendor_1648','vendor_386','vendor_630','vendor_897','vendor_907','vendor_984','art_der_beeren_56094','art_der_beeren_56099','art_der_beeren_56100','coolbox_filter_1','family_1035','family_1043','fischart_29661','fischart_35526','fischart_52356','fischart_52490','fischart_52492','fischart_52914','fischart_54979','fischart_56343','fischart_57685','laenderkueche_36361','netto_fuellmenge_filter_5','serie_36417','serie_39536','serie_39543','serie_54749','vendor_1022','vendor_1049','vendor_1065','vendor_1077','vendor_1081','vendor_1149','vendor_1182','vendor_1205','vendor_1387','vendor_1410','vendor_1470','vendor_1509','vendor_1540','vendor_1546','vendor_1557','vendor_1638','vendor_224','vendor_679','vendor_872','vendor_884','vendor_908','vendor_979','vendor_980') AND a.is_filterable = true;
|