This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33996 | 33996 | ec3ac | 915 915 |
33997 | 33997 | b668a | 915 915 |
33998 | 33998 | aaf5a | 915 915 |
33999 | 33999 | 5e075 | 915 915 |
34000 | 34000 | 59d75 | 915 915 |
34001 | 34001 | e6200 | 915 915 |
34002 | 34002 | b1201 | 915 915 |
34003 | 34003 | 63e96 | 915 915 |
34004 | 34004 | 2fb27 | 915 915 |
34005 | 34005 | 7a351 | 915 915 |
34006 | 34006 | 0593a | 915 915 |
34007 | 34007 | eecd9 | 915 915 |
34008 | 34008 | 7ce59 | 915 915 |
34009 | 34009 | b8d0a | 915 915 |
34010 | 34010 | 3896c | 915 915 |
34011 | 34011 | a524c | 915 915 |
34012 | 34012 | 41ee7 | 915 915 |
34013 | 34013 | ed356 | 915 915 |
34014 | 34014 | 94bdc | 915 915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )