This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 836 | 836 | ec3ac | 3179 3179 |
| 837 | 837 | 13c3e | 3179 3179 |
| 838 | 838 | 371f0 | 3179 3179 |
| 839 | 839 | e6200 | 3179 3179 |
| 840 | 840 | b1201 | 3179 3179 |
| 841 | 841 | 902e5 | 3179 3179 |
| 842 | 842 | bc1ac | 3179 3179 |
| 843 | 843 | 6ec75 | 3179 3179 |
| 844 | 844 | 5b456 | 3179 3179 |
| 845 | 845 | 77d7e | 3179 3179 |
| 846 | 846 | c46d7 | 3179 3179 |
| 847 | 847 | e5437 | 3179 3179 |
| 848 | 848 | b3b48 | 3179 3179 |
| 849 | 849 | 469ba | 3179 3179 |
| 850 | 850 | feaa7 | 3179 3179 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)