This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9516 | 9516 | 59b7b | 886 886 |
9646 | 9646 | 59b7b | 877 877 |
9698 | 9698 | 59b7b | 890 890 |
9988 | 9988 | 59b7b | 892 892 |
9999 | 9999 | 59b7b | 889 889 |
10067 | 10067 | 59b7b | 881 881 |
10091 | 10091 | 59b7b | 878 878 |
10141 | 10141 | 59b7b | 884 884 |
10337 | 10337 | 59b7b | 887 887 |
10365 | 10365 | 59b7b | 880 880 |
11280 | 11280 | 59b7b | 897 897 |
13859 | 13859 | 59b7b | 862 862 |
15285 | 15285 | 59b7b | 869 869 |
31580 | 31580 | 59b7b | 832 832 |
34310 | 34310 | 59b7b | 783 783 |
35065 | 35065 | 59b7b | 866 866 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )