This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
8162 | 8162 | cc5ed | 2760 2760 |
8163 | 8163 | 66d45 | 2760 2760 |
8164 | 8164 | bf1e7 | 2760 2760 |
8165 | 8165 | e6200 | 2760 2760 |
8166 | 8166 | b1201 | 2760 2760 |
8167 | 8167 | 74b62 | 2760 2760 |
8168 | 8168 | 35025 | 2760 2760 |
8169 | 8169 | db8b3 | 2760 2760 |
8170 | 8170 | afd28 | 2760 2760 |
8171 | 8171 | 7e7c6 | 2760 2760 |
8172 | 8172 | 2113e | 2760 2760 |
8173 | 8173 | 0ce79 | 2760 2760 |
8174 | 8174 | 22cc9 | 2760 2760 |
8175 | 8175 | 415bf | 2760 2760 |
8176 | 8176 | cc9a5 | 2760 2760 |
8177 | 8177 | 5f339 | 2760 2760 |
8178 | 8178 | d14f5 | 2760 2760 |
8179 | 8179 | 21405 | 2760 2760 |
8180 | 8180 | 77912 | 2760 2760 |
8181 | 8181 | 984e7 | 2760 2760 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )