This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1792 | 1792 | ec3ac | 1074 1074 |
| 1793 | 1793 | 17183 | 1074 1074 |
| 1794 | 1794 | 96bbd | 1074 1074 |
| 1795 | 1795 | 550f6 | 1074 1074 |
| 1796 | 1796 | 343d8 | 1074 1074 |
| 1797 | 1797 | 313af | 1074 1074 |
| 1798 | 1798 | f9cc2 | 1074 1074 |
| 1799 | 1799 | aabe0 | 1074 1074 |
| 1800 | 1800 | 3e5f6 | 1074 1074 |
| 1801 | 1801 | 87fac | 1074 1074 |
| 1802 | 1802 | 1073c | 1074 1074 |
| 1803 | 1803 | 4801f | 1074 1074 |
| 1804 | 1804 | 5e075 | 1074 1074 |
| 1805 | 1805 | 59d75 | 1074 1074 |
| 1806 | 1806 | e6200 | 1074 1074 |
| 1807 | 1807 | b1201 | 1074 1074 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)