This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21905 | 21905 | cc5ed | 2950 2950 |
| 21906 | 21906 | c1190 | 2950 2950 |
| 21907 | 21907 | cb80d | 2950 2950 |
| 21908 | 21908 | 371f0 | 2950 2950 |
| 21909 | 21909 | bf1e7 | 2950 2950 |
| 21910 | 21910 | e6200 | 2950 2950 |
| 21911 | 21911 | b1201 | 2950 2950 |
| 21912 | 21912 | 902e5 | 2950 2950 |
| 21913 | 21913 | bc1ac | 2950 2950 |
| 21914 | 21914 | 6ec75 | 2950 2950 |
| 21915 | 21915 | 5b456 | 2950 2950 |
| 21916 | 21916 | 77d7e | 2950 2950 |
| 21917 | 21917 | c46d7 | 2950 2950 |
| 21918 | 21918 | e5437 | 2950 2950 |
| 21919 | 21919 | 469ba | 2950 2950 |
| 21920 | 21920 | 5be59 | 2950 2950 |
| 21921 | 21921 | ed59f | 2950 2950 |
| 21922 | 21922 | a40b9 | 2950 2950 |
| 21923 | 21923 | 1aa29 | 2950 2950 |
| 21924 | 21924 | 51ad1 | 2950 2950 |
| 21925 | 21925 | b0c29 | 2950 2950 |
| 21926 | 21926 | 1da53 | 2950 2950 |
| 21927 | 21927 | 87529 | 2950 2950 |
| 21928 | 21928 | 1d7a4 | 2950 2950 |
| 21929 | 21929 | 0d63c | 2950 2950 |
| 21930 | 21930 | 9e20a | 2950 2950 |
| 21931 | 21931 | becf5 | 2950 2950 |
| 21932 | 21932 | 266f1 | 2950 2950 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)