This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33735 | 33735 | ec3ac | 923 923 |
| 33736 | 33736 | b668a | 923 923 |
| 33737 | 33737 | aaf5a | 923 923 |
| 33738 | 33738 | 5e075 | 923 923 |
| 33739 | 33739 | 59d75 | 923 923 |
| 33740 | 33740 | e6200 | 923 923 |
| 33741 | 33741 | b1201 | 923 923 |
| 33742 | 33742 | 63e96 | 923 923 |
| 33743 | 33743 | 2fb27 | 923 923 |
| 33744 | 33744 | 7a351 | 923 923 |
| 33745 | 33745 | 0593a | 923 923 |
| 33746 | 33746 | eecd9 | 923 923 |
| 33747 | 33747 | 7ce59 | 923 923 |
| 33748 | 33748 | b8d0a | 923 923 |
| 33749 | 33749 | 3896c | 923 923 |
| 33750 | 33750 | a524c | 923 923 |
| 33751 | 33751 | 41ee7 | 923 923 |
| 33752 | 33752 | ed356 | 923 923 |
| 33753 | 33753 | 94bdc | 923 923 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)