This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28910 | 28910 | cc5ed | 3073 3073 |
| 28911 | 28911 | 7b150 | 3073 3073 |
| 28912 | 28912 | e6200 | 3073 3073 |
| 28913 | 28913 | b1201 | 3073 3073 |
| 28914 | 28914 | 8a7ee | 3073 3073 |
| 28915 | 28915 | 862ed | 3073 3073 |
| 28916 | 28916 | b8d0a | 3073 3073 |
| 28917 | 28917 | df1f0 | 3073 3073 |
| 28918 | 28918 | 1d2ab | 3073 3073 |
| 28919 | 28919 | f431c | 3073 3073 |
| 28920 | 28920 | c8e9f | 3073 3073 |
| 28921 | 28921 | 27369 | 3073 3073 |
| 28922 | 28922 | 04629 | 3073 3073 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)