| 7 |
0.13 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('family_148','sparset_filter_0','form_2151','materialgruppierung_1522','muster_473','materialgruppierung_1534','form_2157','durchmesser_3073','hoehe_5241','modelname_29023','serie_29022','durchmesser_2075','grossen_53942','hoehe_11290','hoehe_3613','serie_16812','durchmesser_4168','form_2152','grossen_4268','grossen_55431','grossen_56258','jahressymbol_56286','materialgruppierung_1535','modelname_26171','muster_31828','muster_474','muster_476','muster_9060','serie_24544','stil_7836','durchmesser_2070','durchmesser_2076','grossen_56432','grossen_56433','grossen_9403','hoehe_2913','hoehe_2914','inschrift_51648','modelname_19675','modelname_22799','modelname_26156','modelname_26175','modelname_39528','muster_30454','muster_30613','muster_3730','serie_16815','serie_24484','serie_24566','serie_33125','serie_9910','stil_19443','stil_4873') 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(
'family_148', 'sparset_filter_0',
'form_2151', 'materialgruppierung_1522',
'muster_473', 'materialgruppierung_1534',
'form_2157', 'durchmesser_3073',
'hoehe_5241', 'modelname_29023',
'serie_29022', 'durchmesser_2075',
'grossen_53942', 'hoehe_11290',
'hoehe_3613', 'serie_16812', 'durchmesser_4168',
'form_2152', 'grossen_4268', 'grossen_55431',
'grossen_56258', 'jahressymbol_56286',
'materialgruppierung_1535', 'modelname_26171',
'muster_31828', 'muster_474', 'muster_476',
'muster_9060', 'serie_24544', 'stil_7836',
'durchmesser_2070', 'durchmesser_2076',
'grossen_56432', 'grossen_56433',
'grossen_9403', 'hoehe_2913', 'hoehe_2914',
'inschrift_51648', 'modelname_19675',
'modelname_22799', 'modelname_26156',
'modelname_26175', 'modelname_39528',
'muster_30454', 'muster_30613',
'muster_3730', 'serie_16815', 'serie_24484',
'serie_24566', 'serie_33125', 'serie_9910',
'stil_19443', 'stil_4873'
)
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('family_148','sparset_filter_0','form_2151','materialgruppierung_1522','muster_473','materialgruppierung_1534','form_2157','durchmesser_3073','hoehe_5241','modelname_29023','serie_29022','durchmesser_2075','grossen_53942','hoehe_11290','hoehe_3613','serie_16812','durchmesser_4168','form_2152','grossen_4268','grossen_55431','grossen_56258','jahressymbol_56286','materialgruppierung_1535','modelname_26171','muster_31828','muster_474','muster_476','muster_9060','serie_24544','stil_7836','durchmesser_2070','durchmesser_2076','grossen_56432','grossen_56433','grossen_9403','hoehe_2913','hoehe_2914','inschrift_51648','modelname_19675','modelname_22799','modelname_26156','modelname_26175','modelname_39528','muster_30454','muster_30613','muster_3730','serie_16815','serie_24484','serie_24566','serie_33125','serie_9910','stil_19443','stil_4873') AND a.is_filterable = true;
|