This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27934 | 27934 | f678f | 3361 3361 |
| 27935 | 27935 | 371f0 | 3361 3361 |
| 27936 | 27936 | 5e075 | 3361 3361 |
| 27937 | 27937 | 59d75 | 3361 3361 |
| 27938 | 27938 | e6200 | 3361 3361 |
| 27939 | 27939 | b1201 | 3361 3361 |
| 27940 | 27940 | a50f7 | 3361 3361 |
| 27941 | 27941 | d5ec6 | 3361 3361 |
| 27942 | 27942 | d3559 | 3361 3361 |
| 27943 | 27943 | 649a5 | 3361 3361 |
| 27944 | 27944 | 8a7eb | 3361 3361 |
| 27945 | 27945 | 18a11 | 3361 3361 |
| 27946 | 27946 | 03778 | 3361 3361 |
| 27947 | 27947 | a1f8b | 3361 3361 |
| 27948 | 27948 | 37724 | 3361 3361 |
| 27949 | 27949 | 32bde | 3361 3361 |
| 27950 | 27950 | 06ae5 | 3361 3361 |
| 27951 | 27951 | 710d1 | 3361 3361 |
| 27952 | 27952 | 943de | 3361 3361 |
| 27953 | 27953 | 8d650 | 3361 3361 |
| 27954 | 27954 | fa448 | 3361 3361 |
| 27955 | 27955 | e1dcf | 3361 3361 |
| 27956 | 27956 | f58f7 | 3361 3361 |
| 27957 | 27957 | 6e6b8 | 3361 3361 |
| 27958 | 27958 | e737a | 3361 3361 |
| 27959 | 27959 | e7176 | 3361 3361 |
| 27960 | 27960 | 376eb | 3361 3361 |
| 27961 | 27961 | 2ed38 | 3361 3361 |
| 27962 | 27962 | 60bee | 3361 3361 |
| 27963 | 27963 | 962c9 | 3361 3361 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)