| 3 |
0.12 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_61','sparset_filter_0','materialgruppierung_1535','hoehe_3085','muster_473','muster_474','serie_56072','beschriftungssprache_25379','serie_38450','modelname_24744','serie_37737','beschriftungssprache_25548','form_1435','inschrift_22385','inschrift_22405','inschrift_23460','materialgruppierung_1534','modelname_24034','modelname_25163','modelname_25364','modelname_27877','modelname_27885','modelname_29995','modelname_30390','modelname_34287','modelname_35065','modelname_36719','modelname_36723','modelname_36817','modelname_36824','modelname_37732','modelname_37745','modelname_37747','modelname_38189','modelname_38193','modelname_38194','modelname_38195','modelname_38451','modelname_38533','modelname_42679','modelname_43155','modelname_44174','modelname_46506','modelname_52072','modelname_55576','modelname_56060','modelname_56103','modelname_56117','modelname_56156','modelname_56166','modelname_56167','modelname_56202','muster_4585','serie_29987','serie_36316','serie_36815','serie_37725','serie_51454','serie_51455','serie_51456','serie_51458','serie_55705','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_61', 'sparset_filter_0',
'materialgruppierung_1535', 'hoehe_3085',
'muster_473', 'muster_474', 'serie_56072',
'beschriftungssprache_25379', 'serie_38450',
'modelname_24744', 'serie_37737',
'beschriftungssprache_25548', 'form_1435',
'inschrift_22385', 'inschrift_22405',
'inschrift_23460', 'materialgruppierung_1534',
'modelname_24034', 'modelname_25163',
'modelname_25364', 'modelname_27877',
'modelname_27885', 'modelname_29995',
'modelname_30390', 'modelname_34287',
'modelname_35065', 'modelname_36719',
'modelname_36723', 'modelname_36817',
'modelname_36824', 'modelname_37732',
'modelname_37745', 'modelname_37747',
'modelname_38189', 'modelname_38193',
'modelname_38194', 'modelname_38195',
'modelname_38451', 'modelname_38533',
'modelname_42679', 'modelname_43155',
'modelname_44174', 'modelname_46506',
'modelname_52072', 'modelname_55576',
'modelname_56060', 'modelname_56103',
'modelname_56117', 'modelname_56156',
'modelname_56166', 'modelname_56167',
'modelname_56202', 'muster_4585',
'serie_29987', 'serie_36316', 'serie_36815',
'serie_37725', 'serie_51454', 'serie_51455',
'serie_51456', 'serie_51458', 'serie_55705',
'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_61','sparset_filter_0','materialgruppierung_1535','hoehe_3085','muster_473','muster_474','serie_56072','beschriftungssprache_25379','serie_38450','modelname_24744','serie_37737','beschriftungssprache_25548','form_1435','inschrift_22385','inschrift_22405','inschrift_23460','materialgruppierung_1534','modelname_24034','modelname_25163','modelname_25364','modelname_27877','modelname_27885','modelname_29995','modelname_30390','modelname_34287','modelname_35065','modelname_36719','modelname_36723','modelname_36817','modelname_36824','modelname_37732','modelname_37745','modelname_37747','modelname_38189','modelname_38193','modelname_38194','modelname_38195','modelname_38451','modelname_38533','modelname_42679','modelname_43155','modelname_44174','modelname_46506','modelname_52072','modelname_55576','modelname_56060','modelname_56103','modelname_56117','modelname_56156','modelname_56166','modelname_56167','modelname_56202','muster_4585','serie_29987','serie_36316','serie_36815','serie_37725','serie_51454','serie_51455','serie_51456','serie_51458','serie_55705','stil_4873') AND a.is_filterable = true;
|