This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23024 | 23024 | cc5ed | 2901 2901 |
| 23025 | 23025 | c1190 | 2901 2901 |
| 23026 | 23026 | cb80d | 2901 2901 |
| 23027 | 23027 | 371f0 | 2901 2901 |
| 23028 | 23028 | bf1e7 | 2901 2901 |
| 23029 | 23029 | e6200 | 2901 2901 |
| 23030 | 23030 | b1201 | 2901 2901 |
| 23031 | 23031 | 902e5 | 2901 2901 |
| 23032 | 23032 | b918e | 2901 2901 |
| 23033 | 23033 | 46d55 | 2901 2901 |
| 23034 | 23034 | 597b7 | 2901 2901 |
| 23035 | 23035 | 0e9bf | 2901 2901 |
| 23036 | 23036 | edcd8 | 2901 2901 |
| 23037 | 23037 | 22093 | 2901 2901 |
| 23038 | 23038 | e0e2d | 2901 2901 |
| 23039 | 23039 | 561d9 | 2901 2901 |
| 23040 | 23040 | 1fd76 | 2901 2901 |
| 23041 | 23041 | f478a | 2901 2901 |
| 23042 | 23042 | 83826 | 2901 2901 |
| 23043 | 23043 | 56bb6 | 2901 2901 |
| 23044 | 23044 | 927de | 2901 2901 |
| 23045 | 23045 | 35c78 | 2901 2901 |
| 23046 | 23046 | fd049 | 2901 2901 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)