This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29676 | 29676 | cc5ed | 2967 2967 |
| 29677 | 29677 | cb80d | 2967 2967 |
| 29678 | 29678 | 371f0 | 2967 2967 |
| 29679 | 29679 | 5e075 | 2967 2967 |
| 29680 | 29680 | 59d75 | 2967 2967 |
| 29681 | 29681 | e6200 | 2967 2967 |
| 29682 | 29682 | b1201 | 2967 2967 |
| 29683 | 29683 | 902e5 | 2967 2967 |
| 29684 | 29684 | 6ec75 | 2967 2967 |
| 29685 | 29685 | dbf07 | 2967 2967 |
| 29686 | 29686 | a40b9 | 2967 2967 |
| 29687 | 29687 | 25d0f | 2967 2967 |
| 29688 | 29688 | 06d39 | 2967 2967 |
| 29689 | 29689 | 4fcc4 | 2967 2967 |
| 29690 | 29690 | 35c78 | 2967 2967 |
| 29691 | 29691 | af0a7 | 2967 2967 |
| 29692 | 29692 | 09b01 | 2967 2967 |
| 29693 | 29693 | 87529 | 2967 2967 |
| 29694 | 29694 | 04182 | 2967 2967 |
| 29695 | 29695 | d6846 | 2967 2967 |
| 29696 | 29696 | a7f5a | 2967 2967 |
| 29697 | 29697 | 8e14c | 2967 2967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)