This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36522 | 36522 | cc5ed | 1253 1253 |
| 36523 | 36523 | 371f0 | 1253 1253 |
| 36524 | 36524 | e6200 | 1253 1253 |
| 36525 | 36525 | b1201 | 1253 1253 |
| 36526 | 36526 | 902e5 | 1253 1253 |
| 36527 | 36527 | 8123a | 1253 1253 |
| 36528 | 36528 | 172e0 | 1253 1253 |
| 36529 | 36529 | 45a71 | 1253 1253 |
| 36530 | 36530 | 5d37b | 1253 1253 |
| 36531 | 36531 | 70fc3 | 1253 1253 |
| 36532 | 36532 | 58753 | 1253 1253 |
| 36533 | 36533 | cf4f6 | 1253 1253 |
| 36534 | 36534 | e5c05 | 1253 1253 |
| 36535 | 36535 | c85cd | 1253 1253 |
| 36536 | 36536 | f5d72 | 1253 1253 |
| 36537 | 36537 | a0884 | 1253 1253 |
| 36538 | 36538 | 9eb05 | 1253 1253 |
| 36539 | 36539 | b8e89 | 1253 1253 |
| 36540 | 36540 | 37b83 | 1253 1253 |
| 36541 | 36541 | ff90c | 1253 1253 |
| 36542 | 36542 | 0335c | 1253 1253 |
| 36543 | 36543 | e1707 | 1253 1253 |
| 36544 | 36544 | e58e0 | 1253 1253 |
| 36545 | 36545 | 87070 | 1253 1253 |
| 36546 | 36546 | 79cab | 1253 1253 |
| 36547 | 36547 | 8152e | 1253 1253 |
| 36548 | 36548 | 2a1b9 | 1253 1253 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)