This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13099 | 13099 | 8751c | 34 34 |
| 15257 | 15257 | 8751c | 16 16 |
| 15807 | 15807 | 8751c | 2794 2794 |
| 15881 | 15881 | 8751c | 2786 2786 |
| 16064 | 16064 | 8751c | 2787 2787 |
| 16102 | 16102 | 8751c | 2793 2793 |
| 16302 | 16302 | 8751c | 2785 2785 |
| 16713 | 16713 | 8751c | 2792 2792 |
| 16807 | 16807 | 8751c | 2782 2782 |
| 19436 | 19436 | 8751c | 3255 3255 |
| 34757 | 34757 | 8751c | 1840 1840 |
| 34871 | 34871 | 8751c | 1838 1838 |
| 34901 | 34901 | 8751c | 1837 1837 |
| 34914 | 34914 | 8751c | 1839 1839 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)