ad_targets

72 rows where target_id = "37b6b"

descending

Link	rowid	target_id	ad_id
7761	7761	37b6b	799 799
8764	8764	37b6b	823 823
9420	9420	37b6b	1443 1443
9528	9528	37b6b	237 237
9806	9806	37b6b	308 308
9929	9929	37b6b	235 235
10529	10529	37b6b	236 236
10667	10667	37b6b	234 234
10731	10731	37b6b	238 238
12252	12252	37b6b	859 859
12418	12418	37b6b	72 72
12547	12547	37b6b	1238 1238
12605	12605	37b6b	263 263
12623	12623	37b6b	242 242
12714	12714	37b6b	251 251
12939	12939	37b6b	253 253
12995	12995	37b6b	240 240
13189	13189	37b6b	244 244
13340	13340	37b6b	245 245
13404	13404	37b6b	259 259
13445	13445	37b6b	249 249
13630	13630	37b6b	256 256
13665	13665	37b6b	262 262
13710	13710	37b6b	247 247
13740	13740	37b6b	257 257
13750	13750	37b6b	260 260
13832	13832	37b6b	306 306
14152	14152	37b6b	241 241
14185	14185	37b6b	264 264
14212	14212	37b6b	250 250
14385	14385	37b6b	66 66
14434	14434	37b6b	252 252
14720	14720	37b6b	243 243
14754	14754	37b6b	248 248
14819	14819	37b6b	258 258
15024	15024	37b6b	239 239
15141	15141	37b6b	254 254
15315	15315	37b6b	255 255
15372	15372	37b6b	246 246
15413	15413	37b6b	261 261
30965	30965	37b6b	81 81
30975	30975	37b6b	85 85
31235	31235	37b6b	59 59
31258	31258	37b6b	106 106
31290	31290	37b6b	61 61
31376	31376	37b6b	56 56
31429	31429	37b6b	302 302
31463	31463	37b6b	288 288
31712	31712	37b6b	290 290
31751	31751	37b6b	286 286
31897	31897	37b6b	287 287
32063	32063	37b6b	285 285
32073	32073	37b6b	57 57
32236	32236	37b6b	289 289
32260	32260	37b6b	277 277
32398	32398	37b6b	275 275
32432	32432	37b6b	303 303
32559	32559	37b6b	279 279
32587	32587	37b6b	281 281
32882	32882	37b6b	278 278
32916	32916	37b6b	276 276
33084	33084	37b6b	280 280
33538	33538	37b6b	847 847
33774	33774	37b6b	905 905
34431	34431	37b6b	38 38
34439	34439	37b6b	788 788
35586	35586	37b6b	80 80
35596	35596	37b6b	84 84
35733	35733	37b6b	58 58
35858	35858	37b6b	55 55
35922	35922	37b6b	105 105
35969	35969	37b6b	60 60

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE ad_targets (
               target_id TEXT   REFERENCES [targets]([id]),
   ad_id INTEGER   REFERENCES [ads]([id])
        )