This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22994 | 22994 | cc5ed | 2953 2953 |
| 22995 | 22995 | c1190 | 2953 2953 |
| 22996 | 22996 | cb80d | 2953 2953 |
| 22997 | 22997 | 371f0 | 2953 2953 |
| 22998 | 22998 | bf1e7 | 2953 2953 |
| 22999 | 22999 | e6200 | 2953 2953 |
| 23000 | 23000 | b1201 | 2953 2953 |
| 23001 | 23001 | 902e5 | 2953 2953 |
| 23002 | 23002 | bc1ac | 2953 2953 |
| 23003 | 23003 | 6ec75 | 2953 2953 |
| 23004 | 23004 | 5b456 | 2953 2953 |
| 23005 | 23005 | 77d7e | 2953 2953 |
| 23006 | 23006 | 469ba | 2953 2953 |
| 23007 | 23007 | b4bbb | 2953 2953 |
| 23008 | 23008 | 1aa29 | 2953 2953 |
| 23009 | 23009 | b0c29 | 2953 2953 |
| 23010 | 23010 | 87529 | 2953 2953 |
| 23011 | 23011 | 1d7a4 | 2953 2953 |
| 23012 | 23012 | 266f1 | 2953 2953 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)