This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20857 | 20857 | cc5ed | 762 762 |
| 20858 | 20858 | 72597 | 762 762 |
| 20859 | 20859 | 685a3 | 762 762 |
| 20860 | 20860 | 5e075 | 762 762 |
| 20861 | 20861 | 59d75 | 762 762 |
| 20862 | 20862 | e6200 | 762 762 |
| 20863 | 20863 | b1201 | 762 762 |
| 20864 | 20864 | 902e5 | 762 762 |
| 20865 | 20865 | 32dc0 | 762 762 |
| 20866 | 20866 | 9b74f | 762 762 |
| 20867 | 20867 | 801ee | 762 762 |
| 20868 | 20868 | 6e094 | 762 762 |
| 20869 | 20869 | a58bf | 762 762 |
| 20870 | 20870 | f6c8c | 762 762 |
| 20871 | 20871 | 263b7 | 762 762 |
| 20872 | 20872 | a397c | 762 762 |
| 20873 | 20873 | 99241 | 762 762 |
| 20874 | 20874 | 9ab3b | 762 762 |
| 20875 | 20875 | 7db8c | 762 762 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)