| 3 |
0.15 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_62','materialgruppierung_23844','sparset_filter_0','groesse_3393','groesse_3394','beschriftungssprache_25379','inschrift_23460','inschrift_22405','inschrift_23487','inschrift_22385','inschrift_22407','inschrift_32534','inschrift_22366','inschrift_22408','inschrift_22414','inschrift_26753','inschrift_32535','modelname_25333','modelname_25372','modelname_25373','modelname_25633','modelname_26466','modelname_30332','modelname_32500','modelname_32505','modelname_32506','modelname_32507','modelname_32508','modelname_32509','modelname_32510','modelname_32511','modelname_32512','modelname_32514','modelname_32515','modelname_32516','modelname_32517','modelname_32518','modelname_32519','modelname_32520','modelname_32521','modelname_32522','modelname_32523','modelname_32524','modelname_32525','modelname_32526','modelname_32529','modelname_32530','modelname_32531','modelname_32533','modelname_41231','modelname_41234','modelname_41235','modelname_53056','modelname_54587','modelname_54588','modelname_54589','modelname_56049') 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_62', 'materialgruppierung_23844',
'sparset_filter_0', 'groesse_3393',
'groesse_3394', 'beschriftungssprache_25379',
'inschrift_23460', 'inschrift_22405',
'inschrift_23487', 'inschrift_22385',
'inschrift_22407', 'inschrift_32534',
'inschrift_22366', 'inschrift_22408',
'inschrift_22414', 'inschrift_26753',
'inschrift_32535', 'modelname_25333',
'modelname_25372', 'modelname_25373',
'modelname_25633', 'modelname_26466',
'modelname_30332', 'modelname_32500',
'modelname_32505', 'modelname_32506',
'modelname_32507', 'modelname_32508',
'modelname_32509', 'modelname_32510',
'modelname_32511', 'modelname_32512',
'modelname_32514', 'modelname_32515',
'modelname_32516', 'modelname_32517',
'modelname_32518', 'modelname_32519',
'modelname_32520', 'modelname_32521',
'modelname_32522', 'modelname_32523',
'modelname_32524', 'modelname_32525',
'modelname_32526', 'modelname_32529',
'modelname_32530', 'modelname_32531',
'modelname_32533', 'modelname_41231',
'modelname_41234', 'modelname_41235',
'modelname_53056', 'modelname_54587',
'modelname_54588', 'modelname_54589',
'modelname_56049'
)
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_62','materialgruppierung_23844','sparset_filter_0','groesse_3393','groesse_3394','beschriftungssprache_25379','inschrift_23460','inschrift_22405','inschrift_23487','inschrift_22385','inschrift_22407','inschrift_32534','inschrift_22366','inschrift_22408','inschrift_22414','inschrift_26753','inschrift_32535','modelname_25333','modelname_25372','modelname_25373','modelname_25633','modelname_26466','modelname_30332','modelname_32500','modelname_32505','modelname_32506','modelname_32507','modelname_32508','modelname_32509','modelname_32510','modelname_32511','modelname_32512','modelname_32514','modelname_32515','modelname_32516','modelname_32517','modelname_32518','modelname_32519','modelname_32520','modelname_32521','modelname_32522','modelname_32523','modelname_32524','modelname_32525','modelname_32526','modelname_32529','modelname_32530','modelname_32531','modelname_32533','modelname_41231','modelname_41234','modelname_41235','modelname_53056','modelname_54587','modelname_54588','modelname_54589','modelname_56049') AND a.is_filterable = true;
|