Untitled

# lookup fields

select * from settings_lookup;
select * from settings_lookupfield;
select count(*) from settings_lookupfield;
390 rows

select label, value from settings_lookupfield where label ilike '%republika zie%';

Sa potworzenia w kazdym rekordzie. Zeby to zobaczyc:
```
SELECT 
	label, count(label)
FROM 
	settings_lookupfield
GROUP BY
	label
HAVING
	count(label)=2;
```

Deleting duplicate rows
```
DELETE FROM
	settings_lookupfield a
		USING settings_lookupfield b
WHERE
	a.id < b.id
	AND a.label = b.label;
```