This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33661 | 33661 | ec3ac | 918 918 |
33662 | 33662 | b668a | 918 918 |
33663 | 33663 | aaf5a | 918 918 |
33664 | 33664 | 5e075 | 918 918 |
33665 | 33665 | 59d75 | 918 918 |
33666 | 33666 | e6200 | 918 918 |
33667 | 33667 | b1201 | 918 918 |
33668 | 33668 | 63e96 | 918 918 |
33669 | 33669 | 2fb27 | 918 918 |
33670 | 33670 | 7a351 | 918 918 |
33671 | 33671 | 0593a | 918 918 |
33672 | 33672 | eecd9 | 918 918 |
33673 | 33673 | 7ce59 | 918 918 |
33674 | 33674 | b8d0a | 918 918 |
33675 | 33675 | 3896c | 918 918 |
33676 | 33676 | a524c | 918 918 |
33677 | 33677 | 41ee7 | 918 918 |
33678 | 33678 | ed356 | 918 918 |
33679 | 33679 | 94bdc | 918 918 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )