This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8832 | 8832 | f5427 | 20 20 |
| 8931 | 8931 | f5427 | 28 28 |
| 8989 | 8989 | f5427 | 1886 1886 |
| 9244 | 9244 | f5427 | 1689 1689 |
| 9308 | 9308 | f5427 | 1896 1896 |
| 9313 | 9313 | f5427 | 37 37 |
| 9443 | 9443 | f5427 | 1687 1687 |
| 12801 | 12801 | f5427 | 1488 1488 |
| 12850 | 12850 | f5427 | 618 618 |
| 12881 | 12881 | f5427 | 617 617 |
| 12896 | 12896 | f5427 | 619 619 |
| 13209 | 13209 | f5427 | 564 564 |
| 13876 | 13876 | f5427 | 1931 1931 |
| 14321 | 14321 | f5427 | 1487 1487 |
| 14572 | 14572 | f5427 | 624 624 |
| 15001 | 15001 | f5427 | 620 620 |
| 15248 | 15248 | f5427 | 16 16 |
| 15467 | 15467 | f5427 | 1877 1877 |
| 33516 | 33516 | f5427 | 1918 1918 |
| 33626 | 33626 | f5427 | 1880 1880 |
| 34068 | 34068 | f5427 | 40 40 |
| 34218 | 34218 | f5427 | 1921 1921 |
| 34395 | 34395 | f5427 | 1928 1928 |
| 34433 | 34433 | f5427 | 38 38 |
| 34455 | 34455 | f5427 | 1935 1935 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)