This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36200 | 36200 | cc5ed | 2969 2969 |
| 36201 | 36201 | cb80d | 2969 2969 |
| 36202 | 36202 | 371f0 | 2969 2969 |
| 36203 | 36203 | 59d75 | 2969 2969 |
| 36204 | 36204 | e6200 | 2969 2969 |
| 36205 | 36205 | b1201 | 2969 2969 |
| 36206 | 36206 | 902e5 | 2969 2969 |
| 36207 | 36207 | bc1ac | 2969 2969 |
| 36208 | 36208 | b918e | 2969 2969 |
| 36209 | 36209 | 5b456 | 2969 2969 |
| 36210 | 36210 | 72d8e | 2969 2969 |
| 36211 | 36211 | 77d7e | 2969 2969 |
| 36212 | 36212 | c46d7 | 2969 2969 |
| 36213 | 36213 | e5437 | 2969 2969 |
| 36214 | 36214 | 1fd76 | 2969 2969 |
| 36215 | 36215 | 469ba | 2969 2969 |
| 36216 | 36216 | feaa7 | 2969 2969 |
| 36217 | 36217 | b0879 | 2969 2969 |
| 36218 | 36218 | 927de | 2969 2969 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)