This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36003 | 36003 | cc5ed | 3513 3513 |
| 36004 | 36004 | fa635 | 3513 3513 |
| 36005 | 36005 | e6200 | 3513 3513 |
| 36006 | 36006 | b1201 | 3513 3513 |
| 36007 | 36007 | a48a7 | 3513 3513 |
| 36008 | 36008 | dfca7 | 3513 3513 |
| 36009 | 36009 | c30e5 | 3513 3513 |
| 36010 | 36010 | 33643 | 3513 3513 |
| 36011 | 36011 | a65c5 | 3513 3513 |
| 36012 | 36012 | e456e | 3513 3513 |
| 36013 | 36013 | aff2c | 3513 3513 |
| 36014 | 36014 | bbd8e | 3513 3513 |
| 36015 | 36015 | 8bae1 | 3513 3513 |
| 36016 | 36016 | 4bc77 | 3513 3513 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)