This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28958 | 28958 | 189ac | 2362 2362 |
28959 | 28959 | d6ade | 2362 2362 |
28960 | 28960 | 8e7b3 | 2362 2362 |
28961 | 28961 | 313af | 2362 2362 |
28962 | 28962 | ebe26 | 2362 2362 |
28963 | 28963 | a0f55 | 2362 2362 |
28964 | 28964 | 371f0 | 2362 2362 |
28965 | 28965 | e6200 | 2362 2362 |
28966 | 28966 | b1201 | 2362 2362 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )