This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11295 | 11295 | 41ee7 | 897 897 |
11388 | 11388 | 41ee7 | 837 837 |
15300 | 15300 | 41ee7 | 869 869 |
31595 | 31595 | 41ee7 | 832 832 |
33451 | 33451 | 41ee7 | 921 921 |
33677 | 33677 | 41ee7 | 918 918 |
33706 | 33706 | 41ee7 | 922 922 |
33751 | 33751 | 41ee7 | 923 923 |
33993 | 33993 | 41ee7 | 911 911 |
34012 | 34012 | 41ee7 | 915 915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )