CRM_TG.sql

SELECT 
  c.id,c.state, 
  split_part(c.name,'(',2) AS contador,
  split_part(c.ref2,',',2) AS id_contador,
  c.description, 
  m.name 
FROM crm_case AS c 
LEFT JOIN giscedata_lectures_comptador m ON (m.id=split_part(c.ref2,',',2)::int) 
WHERE state='open' AND description LIKE '%lecturas_diferentes_encontradas%';