This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5850 | 5850 | ec3ac | 2783 2783 |
| 5851 | 5851 | cba3e | 2783 2783 |
| 5852 | 5852 | 371f0 | 2783 2783 |
| 5853 | 5853 | 59d75 | 2783 2783 |
| 5854 | 5854 | e6200 | 2783 2783 |
| 5855 | 5855 | b1201 | 2783 2783 |
| 5856 | 5856 | 902e5 | 2783 2783 |
| 5857 | 5857 | 201fd | 2783 2783 |
| 5858 | 5858 | 4c549 | 2783 2783 |
| 5859 | 5859 | fca57 | 2783 2783 |
| 5860 | 5860 | 72c34 | 2783 2783 |
| 5861 | 5861 | 99241 | 2783 2783 |
| 5862 | 5862 | 07b46 | 2783 2783 |
| 5863 | 5863 | d7acc | 2783 2783 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)