This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6160 | 6160 | cc5ed | 2746 2746 |
6161 | 6161 | 3fb0e | 2746 2746 |
6162 | 6162 | e6200 | 2746 2746 |
6163 | 6163 | b1201 | 2746 2746 |
6164 | 6164 | 902e5 | 2746 2746 |
6165 | 6165 | 74b62 | 2746 2746 |
6166 | 6166 | 35025 | 2746 2746 |
6167 | 6167 | db8b3 | 2746 2746 |
6168 | 6168 | 2113e | 2746 2746 |
6169 | 6169 | 1e955 | 2746 2746 |
6170 | 6170 | 0ce79 | 2746 2746 |
6171 | 6171 | 22cc9 | 2746 2746 |
6172 | 6172 | 415bf | 2746 2746 |
6173 | 6173 | 5f339 | 2746 2746 |
6174 | 6174 | d14f5 | 2746 2746 |
6175 | 6175 | 0f722 | 2746 2746 |
6176 | 6176 | 984e7 | 2746 2746 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )