This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12330 | 12330 | ec3ac | 1937 1937 |
| 12331 | 12331 | d1e7b | 1937 1937 |
| 12332 | 12332 | 3502d | 1937 1937 |
| 12333 | 12333 | b07dd | 1937 1937 |
| 12334 | 12334 | 2095d | 1937 1937 |
| 12335 | 12335 | a58bf | 1937 1937 |
| 12336 | 12336 | 13540 | 1937 1937 |
| 12337 | 12337 | e08c6 | 1937 1937 |
| 12338 | 12338 | 7e7c6 | 1937 1937 |
| 12339 | 12339 | 326e8 | 1937 1937 |
| 12340 | 12340 | 77892 | 1937 1937 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)