This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1339 | 1339 | 4e97e | 2393 2393 |
1340 | 1340 | 371f0 | 2393 2393 |
1341 | 1341 | e6200 | 2393 2393 |
1342 | 1342 | b1201 | 2393 2393 |
1343 | 1343 | 8a7ee | 2393 2393 |
1344 | 1344 | 862ed | 2393 2393 |
1345 | 1345 | 18a64 | 2393 2393 |
1346 | 1346 | 9848a | 2393 2393 |
1347 | 1347 | 3fbed | 2393 2393 |
1348 | 1348 | 2ce65 | 2393 2393 |
1349 | 1349 | 27369 | 2393 2393 |
1350 | 1350 | e128e | 2393 2393 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )