This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15852 | 15852 | a8e8b | 3376 3376 |
| 15853 | 15853 | 7b150 | 3376 3376 |
| 15854 | 15854 | 5e075 | 3376 3376 |
| 15855 | 15855 | 59d75 | 3376 3376 |
| 15856 | 15856 | e6200 | 3376 3376 |
| 15857 | 15857 | b1201 | 3376 3376 |
| 15858 | 15858 | 91693 | 3376 3376 |
| 15859 | 15859 | 1d2ab | 3376 3376 |
| 15860 | 15860 | abb72 | 3376 3376 |
| 15861 | 15861 | 27369 | 3376 3376 |
| 15862 | 15862 | 9c206 | 3376 3376 |
| 15863 | 15863 | 7c580 | 3376 3376 |
| 15864 | 15864 | 724f8 | 3376 3376 |
| 15865 | 15865 | b6f60 | 3376 3376 |
| 15866 | 15866 | 6d811 | 3376 3376 |
| 15867 | 15867 | 39ce1 | 3376 3376 |
| 15868 | 15868 | 8b0bf | 3376 3376 |
| 15869 | 15869 | 01e8a | 3376 3376 |
| 15870 | 15870 | 2aa57 | 3376 3376 |
| 15871 | 15871 | 425d7 | 3376 3376 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)