| 3 |
0.14 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','sparset_filter_0','freezebox_filter_3','freezebox_filter_2','laenderkueche_36350','family_981','fleischart_15470','family_1211','getreideart_25277','laenderkueche_43012','family_850','fleischart_15474','family_980','teigwarenart_25243','vendor_1298','fleischart_47539','vendor_531','vendor_938','vendor_458','family_935','getreideart_23707','family_1212','vendor_386','fleischart_47119','family_1234','laenderkueche_36349','laenderkueche_36352','sparset_filter_1','getreideart_23671','family_1210','getreideart_15473','family_854','vendor_198','laenderkueche_50808','vendor_639','vendor_154','vendor_752','teigwarenart_38803','vendor_1070','vendor_1373','vendor_153','vendor_159','family_1215','serie_34905','vendor_1173','vendor_1545','vendor_1593','family_1214','getreideart_15476','laenderkueche_36355','vendor_116','vendor_1492','getreideart_23711','laenderkueche_51124','vendor_1529','vendor_224','vendor_851','family_1256','family_697','getreideart_23708','getreideart_25278','vendor_1033','vendor_1423','vendor_1527','vendor_1549','vendor_1654','vendor_402','vendor_404','vendor_850','vendor_922','vendor_966','family_1262','family_755','family_936','fleischart_15475','laenderkueche_36354','serie_37454','vendor_1048','vendor_1280','vendor_1412','vendor_438','vendor_514','vendor_609','vendor_681','family_858','getreideart_15481','laenderkueche_36361','laenderkueche_43013','serie_54749','vendor_1049','vendor_1065','vendor_118','vendor_1191','vendor_1206','vendor_1374','vendor_1378','vendor_1410','vendor_1633','vendor_1648','vendor_249','vendor_444','vendor_446','vendor_608','vendor_637','vendor_775','vendor_786','vendor_872','vendor_962') 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', 'sparset_filter_0',
'freezebox_filter_3', 'freezebox_filter_2',
'laenderkueche_36350', 'family_981',
'fleischart_15470', 'family_1211',
'getreideart_25277', 'laenderkueche_43012',
'family_850', 'fleischart_15474',
'family_980', 'teigwarenart_25243',
'vendor_1298', 'fleischart_47539',
'vendor_531', 'vendor_938', 'vendor_458',
'family_935', 'getreideart_23707',
'family_1212', 'vendor_386', 'fleischart_47119',
'family_1234', 'laenderkueche_36349',
'laenderkueche_36352', 'sparset_filter_1',
'getreideart_23671', 'family_1210',
'getreideart_15473', 'family_854',
'vendor_198', 'laenderkueche_50808',
'vendor_639', 'vendor_154', 'vendor_752',
'teigwarenart_38803', 'vendor_1070',
'vendor_1373', 'vendor_153', 'vendor_159',
'family_1215', 'serie_34905', 'vendor_1173',
'vendor_1545', 'vendor_1593', 'family_1214',
'getreideart_15476', 'laenderkueche_36355',
'vendor_116', 'vendor_1492', 'getreideart_23711',
'laenderkueche_51124', 'vendor_1529',
'vendor_224', 'vendor_851', 'family_1256',
'family_697', 'getreideart_23708',
'getreideart_25278', 'vendor_1033',
'vendor_1423', 'vendor_1527', 'vendor_1549',
'vendor_1654', 'vendor_402', 'vendor_404',
'vendor_850', 'vendor_922', 'vendor_966',
'family_1262', 'family_755', 'family_936',
'fleischart_15475', 'laenderkueche_36354',
'serie_37454', 'vendor_1048', 'vendor_1280',
'vendor_1412', 'vendor_438', 'vendor_514',
'vendor_609', 'vendor_681', 'family_858',
'getreideart_15481', 'laenderkueche_36361',
'laenderkueche_43013', 'serie_54749',
'vendor_1049', 'vendor_1065', 'vendor_118',
'vendor_1191', 'vendor_1206', 'vendor_1374',
'vendor_1378', 'vendor_1410', 'vendor_1633',
'vendor_1648', 'vendor_249', 'vendor_444',
'vendor_446', 'vendor_608', 'vendor_637',
'vendor_775', 'vendor_786', 'vendor_872',
'vendor_962'
)
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','sparset_filter_0','freezebox_filter_3','freezebox_filter_2','laenderkueche_36350','family_981','fleischart_15470','family_1211','getreideart_25277','laenderkueche_43012','family_850','fleischart_15474','family_980','teigwarenart_25243','vendor_1298','fleischart_47539','vendor_531','vendor_938','vendor_458','family_935','getreideart_23707','family_1212','vendor_386','fleischart_47119','family_1234','laenderkueche_36349','laenderkueche_36352','sparset_filter_1','getreideart_23671','family_1210','getreideart_15473','family_854','vendor_198','laenderkueche_50808','vendor_639','vendor_154','vendor_752','teigwarenart_38803','vendor_1070','vendor_1373','vendor_153','vendor_159','family_1215','serie_34905','vendor_1173','vendor_1545','vendor_1593','family_1214','getreideart_15476','laenderkueche_36355','vendor_116','vendor_1492','getreideart_23711','laenderkueche_51124','vendor_1529','vendor_224','vendor_851','family_1256','family_697','getreideart_23708','getreideart_25278','vendor_1033','vendor_1423','vendor_1527','vendor_1549','vendor_1654','vendor_402','vendor_404','vendor_850','vendor_922','vendor_966','family_1262','family_755','family_936','fleischart_15475','laenderkueche_36354','serie_37454','vendor_1048','vendor_1280','vendor_1412','vendor_438','vendor_514','vendor_609','vendor_681','family_858','getreideart_15481','laenderkueche_36361','laenderkueche_43013','serie_54749','vendor_1049','vendor_1065','vendor_118','vendor_1191','vendor_1206','vendor_1374','vendor_1378','vendor_1410','vendor_1633','vendor_1648','vendor_249','vendor_444','vendor_446','vendor_608','vendor_637','vendor_775','vendor_786','vendor_872','vendor_962') AND a.is_filterable = true;
|