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%')
;
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%')
;