| 4 |
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_65','materialgruppierung_23844','sparset_filter_0','serie_53664','groesse_1010','groesse_1011','groesse_1013','groesse_35132','groesse_35133','serie_36315','groesse_1012','groesse_13436','muster_474','muster_33280','serie_36319','serie_36641','groesse_13435','muster_30451','serie_56594','beschriftungssprache_25379','groesse_14207','jahressymbol_37323','modelname_22864','modelname_34673','modelname_35065','modelname_35175','modelname_35178','modelname_35179','modelname_35310','modelname_35311','modelname_35921','modelname_36542','modelname_36652','modelname_36711','modelname_36773','modelname_36775','modelname_37420','modelname_37926','modelname_38245','modelname_38981','modelname_39482','modelname_40022','modelname_40158','modelname_40160','modelname_40162','modelname_41135','modelname_42798','modelname_43039','modelname_44174','modelname_44986','modelname_50802','modelname_53405','modelname_53414','modelname_53431','modelname_53743','modelname_54219','modelname_54223','modelname_54504','modelname_54507','modelname_54527','modelname_55067','modelname_55515','modelname_55539','modelname_55737','modelname_56090','serie_35078','serie_36316','serie_36317','serie_56140') 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_65', 'materialgruppierung_23844',
'sparset_filter_0', 'serie_53664',
'groesse_1010', 'groesse_1011',
'groesse_1013', 'groesse_35132',
'groesse_35133', 'serie_36315',
'groesse_1012', 'groesse_13436',
'muster_474', 'muster_33280', 'serie_36319',
'serie_36641', 'groesse_13435',
'muster_30451', 'serie_56594', 'beschriftungssprache_25379',
'groesse_14207', 'jahressymbol_37323',
'modelname_22864', 'modelname_34673',
'modelname_35065', 'modelname_35175',
'modelname_35178', 'modelname_35179',
'modelname_35310', 'modelname_35311',
'modelname_35921', 'modelname_36542',
'modelname_36652', 'modelname_36711',
'modelname_36773', 'modelname_36775',
'modelname_37420', 'modelname_37926',
'modelname_38245', 'modelname_38981',
'modelname_39482', 'modelname_40022',
'modelname_40158', 'modelname_40160',
'modelname_40162', 'modelname_41135',
'modelname_42798', 'modelname_43039',
'modelname_44174', 'modelname_44986',
'modelname_50802', 'modelname_53405',
'modelname_53414', 'modelname_53431',
'modelname_53743', 'modelname_54219',
'modelname_54223', 'modelname_54504',
'modelname_54507', 'modelname_54527',
'modelname_55067', 'modelname_55515',
'modelname_55539', 'modelname_55737',
'modelname_56090', 'serie_35078',
'serie_36316', 'serie_36317', 'serie_56140'
)
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_65','materialgruppierung_23844','sparset_filter_0','serie_53664','groesse_1010','groesse_1011','groesse_1013','groesse_35132','groesse_35133','serie_36315','groesse_1012','groesse_13436','muster_474','muster_33280','serie_36319','serie_36641','groesse_13435','muster_30451','serie_56594','beschriftungssprache_25379','groesse_14207','jahressymbol_37323','modelname_22864','modelname_34673','modelname_35065','modelname_35175','modelname_35178','modelname_35179','modelname_35310','modelname_35311','modelname_35921','modelname_36542','modelname_36652','modelname_36711','modelname_36773','modelname_36775','modelname_37420','modelname_37926','modelname_38245','modelname_38981','modelname_39482','modelname_40022','modelname_40158','modelname_40160','modelname_40162','modelname_41135','modelname_42798','modelname_43039','modelname_44174','modelname_44986','modelname_50802','modelname_53405','modelname_53414','modelname_53431','modelname_53743','modelname_54219','modelname_54223','modelname_54504','modelname_54507','modelname_54527','modelname_55067','modelname_55515','modelname_55539','modelname_55737','modelname_56090','serie_35078','serie_36316','serie_36317','serie_56140') AND a.is_filterable = true;
|