This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
885 | 885 | 6060b | 3008 3008 |
986 | 986 | 6060b | 3007 3007 |
5083 | 5083 | 6060b | 3015 3015 |
5118 | 5118 | 6060b | 3003 3003 |
5581 | 5581 | 6060b | 3014 3014 |
5668 | 5668 | 6060b | 3002 3002 |
5923 | 5923 | 6060b | 3004 3004 |
5995 | 5995 | 6060b | 3006 3006 |
6243 | 6243 | 6060b | 3005 3005 |
6287 | 6287 | 6060b | 3001 3001 |
28331 | 28331 | 6060b | 3011 3011 |
28350 | 28350 | 6060b | 3009 3009 |
28754 | 28754 | 6060b | 3010 3010 |
29082 | 29082 | 6060b | 3012 3012 |
29225 | 29225 | 6060b | 3013 3013 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )