This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
7404 | 7404 | cc5ed | 2809 2809 |
7405 | 7405 | d3b45 | 2809 2809 |
7406 | 7406 | 371f0 | 2809 2809 |
7407 | 7407 | 5e075 | 2809 2809 |
7408 | 7408 | 59d75 | 2809 2809 |
7409 | 7409 | e6200 | 2809 2809 |
7410 | 7410 | b1201 | 2809 2809 |
7411 | 7411 | 902e5 | 2809 2809 |
7412 | 7412 | ddd45 | 2809 2809 |
7413 | 7413 | 64bc4 | 2809 2809 |
7414 | 7414 | 1c5f0 | 2809 2809 |
7415 | 7415 | 100e0 | 2809 2809 |
7416 | 7416 | 7c38f | 2809 2809 |
7417 | 7417 | 809af | 2809 2809 |
7418 | 7418 | abb72 | 2809 2809 |
7419 | 7419 | 2ce65 | 2809 2809 |
7420 | 7420 | 14760 | 2809 2809 |
7421 | 7421 | eb152 | 2809 2809 |
7422 | 7422 | 3fef5 | 2809 2809 |
7423 | 7423 | e128e | 2809 2809 |
7424 | 7424 | 302cc | 2809 2809 |
7425 | 7425 | 35dce | 2809 2809 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )