This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11288 | 11288 | 7a351 | 897 897 |
| 11381 | 11381 | 7a351 | 837 837 |
| 15293 | 15293 | 7a351 | 869 869 |
| 33444 | 33444 | 7a351 | 921 921 |
| 33670 | 33670 | 7a351 | 918 918 |
| 33699 | 33699 | 7a351 | 922 922 |
| 33744 | 33744 | 7a351 | 923 923 |
| 33787 | 33787 | 7a351 | 817 817 |
| 33830 | 33830 | 7a351 | 831 831 |
| 33873 | 33873 | 7a351 | 778 778 |
| 33929 | 33929 | 7a351 | 812 812 |
| 33986 | 33986 | 7a351 | 911 911 |
| 34005 | 34005 | 7a351 | 915 915 |
| 34262 | 34262 | 7a351 | 791 791 |
| 34318 | 34318 | 7a351 | 783 783 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)