This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25986 | 25986 | ebcbb | 3335 3335 |
| 25987 | 25987 | 371f0 | 3335 3335 |
| 25988 | 25988 | 5e075 | 3335 3335 |
| 25989 | 25989 | 59d75 | 3335 3335 |
| 25990 | 25990 | e6200 | 3335 3335 |
| 25991 | 25991 | b1201 | 3335 3335 |
| 25992 | 25992 | 8a7ee | 3335 3335 |
| 25993 | 25993 | 862ed | 3335 3335 |
| 25994 | 25994 | 13ab6 | 3335 3335 |
| 25995 | 25995 | 18a64 | 3335 3335 |
| 25996 | 25996 | d5ec6 | 3335 3335 |
| 25997 | 25997 | 66f82 | 3335 3335 |
| 25998 | 25998 | f788a | 3335 3335 |
| 25999 | 25999 | 7c38f | 3335 3335 |
| 26000 | 26000 | a2d21 | 3335 3335 |
| 26001 | 26001 | a1307 | 3335 3335 |
| 26002 | 26002 | 809af | 3335 3335 |
| 26003 | 26003 | abb72 | 3335 3335 |
| 26004 | 26004 | 93975 | 3335 3335 |
| 26005 | 26005 | 27369 | 3335 3335 |
| 26006 | 26006 | 37724 | 3335 3335 |
| 26007 | 26007 | e128e | 3335 3335 |
| 26008 | 26008 | 80def | 3335 3335 |
| 26009 | 26009 | 9c206 | 3335 3335 |
| 26010 | 26010 | 7c580 | 3335 3335 |
| 26011 | 26011 | 724f8 | 3335 3335 |
| 26012 | 26012 | b6f60 | 3335 3335 |
| 26013 | 26013 | 06d39 | 3335 3335 |
| 26014 | 26014 | 2ab82 | 3335 3335 |
| 26015 | 26015 | 8b0bf | 3335 3335 |
| 26016 | 26016 | 01e8a | 3335 3335 |
| 26017 | 26017 | 2aa57 | 3335 3335 |
| 26018 | 26018 | 425d7 | 3335 3335 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)