Holistics-postgres public.tryber has lang materialized view
DISPLAYTITLE:Holistics-postgres public.tryber_has_lang materialized view
Query
with
tryber_rows as (
select
id,
wp_user_id
from
wp_appq_evd_profile
where
wp_user_id not in (select distinct wp_user_id from wp_appq_user_to_customer)
),
language_data as (
select
has.profile_id as profile_id,
lang.language,
lang.language_display_name[1] as language_display_name
from
wp_appq_profile_has_lang as has
left join (
select
id,
display_name as language,
string_to_array(display_name, ' ') as language_display_name
from
wp_appq_lang
)as lang on has.language_id = lang.id
)
select
t.id as tester_id,
ld.language,
ld.language_display_name
from
tryber_rows as t
left join language_data as ld on t.id = ld.profile_id
Keys and Indexes
CREATE INDEX tryberhaslang_index_testerid ON tryber_has_lang (tester_id);
CREATE INDEX tryberhaslang_index_language ON tryber_has_lang (language);
CREATE INDEX tryberhaslang_index_languagedisplayname ON tryber_has_lang (language_display_name);