This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 14795 | 14795 | 90d27 | 1232 1232 |
| 14796 | 14796 | f4921 | 1232 1232 |
| 14797 | 14797 | d02ec | 1232 1232 |
| 14798 | 14798 | a06cb | 1232 1232 |
| 14799 | 14799 | 87fac | 1232 1232 |
| 14800 | 14800 | 7ceb1 | 1232 1232 |
| 14801 | 14801 | 48a97 | 1232 1232 |
| 14802 | 14802 | 4a08c | 1232 1232 |
| 14803 | 14803 | 5e075 | 1232 1232 |
| 14804 | 14804 | 59d75 | 1232 1232 |
| 14805 | 14805 | e6200 | 1232 1232 |
| 14806 | 14806 | b1201 | 1232 1232 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)