This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28967 | 28967 | cc5ed | 3061 3061 |
| 28968 | 28968 | 371f0 | 3061 3061 |
| 28969 | 28969 | e6200 | 3061 3061 |
| 28970 | 28970 | b1201 | 3061 3061 |
| 28971 | 28971 | 8a7ee | 3061 3061 |
| 28972 | 28972 | 862ed | 3061 3061 |
| 28973 | 28973 | 4a30c | 3061 3061 |
| 28974 | 28974 | df1f0 | 3061 3061 |
| 28975 | 28975 | a1307 | 3061 3061 |
| 28976 | 28976 | 8d2e9 | 3061 3061 |
| 28977 | 28977 | c8e9f | 3061 3061 |
| 28978 | 28978 | 27369 | 3061 3061 |
| 28979 | 28979 | 04629 | 3061 3061 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)