This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15988 | 15988 | cc5ed | 3307 3307 |
| 15989 | 15989 | 371f0 | 3307 3307 |
| 15990 | 15990 | e6200 | 3307 3307 |
| 15991 | 15991 | b1201 | 3307 3307 |
| 15992 | 15992 | 3fdd1 | 3307 3307 |
| 15993 | 15993 | dd2b6 | 3307 3307 |
| 15994 | 15994 | 84ef3 | 3307 3307 |
| 15995 | 15995 | 177f3 | 3307 3307 |
| 15996 | 15996 | d0dd5 | 3307 3307 |
| 15997 | 15997 | bb729 | 3307 3307 |
| 15998 | 15998 | cde92 | 3307 3307 |
| 15999 | 15999 | e9ff1 | 3307 3307 |
| 16000 | 16000 | eb0d5 | 3307 3307 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)