This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24927 | 24927 | cc5ed | 2779 2779 |
| 24928 | 24928 | cba3e | 2779 2779 |
| 24929 | 24929 | 2fe0c | 2779 2779 |
| 24930 | 24930 | 5e075 | 2779 2779 |
| 24931 | 24931 | 59d75 | 2779 2779 |
| 24932 | 24932 | e6200 | 2779 2779 |
| 24933 | 24933 | b1201 | 2779 2779 |
| 24934 | 24934 | 902e5 | 2779 2779 |
| 24935 | 24935 | 1c6ee | 2779 2779 |
| 24936 | 24936 | a72cb | 2779 2779 |
| 24937 | 24937 | 4e8fc | 2779 2779 |
| 24938 | 24938 | bafb6 | 2779 2779 |
| 24939 | 24939 | 7fdf0 | 2779 2779 |
| 24940 | 24940 | bcbce | 2779 2779 |
| 24941 | 24941 | a9339 | 2779 2779 |
| 24942 | 24942 | 2827b | 2779 2779 |
| 24943 | 24943 | cf133 | 2779 2779 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)