This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6957 | 6957 | cc5ed | 2756 2756 |
6958 | 6958 | 3fb0e | 2756 2756 |
6959 | 6959 | e6200 | 2756 2756 |
6960 | 6960 | b1201 | 2756 2756 |
6961 | 6961 | 74b62 | 2756 2756 |
6962 | 6962 | db8b3 | 2756 2756 |
6963 | 6963 | 2113e | 2756 2756 |
6964 | 6964 | 1e955 | 2756 2756 |
6965 | 6965 | 0ce79 | 2756 2756 |
6966 | 6966 | 22cc9 | 2756 2756 |
6967 | 6967 | 415bf | 2756 2756 |
6968 | 6968 | d14f5 | 2756 2756 |
6969 | 6969 | 0f722 | 2756 2756 |
6970 | 6970 | 984e7 | 2756 2756 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )