SELECT
P.customers_profiles_id as id,
PD.customers_profiles_name as name,
PD.customers_profiles_text as text,
P.customers_profiles_color as color,
P.customers_profiles_color_claro as colorClaro,
P.customers_profiles_color_texto as colorTexto,
P.es_publico,
P.activo
FROM customers_groups_profiles P
JOIN customers_groups_profiles_description PD ON
P.customers_profiles_id = '0' AND P.customers_profiles_id = PD.customers_profiles_id AND PD.language_id = '4'