This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6551 | 6551 | cc5ed | 2504 2504 |
6552 | 6552 | 16102 | 2504 2504 |
6553 | 6553 | d6ade | 2504 2504 |
6554 | 6554 | 8e7b3 | 2504 2504 |
6555 | 6555 | 9d04d | 2504 2504 |
6556 | 6556 | 8da48 | 2504 2504 |
6557 | 6557 | e9db4 | 2504 2504 |
6558 | 6558 | f6590 | 2504 2504 |
6559 | 6559 | 2a6ea | 2504 2504 |
6560 | 6560 | 235b1 | 2504 2504 |
6561 | 6561 | a0f55 | 2504 2504 |
6562 | 6562 | cbcce | 2504 2504 |
6563 | 6563 | 1073c | 2504 2504 |
6564 | 6564 | 1c31d | 2504 2504 |
6565 | 6565 | e6200 | 2504 2504 |
6566 | 6566 | b1201 | 2504 2504 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )