This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28800 | 28800 | ec3ac | 1129 1129 |
| 28801 | 28801 | 4801f | 1129 1129 |
| 28802 | 28802 | 5e075 | 1129 1129 |
| 28803 | 28803 | 59d75 | 1129 1129 |
| 28804 | 28804 | e6200 | 1129 1129 |
| 28805 | 28805 | b1201 | 1129 1129 |
| 28806 | 28806 | d6347 | 1129 1129 |
| 28807 | 28807 | ebf60 | 1129 1129 |
| 28808 | 28808 | 9a8c6 | 1129 1129 |
| 28809 | 28809 | 91693 | 1129 1129 |
| 28810 | 28810 | 1d2ab | 1129 1129 |
| 28811 | 28811 | abb72 | 1129 1129 |
| 28812 | 28812 | 41b26 | 1129 1129 |
| 28813 | 28813 | 2db78 | 1129 1129 |
| 28814 | 28814 | 6a38c | 1129 1129 |
| 28815 | 28815 | e128e | 1129 1129 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)