This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12415 | 12415 | 16071 | 1239 1239 |
| 12442 | 12442 | 16071 | 776 776 |
| 33365 | 33365 | 16071 | 827 827 |
| 33403 | 33403 | 16071 | 820 820 |
| 33469 | 33469 | 16071 | 794 794 |
| 33485 | 33485 | 16071 | 854 854 |
| 33501 | 33501 | 16071 | 836 836 |
| 33512 | 33512 | 16071 | 848 848 |
| 33534 | 33534 | 16071 | 855 855 |
| 33568 | 33568 | 16071 | 829 829 |
| 33644 | 33644 | 16071 | 773 773 |
| 33660 | 33660 | 16071 | 840 840 |
| 33820 | 33820 | 16071 | 825 825 |
| 33863 | 33863 | 16071 | 779 779 |
| 33953 | 33953 | 16071 | 816 816 |
| 34086 | 34086 | 16071 | 39 39 |
| 34097 | 34097 | 16071 | 789 789 |
| 34123 | 34123 | 16071 | 814 814 |
| 34139 | 34139 | 16071 | 828 828 |
| 34214 | 34214 | 16071 | 910 910 |
| 34236 | 34236 | 16071 | 806 806 |
| 34252 | 34252 | 16071 | 815 815 |
| 34286 | 34286 | 16071 | 813 813 |
| 34308 | 34308 | 16071 | 795 795 |
| 34342 | 34342 | 16071 | 797 797 |
| 34392 | 34392 | 16071 | 808 808 |
| 34413 | 34413 | 16071 | 792 792 |
| 34429 | 34429 | 16071 | 796 796 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)