This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12920 | 12920 | b825d | 1599 1599 |
13039 | 13039 | b825d | 1587 1587 |
13595 | 13595 | b825d | 1579 1579 |
13825 | 13825 | b825d | 1462 1462 |
13954 | 13954 | b825d | 1583 1583 |
14005 | 14005 | b825d | 1595 1595 |
14136 | 14136 | b825d | 1607 1607 |
14483 | 14483 | b825d | 1591 1591 |
15212 | 15212 | b825d | 1575 1575 |
15351 | 15351 | b825d | 1603 1603 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )