This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
740 | 740 | 27335 | 3143 3143 |
948 | 948 | 27335 | 3142 3142 |
7492 | 7492 | 27335 | 2818 2818 |
7818 | 7818 | 27335 | 2815 2815 |
7883 | 7883 | 27335 | 2819 2819 |
15965 | 15965 | 27335 | 3120 3120 |
20241 | 20241 | 27335 | 3518 3518 |
26996 | 26996 | 27335 | 3107 3107 |
28414 | 28414 | 27335 | 3144 3144 |
28864 | 28864 | 27335 | 3145 3145 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )