This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11164 | 11164 | 6e2b2 | 1450 1450 |
11165 | 11165 | b60e9 | 1450 1450 |
11166 | 11166 | cc756 | 1450 1450 |
11167 | 11167 | 5e075 | 1450 1450 |
11168 | 11168 | 59d75 | 1450 1450 |
11169 | 11169 | e6200 | 1450 1450 |
11170 | 11170 | b1201 | 1450 1450 |
11171 | 11171 | 8b9b7 | 1450 1450 |
11172 | 11172 | 4dc48 | 1450 1450 |
11173 | 11173 | 8d4bc | 1450 1450 |
11174 | 11174 | 53703 | 1450 1450 |
11175 | 11175 | ec55d | 1450 1450 |
11176 | 11176 | d379e | 1450 1450 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )