This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 947 | 947 | b8c83 | 3142 3142 |
| 948 | 948 | 27335 | 3142 3142 |
| 949 | 949 | 371f0 | 3142 3142 |
| 950 | 950 | 59d75 | 3142 3142 |
| 951 | 951 | e6200 | 3142 3142 |
| 952 | 952 | b1201 | 3142 3142 |
| 953 | 953 | 902e5 | 3142 3142 |
| 954 | 954 | 8a7ee | 3142 3142 |
| 955 | 955 | 862ed | 3142 3142 |
| 956 | 956 | a1307 | 3142 3142 |
| 957 | 957 | abb72 | 3142 3142 |
| 958 | 958 | 27369 | 3142 3142 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)