This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34982 | 34982 | ec3ac | 12 12 |
| 34983 | 34983 | 371f0 | 12 12 |
| 34984 | 34984 | 59d75 | 12 12 |
| 34985 | 34985 | 3502d | 12 12 |
| 34986 | 34986 | 8a7ee | 12 12 |
| 34987 | 34987 | 862ed | 12 12 |
| 34988 | 34988 | 18a64 | 12 12 |
| 34989 | 34989 | 5ea35 | 12 12 |
| 34990 | 34990 | d65e1 | 12 12 |
| 34991 | 34991 | 7c38f | 12 12 |
| 34992 | 34992 | 6f328 | 12 12 |
| 34993 | 34993 | d1aa5 | 12 12 |
| 34994 | 34994 | 2ce65 | 12 12 |
| 34995 | 34995 | 27369 | 12 12 |
| 34996 | 34996 | d75c0 | 12 12 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)