Help with query via the client API

SELECT *
FROM records AS r
JOIN cells AS c ON r.id = c."recordId"
WHERE 
      (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%Ams%')
  AND (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%TH%')
;