This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25944 | 25944 | ebcbb | 3362 3362 |
| 25945 | 25945 | 371f0 | 3362 3362 |
| 25946 | 25946 | 5e075 | 3362 3362 |
| 25947 | 25947 | 59d75 | 3362 3362 |
| 25948 | 25948 | e6200 | 3362 3362 |
| 25949 | 25949 | b1201 | 3362 3362 |
| 25950 | 25950 | a50f7 | 3362 3362 |
| 25951 | 25951 | d5ec6 | 3362 3362 |
| 25952 | 25952 | d3559 | 3362 3362 |
| 25953 | 25953 | 649a5 | 3362 3362 |
| 25954 | 25954 | 8a7eb | 3362 3362 |
| 25955 | 25955 | 18a11 | 3362 3362 |
| 25956 | 25956 | 03778 | 3362 3362 |
| 25957 | 25957 | a1f8b | 3362 3362 |
| 25958 | 25958 | 37724 | 3362 3362 |
| 25959 | 25959 | 32bde | 3362 3362 |
| 25960 | 25960 | 06ae5 | 3362 3362 |
| 25961 | 25961 | 710d1 | 3362 3362 |
| 25962 | 25962 | 943de | 3362 3362 |
| 25963 | 25963 | 8d650 | 3362 3362 |
| 25964 | 25964 | fa448 | 3362 3362 |
| 25965 | 25965 | e1dcf | 3362 3362 |
| 25966 | 25966 | f58f7 | 3362 3362 |
| 25967 | 25967 | 6e6b8 | 3362 3362 |
| 25968 | 25968 | e737a | 3362 3362 |
| 25969 | 25969 | e7176 | 3362 3362 |
| 25970 | 25970 | 376eb | 3362 3362 |
| 25971 | 25971 | 2ed38 | 3362 3362 |
| 25972 | 25972 | 60bee | 3362 3362 |
| 25973 | 25973 | 962c9 | 3362 3362 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)