| 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('sparset_filter_0','hauttyp_351','anwendungsgebiet_30906','anwendungsgebiet_30910','family_238','netto_fuellmenge_filter_3','netto_fuellmenge_filter_1','netto_fuellmenge_filter_2','vendor_46','vendor_873','anwendungsgebiet_30890','netto_fuellmenge_filter_4','family_291','vendor_1040','hauttyp_353','vendor_840','anwendungsgebiet_30919','family_237','haar_typ_1819','vendor_1399','family_255','hauttyp_357','serie_50789','vendor_879','family_222','family_230','hauttyp_2285','vendor_1425','vendor_1434','vendor_29','anwendungsgebiet_30918','family_216','family_217','family_231','family_526','family_629','hauttyp_355','netto_fuellmenge_filter_5','serie_54622','anwendungsgebiet_37352','family_1207','family_242','family_253','family_270','family_292','hauttyp_354','serie_56316','vendor_1502','vendor_603','vendor_849','anwendungsgebiet_30905','family_233','family_243','family_525','family_575','family_970','serie_29565','serie_56160','serie_56311','vendor_1209','vendor_137','vendor_1401','vendor_847','anwendungsgebiet_30908','anwendungsgebiet_30912','family_190','family_214','family_245','family_250','family_271','family_276','family_325','family_450','form_2157','grossen_53509','grossen_53536','grossen_53539','haar_typ_1820','haar_typ_1821','haar_typ_1822','haar_typ_1824','hauttyp_352','inschrift_47123','materialgruppierung_1524','materialgruppierung_17837','materialgruppierung_53538','materialgruppierung_5629','serie_53032','serie_54815','serie_55385','serie_55819','serie_56190','serie_56314','serie_56315','serie_56317','serie_56621','serie_56953','serie_56974','vendor_1062','vendor_1101','vendor_1335','vendor_1391','vendor_1454','vendor_1599','vendor_1625','vendor_469','vendor_476','vendor_56','vendor_676','vendor_710','vendor_878') 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', 'hauttyp_351',
'anwendungsgebiet_30906', 'anwendungsgebiet_30910',
'family_238', 'netto_fuellmenge_filter_3',
'netto_fuellmenge_filter_1', 'netto_fuellmenge_filter_2',
'vendor_46', 'vendor_873', 'anwendungsgebiet_30890',
'netto_fuellmenge_filter_4', 'family_291',
'vendor_1040', 'hauttyp_353', 'vendor_840',
'anwendungsgebiet_30919', 'family_237',
'haar_typ_1819', 'vendor_1399',
'family_255', 'hauttyp_357', 'serie_50789',
'vendor_879', 'family_222', 'family_230',
'hauttyp_2285', 'vendor_1425', 'vendor_1434',
'vendor_29', 'anwendungsgebiet_30918',
'family_216', 'family_217', 'family_231',
'family_526', 'family_629', 'hauttyp_355',
'netto_fuellmenge_filter_5', 'serie_54622',
'anwendungsgebiet_37352', 'family_1207',
'family_242', 'family_253', 'family_270',
'family_292', 'hauttyp_354', 'serie_56316',
'vendor_1502', 'vendor_603', 'vendor_849',
'anwendungsgebiet_30905', 'family_233',
'family_243', 'family_525', 'family_575',
'family_970', 'serie_29565', 'serie_56160',
'serie_56311', 'vendor_1209', 'vendor_137',
'vendor_1401', 'vendor_847', 'anwendungsgebiet_30908',
'anwendungsgebiet_30912', 'family_190',
'family_214', 'family_245', 'family_250',
'family_271', 'family_276', 'family_325',
'family_450', 'form_2157', 'grossen_53509',
'grossen_53536', 'grossen_53539',
'haar_typ_1820', 'haar_typ_1821',
'haar_typ_1822', 'haar_typ_1824',
'hauttyp_352', 'inschrift_47123',
'materialgruppierung_1524', 'materialgruppierung_17837',
'materialgruppierung_53538', 'materialgruppierung_5629',
'serie_53032', 'serie_54815', 'serie_55385',
'serie_55819', 'serie_56190', 'serie_56314',
'serie_56315', 'serie_56317', 'serie_56621',
'serie_56953', 'serie_56974', 'vendor_1062',
'vendor_1101', 'vendor_1335', 'vendor_1391',
'vendor_1454', 'vendor_1599', 'vendor_1625',
'vendor_469', 'vendor_476', 'vendor_56',
'vendor_676', 'vendor_710', 'vendor_878'
)
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','hauttyp_351','anwendungsgebiet_30906','anwendungsgebiet_30910','family_238','netto_fuellmenge_filter_3','netto_fuellmenge_filter_1','netto_fuellmenge_filter_2','vendor_46','vendor_873','anwendungsgebiet_30890','netto_fuellmenge_filter_4','family_291','vendor_1040','hauttyp_353','vendor_840','anwendungsgebiet_30919','family_237','haar_typ_1819','vendor_1399','family_255','hauttyp_357','serie_50789','vendor_879','family_222','family_230','hauttyp_2285','vendor_1425','vendor_1434','vendor_29','anwendungsgebiet_30918','family_216','family_217','family_231','family_526','family_629','hauttyp_355','netto_fuellmenge_filter_5','serie_54622','anwendungsgebiet_37352','family_1207','family_242','family_253','family_270','family_292','hauttyp_354','serie_56316','vendor_1502','vendor_603','vendor_849','anwendungsgebiet_30905','family_233','family_243','family_525','family_575','family_970','serie_29565','serie_56160','serie_56311','vendor_1209','vendor_137','vendor_1401','vendor_847','anwendungsgebiet_30908','anwendungsgebiet_30912','family_190','family_214','family_245','family_250','family_271','family_276','family_325','family_450','form_2157','grossen_53509','grossen_53536','grossen_53539','haar_typ_1820','haar_typ_1821','haar_typ_1822','haar_typ_1824','hauttyp_352','inschrift_47123','materialgruppierung_1524','materialgruppierung_17837','materialgruppierung_53538','materialgruppierung_5629','serie_53032','serie_54815','serie_55385','serie_55819','serie_56190','serie_56314','serie_56315','serie_56317','serie_56621','serie_56953','serie_56974','vendor_1062','vendor_1101','vendor_1335','vendor_1391','vendor_1454','vendor_1599','vendor_1625','vendor_469','vendor_476','vendor_56','vendor_676','vendor_710','vendor_878') AND a.is_filterable = true;
|