This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22678 | 22678 | 9c17e | 3368 3368 |
| 22679 | 22679 | 371f0 | 3368 3368 |
| 22680 | 22680 | 5e075 | 3368 3368 |
| 22681 | 22681 | 59d75 | 3368 3368 |
| 22682 | 22682 | e6200 | 3368 3368 |
| 22683 | 22683 | b1201 | 3368 3368 |
| 22684 | 22684 | 8a7ee | 3368 3368 |
| 22685 | 22685 | 862ed | 3368 3368 |
| 22686 | 22686 | ebf60 | 3368 3368 |
| 22687 | 22687 | 18a64 | 3368 3368 |
| 22688 | 22688 | d5ec6 | 3368 3368 |
| 22689 | 22689 | 66f82 | 3368 3368 |
| 22690 | 22690 | f788a | 3368 3368 |
| 22691 | 22691 | 7c38f | 3368 3368 |
| 22692 | 22692 | a5ab5 | 3368 3368 |
| 22693 | 22693 | a1307 | 3368 3368 |
| 22694 | 22694 | 809af | 3368 3368 |
| 22695 | 22695 | abb72 | 3368 3368 |
| 22696 | 22696 | 93975 | 3368 3368 |
| 22697 | 22697 | 27369 | 3368 3368 |
| 22698 | 22698 | 37724 | 3368 3368 |
| 22699 | 22699 | e128e | 3368 3368 |
| 22700 | 22700 | 80def | 3368 3368 |
| 22701 | 22701 | 9c206 | 3368 3368 |
| 22702 | 22702 | 7c580 | 3368 3368 |
| 22703 | 22703 | 724f8 | 3368 3368 |
| 22704 | 22704 | b6f60 | 3368 3368 |
| 22705 | 22705 | 06d39 | 3368 3368 |
| 22706 | 22706 | 2ab82 | 3368 3368 |
| 22707 | 22707 | 8b0bf | 3368 3368 |
| 22708 | 22708 | 01e8a | 3368 3368 |
| 22709 | 22709 | 2aa57 | 3368 3368 |
| 22710 | 22710 | 425d7 | 3368 3368 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)