This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
893 | 893 | 225c8 | 3008 3008 |
996 | 996 | 225c8 | 3007 3007 |
5091 | 5091 | 225c8 | 3015 3015 |
5127 | 5127 | 225c8 | 3003 3003 |
5592 | 5592 | 225c8 | 3014 3014 |
5678 | 5678 | 225c8 | 3002 3002 |
5932 | 5932 | 225c8 | 3004 3004 |
6252 | 6252 | 225c8 | 3005 3005 |
6295 | 6295 | 225c8 | 3001 3001 |
16462 | 16462 | 225c8 | 3000 3000 |
28358 | 28358 | 225c8 | 3009 3009 |
28762 | 28762 | 225c8 | 3010 3010 |
36235 | 36235 | 225c8 | 2999 2999 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )