This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6841 | 6841 | 598d9 | 2980 2980 |
| 9525 | 9525 | 598d9 | 886 886 |
| 9655 | 9655 | 598d9 | 877 877 |
| 9707 | 9707 | 598d9 | 890 890 |
| 9744 | 9744 | 598d9 | 876 876 |
| 9997 | 9997 | 598d9 | 892 892 |
| 10008 | 10008 | 598d9 | 889 889 |
| 10058 | 10058 | 598d9 | 874 874 |
| 10076 | 10076 | 598d9 | 881 881 |
| 10100 | 10100 | 598d9 | 878 878 |
| 10150 | 10150 | 598d9 | 884 884 |
| 10346 | 10346 | 598d9 | 887 887 |
| 10374 | 10374 | 598d9 | 880 880 |
| 10438 | 10438 | 598d9 | 891 891 |
| 10469 | 10469 | 598d9 | 885 885 |
| 10772 | 10772 | 598d9 | 807 807 |
| 10833 | 10833 | 598d9 | 888 888 |
| 10968 | 10968 | 598d9 | 883 883 |
| 11039 | 11039 | 598d9 | 879 879 |
| 11074 | 11074 | 598d9 | 804 804 |
| 11104 | 11104 | 598d9 | 873 873 |
| 28542 | 28542 | 598d9 | 3082 3082 |
| 28567 | 28567 | 598d9 | 3087 3087 |
| 28577 | 28577 | 598d9 | 3085 3085 |
| 28685 | 28685 | 598d9 | 3081 3081 |
| 28719 | 28719 | 598d9 | 3086 3086 |
| 28945 | 28945 | 598d9 | 3084 3084 |
| 29169 | 29169 | 598d9 | 3088 3088 |
| 29285 | 29285 | 598d9 | 3083 3083 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)