This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5093 | 5093 | cc5ed | 2745 2745 |
5094 | 5094 | 3fb0e | 2745 2745 |
5095 | 5095 | e6200 | 2745 2745 |
5096 | 5096 | b1201 | 2745 2745 |
5097 | 5097 | 902e5 | 2745 2745 |
5098 | 5098 | 74b62 | 2745 2745 |
5099 | 5099 | 35025 | 2745 2745 |
5100 | 5100 | db8b3 | 2745 2745 |
5101 | 5101 | 2113e | 2745 2745 |
5102 | 5102 | 1e955 | 2745 2745 |
5103 | 5103 | 0ce79 | 2745 2745 |
5104 | 5104 | 22cc9 | 2745 2745 |
5105 | 5105 | 415bf | 2745 2745 |
5106 | 5106 | 5f339 | 2745 2745 |
5107 | 5107 | d14f5 | 2745 2745 |
5108 | 5108 | 0f722 | 2745 2745 |
5109 | 5109 | 984e7 | 2745 2745 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )