This data as JSON, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33778 | 33778 | ec3ac | 817 817 |
33779 | 33779 | b668a | 817 817 |
33780 | 33780 | a14cf | 817 817 |
33781 | 33781 | 5e075 | 817 817 |
33782 | 33782 | 59d75 | 817 817 |
33783 | 33783 | e6200 | 817 817 |
33784 | 33784 | b1201 | 817 817 |
33785 | 33785 | 63e96 | 817 817 |
33786 | 33786 | 2fb27 | 817 817 |
33787 | 33787 | 7a351 | 817 817 |
33788 | 33788 | 0593a | 817 817 |
33789 | 33789 | eecd9 | 817 817 |
33790 | 33790 | 2d469 | 817 817 |
33791 | 33791 | 973aa | 817 817 |
33792 | 33792 | 65a38 | 817 817 |
33793 | 33793 | e128e | 817 817 |
33794 | 33794 | d75c0 | 817 817 |
33795 | 33795 | e9f7c | 817 817 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )