3
0.29 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' , 'verpackung_3948' , 'groesse_3393' , 'netto_gewicht_filter_3' , 'groesse_3394' , 'netto_gewicht_filter_5' , 'farbgruppierung_579' , 'geschlecht_65' , 'serie_53664' , 'feiertage_822' , 'feiertage_826' , 'farbgruppierung_578' , 'geschlecht_66' , 'feiertage_960' , 'feiertage_819' , 'feiertage_825' , 'beschriftungssprache_25379' , 'feiertage_823' , 'inschrift_22369' , 'inschrift_22370' , 'inschrift_23488' , 'modelname_22823' , 'modelname_22824' , 'modelname_22825' , 'modelname_22826' , 'modelname_22827' , 'modelname_22828' , 'modelname_32417' , 'modelname_32418' , 'modelname_32419' , 'modelname_32420' , 'modelname_32421' , 'modelname_32423' , 'modelname_32424' , 'modelname_32425' , 'modelname_36717' , 'geschlecht_69' , 'inschrift_22440' , 'inschrift_32549' , 'inschrift_32557' , 'modelname_32422' , 'inschrift_22405' , 'inschrift_32534' , 'inschrift_32551' , 'inschrift_32558' , 'inschrift_32559' , 'serie_55565' , 'art_26280' , 'art_26281' , 'farbgruppierung_576' , 'geschlecht_68' , 'inschrift_22385' , 'inschrift_26753' , 'modelname_24471' , 'modelname_24472' , 'modelname_24501' , 'modelname_24661' , 'modelname_25372' , 'modelname_25636' , 'modelname_25652' , 'modelname_25660' , 'modelname_26359' , 'modelname_30251' , 'modelname_30252' , 'modelname_30305' , 'modelname_32482' , 'modelname_32483' , 'modelname_32486' , 'modelname_32490' , 'modelname_32492' , 'modelname_32506' , 'modelname_32510' , 'modelname_32511' , 'modelname_32516' , 'modelname_32521' , 'modelname_32523' , 'modelname_32524' , 'modelname_32525' , 'modelname_32537' , 'modelname_32538' , 'modelname_32539' , 'modelname_32540' , 'modelname_32541' , 'modelname_32542' , 'modelname_32544' , 'modelname_32545' , 'modelname_32546' , 'modelname_32547' , 'modelname_32548' , 'modelname_32550' , 'modelname_32552' , 'modelname_32553' , 'modelname_32554' , 'modelname_32555' , 'modelname_32556' , 'modelname_41231' , 'modelname_41233' , 'modelname_53421' , 'modelname_53431' , 'modelname_53732' , 'modelname_53737' , 'modelname_53739' , 'modelname_53742' , 'modelname_54532' , 'modelname_54534' , 'modelname_54536' , 'modelname_54587' , 'modelname_54588' , 'modelname_54589' , 'modelname_54590' , 'modelname_54591' , 'modelname_55321' , 'modelname_55323' , 'modelname_55324' , 'modelname_55328' , 'modelname_55329' , 'modelname_55330' , 'modelname_55351' , 'modelname_55353' , 'modelname_55354' , 'modelname_55355' , 'modelname_55356' , 'modelname_55357' , 'modelname_55358' , 'modelname_55359' , 'modelname_55360' , 'modelname_55362' , 'modelname_55363' , 'modelname_55364' , 'modelname_55499' , 'modelname_55501' , 'modelname_55506' , 'modelname_55515' , 'modelname_55521' , 'modelname_55522' , 'modelname_55526' , 'modelname_55530' , 'modelname_55532' , 'modelname_55534' , 'modelname_55535' , 'modelname_55542' , 'modelname_55547' , 'modelname_55548' , 'modelname_55551' , 'modelname_55554' , 'modelname_55557' , 'modelname_55573' , 'modelname_55574' , 'modelname_55588' , 'modelname_55589' , 'modelname_55590' , 'modelname_55591' , 'modelname_55592' ) 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' ,
'verpackung_3948' ,
'groesse_3393' ,
'netto_gewicht_filter_3' ,
'groesse_3394' ,
'netto_gewicht_filter_5' ,
'farbgruppierung_579' ,
'geschlecht_65' ,
'serie_53664' ,
'feiertage_822' ,
'feiertage_826' ,
'farbgruppierung_578' ,
'geschlecht_66' ,
'feiertage_960' ,
'feiertage_819' ,
'feiertage_825' ,
'beschriftungssprache_25379' ,
'feiertage_823' ,
'inschrift_22369' ,
'inschrift_22370' ,
'inschrift_23488' ,
'modelname_22823' ,
'modelname_22824' ,
'modelname_22825' ,
'modelname_22826' ,
'modelname_22827' ,
'modelname_22828' ,
'modelname_32417' ,
'modelname_32418' ,
'modelname_32419' ,
'modelname_32420' ,
'modelname_32421' ,
'modelname_32423' ,
'modelname_32424' ,
'modelname_32425' ,
'modelname_36717' ,
'geschlecht_69' ,
'inschrift_22440' ,
'inschrift_32549' ,
'inschrift_32557' ,
'modelname_32422' ,
'inschrift_22405' ,
'inschrift_32534' ,
'inschrift_32551' ,
'inschrift_32558' ,
'inschrift_32559' ,
'serie_55565' ,
'art_26280' ,
'art_26281' ,
'farbgruppierung_576' ,
'geschlecht_68' ,
'inschrift_22385' ,
'inschrift_26753' ,
'modelname_24471' ,
'modelname_24472' ,
'modelname_24501' ,
'modelname_24661' ,
'modelname_25372' ,
'modelname_25636' ,
'modelname_25652' ,
'modelname_25660' ,
'modelname_26359' ,
'modelname_30251' ,
'modelname_30252' ,
'modelname_30305' ,
'modelname_32482' ,
'modelname_32483' ,
'modelname_32486' ,
'modelname_32490' ,
'modelname_32492' ,
'modelname_32506' ,
'modelname_32510' ,
'modelname_32511' ,
'modelname_32516' ,
'modelname_32521' ,
'modelname_32523' ,
'modelname_32524' ,
'modelname_32525' ,
'modelname_32537' ,
'modelname_32538' ,
'modelname_32539' ,
'modelname_32540' ,
'modelname_32541' ,
'modelname_32542' ,
'modelname_32544' ,
'modelname_32545' ,
'modelname_32546' ,
'modelname_32547' ,
'modelname_32548' ,
'modelname_32550' ,
'modelname_32552' ,
'modelname_32553' ,
'modelname_32554' ,
'modelname_32555' ,
'modelname_32556' ,
'modelname_41231' ,
'modelname_41233' ,
'modelname_53421' ,
'modelname_53431' ,
'modelname_53732' ,
'modelname_53737' ,
'modelname_53739' ,
'modelname_53742' ,
'modelname_54532' ,
'modelname_54534' ,
'modelname_54536' ,
'modelname_54587' ,
'modelname_54588' ,
'modelname_54589' ,
'modelname_54590' ,
'modelname_54591' ,
'modelname_55321' ,
'modelname_55323' ,
'modelname_55324' ,
'modelname_55328' ,
'modelname_55329' ,
'modelname_55330' ,
'modelname_55351' ,
'modelname_55353' ,
'modelname_55354' ,
'modelname_55355' ,
'modelname_55356' ,
'modelname_55357' ,
'modelname_55358' ,
'modelname_55359' ,
'modelname_55360' ,
'modelname_55362' ,
'modelname_55363' ,
'modelname_55364' ,
'modelname_55499' ,
'modelname_55501' ,
'modelname_55506' ,
'modelname_55515' ,
'modelname_55521' ,
'modelname_55522' ,
'modelname_55526' ,
'modelname_55530' ,
'modelname_55532' ,
'modelname_55534' ,
'modelname_55535' ,
'modelname_55542' ,
'modelname_55547' ,
'modelname_55548' ,
'modelname_55551' ,
'modelname_55554' ,
'modelname_55557' ,
'modelname_55573' ,
'modelname_55574' ,
'modelname_55588' ,
'modelname_55589' ,
'modelname_55590' ,
'modelname_55591' ,
'modelname_55592'
)
AND a . is_filterable = true
Copy
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' , 'verpackung_3948' , 'groesse_3393' , 'netto_gewicht_filter_3' , 'groesse_3394' , 'netto_gewicht_filter_5' , 'farbgruppierung_579' , 'geschlecht_65' , 'serie_53664' , 'feiertage_822' , 'feiertage_826' , 'farbgruppierung_578' , 'geschlecht_66' , 'feiertage_960' , 'feiertage_819' , 'feiertage_825' , 'beschriftungssprache_25379' , 'feiertage_823' , 'inschrift_22369' , 'inschrift_22370' , 'inschrift_23488' , 'modelname_22823' , 'modelname_22824' , 'modelname_22825' , 'modelname_22826' , 'modelname_22827' , 'modelname_22828' , 'modelname_32417' , 'modelname_32418' , 'modelname_32419' , 'modelname_32420' , 'modelname_32421' , 'modelname_32423' , 'modelname_32424' , 'modelname_32425' , 'modelname_36717' , 'geschlecht_69' , 'inschrift_22440' , 'inschrift_32549' , 'inschrift_32557' , 'modelname_32422' , 'inschrift_22405' , 'inschrift_32534' , 'inschrift_32551' , 'inschrift_32558' , 'inschrift_32559' , 'serie_55565' , 'art_26280' , 'art_26281' , 'farbgruppierung_576' , 'geschlecht_68' , 'inschrift_22385' , 'inschrift_26753' , 'modelname_24471' , 'modelname_24472' , 'modelname_24501' , 'modelname_24661' , 'modelname_25372' , 'modelname_25636' , 'modelname_25652' , 'modelname_25660' , 'modelname_26359' , 'modelname_30251' , 'modelname_30252' , 'modelname_30305' , 'modelname_32482' , 'modelname_32483' , 'modelname_32486' , 'modelname_32490' , 'modelname_32492' , 'modelname_32506' , 'modelname_32510' , 'modelname_32511' , 'modelname_32516' , 'modelname_32521' , 'modelname_32523' , 'modelname_32524' , 'modelname_32525' , 'modelname_32537' , 'modelname_32538' , 'modelname_32539' , 'modelname_32540' , 'modelname_32541' , 'modelname_32542' , 'modelname_32544' , 'modelname_32545' , 'modelname_32546' , 'modelname_32547' , 'modelname_32548' , 'modelname_32550' , 'modelname_32552' , 'modelname_32553' , 'modelname_32554' , 'modelname_32555' , 'modelname_32556' , 'modelname_41231' , 'modelname_41233' , 'modelname_53421' , 'modelname_53431' , 'modelname_53732' , 'modelname_53737' , 'modelname_53739' , 'modelname_53742' , 'modelname_54532' , 'modelname_54534' , 'modelname_54536' , 'modelname_54587' , 'modelname_54588' , 'modelname_54589' , 'modelname_54590' , 'modelname_54591' , 'modelname_55321' , 'modelname_55323' , 'modelname_55324' , 'modelname_55328' , 'modelname_55329' , 'modelname_55330' , 'modelname_55351' , 'modelname_55353' , 'modelname_55354' , 'modelname_55355' , 'modelname_55356' , 'modelname_55357' , 'modelname_55358' , 'modelname_55359' , 'modelname_55360' , 'modelname_55362' , 'modelname_55363' , 'modelname_55364' , 'modelname_55499' , 'modelname_55501' , 'modelname_55506' , 'modelname_55515' , 'modelname_55521' , 'modelname_55522' , 'modelname_55526' , 'modelname_55530' , 'modelname_55532' , 'modelname_55534' , 'modelname_55535' , 'modelname_55542' , 'modelname_55547' , 'modelname_55548' , 'modelname_55551' , 'modelname_55554' , 'modelname_55557' , 'modelname_55573' , 'modelname_55574' , 'modelname_55588' , 'modelname_55589' , 'modelname_55590' , 'modelname_55591' , 'modelname_55592' ) AND a . is_filterable = true ;
Copy