This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24990 | 24990 | cc5ed | 2937 2937 |
| 24991 | 24991 | c1190 | 2937 2937 |
| 24992 | 24992 | cb80d | 2937 2937 |
| 24993 | 24993 | 371f0 | 2937 2937 |
| 24994 | 24994 | bf1e7 | 2937 2937 |
| 24995 | 24995 | e6200 | 2937 2937 |
| 24996 | 24996 | b1201 | 2937 2937 |
| 24997 | 24997 | 902e5 | 2937 2937 |
| 24998 | 24998 | bc1ac | 2937 2937 |
| 24999 | 24999 | 6ec75 | 2937 2937 |
| 25000 | 25000 | 5b456 | 2937 2937 |
| 25001 | 25001 | 77d7e | 2937 2937 |
| 25002 | 25002 | c46d7 | 2937 2937 |
| 25003 | 25003 | e5437 | 2937 2937 |
| 25004 | 25004 | 469ba | 2937 2937 |
| 25005 | 25005 | 5be59 | 2937 2937 |
| 25006 | 25006 | ed59f | 2937 2937 |
| 25007 | 25007 | a40b9 | 2937 2937 |
| 25008 | 25008 | 1aa29 | 2937 2937 |
| 25009 | 25009 | 51ad1 | 2937 2937 |
| 25010 | 25010 | b0c29 | 2937 2937 |
| 25011 | 25011 | 87529 | 2937 2937 |
| 25012 | 25012 | becf5 | 2937 2937 |
| 25013 | 25013 | 266f1 | 2937 2937 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)