This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7491 | 7491 | cc5ed | 2818 2818 |
| 7492 | 7492 | 27335 | 2818 2818 |
| 7493 | 7493 | 61c1a | 2818 2818 |
| 7494 | 7494 | e6200 | 2818 2818 |
| 7495 | 7495 | b1201 | 2818 2818 |
| 7496 | 7496 | 902e5 | 2818 2818 |
| 7497 | 7497 | ddd45 | 2818 2818 |
| 7498 | 7498 | 8a7ee | 2818 2818 |
| 7499 | 7499 | 862ed | 2818 2818 |
| 7500 | 7500 | f32e5 | 2818 2818 |
| 7501 | 7501 | da17a | 2818 2818 |
| 7502 | 7502 | 18a64 | 2818 2818 |
| 7503 | 7503 | d65e1 | 2818 2818 |
| 7504 | 7504 | f788a | 2818 2818 |
| 7505 | 7505 | 7c38f | 2818 2818 |
| 7506 | 7506 | d1aa5 | 2818 2818 |
| 7507 | 7507 | 809af | 2818 2818 |
| 7508 | 7508 | abb72 | 2818 2818 |
| 7509 | 7509 | 2ce65 | 2818 2818 |
| 7510 | 7510 | 27369 | 2818 2818 |
| 7511 | 7511 | aeeb4 | 2818 2818 |
| 7512 | 7512 | 1518e | 2818 2818 |
| 7513 | 7513 | a640b | 2818 2818 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)