This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
27358 | 27358 | ebcbb | 3339 3339 |
27359 | 27359 | 371f0 | 3339 3339 |
27360 | 27360 | 5e075 | 3339 3339 |
27361 | 27361 | 59d75 | 3339 3339 |
27362 | 27362 | e6200 | 3339 3339 |
27363 | 27363 | b1201 | 3339 3339 |
27364 | 27364 | a50f7 | 3339 3339 |
27365 | 27365 | d5ec6 | 3339 3339 |
27366 | 27366 | d3559 | 3339 3339 |
27367 | 27367 | 649a5 | 3339 3339 |
27368 | 27368 | 8a7eb | 3339 3339 |
27369 | 27369 | 18a11 | 3339 3339 |
27370 | 27370 | 03778 | 3339 3339 |
27371 | 27371 | a1f8b | 3339 3339 |
27372 | 27372 | 37724 | 3339 3339 |
27373 | 27373 | 32bde | 3339 3339 |
27374 | 27374 | 06ae5 | 3339 3339 |
27375 | 27375 | 710d1 | 3339 3339 |
27376 | 27376 | 943de | 3339 3339 |
27377 | 27377 | 8d650 | 3339 3339 |
27378 | 27378 | fa448 | 3339 3339 |
27379 | 27379 | e1dcf | 3339 3339 |
27380 | 27380 | f58f7 | 3339 3339 |
27381 | 27381 | 6e6b8 | 3339 3339 |
27382 | 27382 | e737a | 3339 3339 |
27383 | 27383 | e7176 | 3339 3339 |
27384 | 27384 | 376eb | 3339 3339 |
27385 | 27385 | 2ed38 | 3339 3339 |
27386 | 27386 | 60bee | 3339 3339 |
27387 | 27387 | 962c9 | 3339 3339 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )