This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16 | 16 | 4225c | 3186 3186 |
| 526 | 526 | 4225c | 3188 3188 |
| 545 | 545 | 4225c | 2244 2244 |
| 576 | 576 | 4225c | 2828 2828 |
| 882 | 882 | 4225c | 3187 3187 |
| 914 | 914 | 4225c | 2243 2243 |
| 1041 | 1041 | 4225c | 3189 3189 |
| 1256 | 1256 | 4225c | 3191 3191 |
| 1656 | 1656 | 4225c | 3190 3190 |
| 15645 | 15645 | 4225c | 3377 3377 |
| 15742 | 15742 | 4225c | 3324 3324 |
| 16658 | 16658 | 4225c | 3373 3373 |
| 16903 | 16903 | 4225c | 3358 3358 |
| 16935 | 16935 | 4225c | 3369 3369 |
| 17297 | 17297 | 4225c | 3317 3317 |
| 17418 | 17418 | 4225c | 3359 3359 |
| 17687 | 17687 | 4225c | 1026 1026 |
| 19800 | 19800 | 4225c | 1988 1988 |
| 21892 | 21892 | 4225c | 2093 2093 |
| 22593 | 22593 | 4225c | 1010 1010 |
| 23964 | 23964 | 4225c | 936 936 |
| 25211 | 25211 | 4225c | 2131 2131 |
| 25564 | 25564 | 4225c | 2129 2129 |
| 27623 | 27623 | 4225c | 1180 1180 |
| 28511 | 28511 | 4225c | 3195 3195 |
| 29261 | 29261 | 4225c | 1022 1022 |
| 30278 | 30278 | 4225c | 3193 3193 |
| 35011 | 35011 | 4225c | 1933 1933 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)