This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25795 | 25795 | cc5ed | 2908 2908 |
| 25796 | 25796 | c1190 | 2908 2908 |
| 25797 | 25797 | cb80d | 2908 2908 |
| 25798 | 25798 | 371f0 | 2908 2908 |
| 25799 | 25799 | bf1e7 | 2908 2908 |
| 25800 | 25800 | e6200 | 2908 2908 |
| 25801 | 25801 | b1201 | 2908 2908 |
| 25802 | 25802 | 902e5 | 2908 2908 |
| 25803 | 25803 | bc1ac | 2908 2908 |
| 25804 | 25804 | 6ec75 | 2908 2908 |
| 25805 | 25805 | 5b456 | 2908 2908 |
| 25806 | 25806 | 77d7e | 2908 2908 |
| 25807 | 25807 | c46d7 | 2908 2908 |
| 25808 | 25808 | e5437 | 2908 2908 |
| 25809 | 25809 | 469ba | 2908 2908 |
| 25810 | 25810 | feaa7 | 2908 2908 |
| 25811 | 25811 | 1aa29 | 2908 2908 |
| 25812 | 25812 | b0c29 | 2908 2908 |
| 25813 | 25813 | 87529 | 2908 2908 |
| 25814 | 25814 | 1d7a4 | 2908 2908 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)