| 3 |
0.37 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('coolbox_filter_0','freezebox_filter_2','sparset_filter_0','family_1232','fleischart_15470','family_1152','family_999','laenderkueche_36350','family_1211','family_1220','vendor_1377','vendor_458','art_der_beeren_53566','family_1213','family_1233','fleischart_15474','laenderkueche_36349','vendor_1226','vendor_531','family_1228','vendor_1317','vendor_1549','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_1129','family_1234','fischart_29999','fischart_53820','vendor_1015','vendor_1020','vendor_1070','vendor_1179','vendor_1276','vendor_1330','vendor_1385','vendor_1598','vendor_196','vendor_759','vendor_862','art_der_beeren_54072','art_der_beeren_54397','art_der_beeren_56092','art_der_beeren_56094','art_der_beeren_56099','family_1035','family_1043','family_1118','family_1212','family_1253','family_1262','fischart_29664','fischart_35526','fischart_43337','fischart_52490','fischart_52914','fischart_56343','fischart_57685','fleischart_47119','fleischart_47539','laenderkueche_50808','serie_54749','serie_54773','vendor_1025','vendor_1157','vendor_1205','vendor_1206','vendor_1262','vendor_1357','vendor_1372','vendor_1373','vendor_1386','vendor_1486','vendor_1547','vendor_1590','vendor_1648','vendor_639','vendor_752','vendor_909','vendor_914','vendor_984') 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(
'coolbox_filter_0', 'freezebox_filter_2',
'sparset_filter_0', 'family_1232',
'fleischart_15470', 'family_1152',
'family_999', 'laenderkueche_36350',
'family_1211', 'family_1220', 'vendor_1377',
'vendor_458', 'art_der_beeren_53566',
'family_1213', 'family_1233', 'fleischart_15474',
'laenderkueche_36349', 'vendor_1226',
'vendor_531', 'family_1228', 'vendor_1317',
'vendor_1549', '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_1129',
'family_1234', 'fischart_29999',
'fischart_53820', 'vendor_1015',
'vendor_1020', 'vendor_1070', 'vendor_1179',
'vendor_1276', 'vendor_1330', 'vendor_1385',
'vendor_1598', 'vendor_196', 'vendor_759',
'vendor_862', 'art_der_beeren_54072',
'art_der_beeren_54397', 'art_der_beeren_56092',
'art_der_beeren_56094', 'art_der_beeren_56099',
'family_1035', 'family_1043', 'family_1118',
'family_1212', 'family_1253', 'family_1262',
'fischart_29664', 'fischart_35526',
'fischart_43337', 'fischart_52490',
'fischart_52914', 'fischart_56343',
'fischart_57685', 'fleischart_47119',
'fleischart_47539', 'laenderkueche_50808',
'serie_54749', 'serie_54773', 'vendor_1025',
'vendor_1157', 'vendor_1205', 'vendor_1206',
'vendor_1262', 'vendor_1357', 'vendor_1372',
'vendor_1373', 'vendor_1386', 'vendor_1486',
'vendor_1547', 'vendor_1590', 'vendor_1648',
'vendor_639', 'vendor_752', 'vendor_909',
'vendor_914', 'vendor_984'
)
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('coolbox_filter_0','freezebox_filter_2','sparset_filter_0','family_1232','fleischart_15470','family_1152','family_999','laenderkueche_36350','family_1211','family_1220','vendor_1377','vendor_458','art_der_beeren_53566','family_1213','family_1233','fleischart_15474','laenderkueche_36349','vendor_1226','vendor_531','family_1228','vendor_1317','vendor_1549','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_1129','family_1234','fischart_29999','fischart_53820','vendor_1015','vendor_1020','vendor_1070','vendor_1179','vendor_1276','vendor_1330','vendor_1385','vendor_1598','vendor_196','vendor_759','vendor_862','art_der_beeren_54072','art_der_beeren_54397','art_der_beeren_56092','art_der_beeren_56094','art_der_beeren_56099','family_1035','family_1043','family_1118','family_1212','family_1253','family_1262','fischart_29664','fischart_35526','fischart_43337','fischart_52490','fischart_52914','fischart_56343','fischart_57685','fleischart_47119','fleischart_47539','laenderkueche_50808','serie_54749','serie_54773','vendor_1025','vendor_1157','vendor_1205','vendor_1206','vendor_1262','vendor_1357','vendor_1372','vendor_1373','vendor_1386','vendor_1486','vendor_1547','vendor_1590','vendor_1648','vendor_639','vendor_752','vendor_909','vendor_914','vendor_984') AND a.is_filterable = true;
|