This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5922 | 5922 | ec3ac | 3004 3004 |
| 5923 | 5923 | 6060b | 3004 3004 |
| 5924 | 5924 | 371f0 | 3004 3004 |
| 5925 | 5925 | 59d75 | 3004 3004 |
| 5926 | 5926 | e6200 | 3004 3004 |
| 5927 | 5927 | b1201 | 3004 3004 |
| 5928 | 5928 | 902e5 | 3004 3004 |
| 5929 | 5929 | 8a7ee | 3004 3004 |
| 5930 | 5930 | 862ed | 3004 3004 |
| 5931 | 5931 | 6a9d7 | 3004 3004 |
| 5932 | 5932 | 225c8 | 3004 3004 |
| 5933 | 5933 | e4b8e | 3004 3004 |
| 5934 | 5934 | 74a3a | 3004 3004 |
| 5935 | 5935 | d827a | 3004 3004 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)