ad_targets

60 rows where target_id = 91693

descending

Link	rowid	target_id	ad_id
691	691	91693	1103 1103
1061	1061	91693	3194 3194
2218	2218	91693	1073 1073
12501	12501	91693	1187 1187
15576	15576	91693	1027 1027
15858	15858	91693	3376 3376
16181	16181	91693	3375 3375
16309	16309	91693	3374 3374
16365	16365	91693	3370 3370
16501	16501	91693	1024 1024
16748	16748	91693	3371 3371
17135	17135	91693	1075 1075
17606	17606	91693	0 0
18038	18038	91693	3360 3360
18184	18184	91693	1131 1131
18285	18285	91693	1076 1076
18529	18529	91693	928 928
18542	18542	91693	2070 2070
18555	18555	91693	965 965
18576	18576	91693	931 931
18589	18589	91693	3515 3515
19271	19271	91693	945 945
19287	19287	91693	954 954
19720	19720	91693	939 939
20089	20089	91693	963 963
20150	20150	91693	937 937
20430	20430	91693	969 969
20647	20647	91693	2168 2168
20928	20928	91693	957 957
21222	21222	91693	995 995
21319	21319	91693	978 978
21741	21741	91693	1007 1007
21856	21856	91693	985 985
22081	22081	91693	997 997
22169	22169	91693	1019 1019
22374	22374	91693	1004 1004
22671	22671	91693	1006 1006
22720	22720	91693	987 987
23076	23076	91693	1014 1014
23140	23140	91693	1003 1003
23283	23283	91693	1002 1002
23906	23906	91693	1005 1005
24169	24169	91693	1015 1015
26228	26228	91693	967 967
26443	26443	91693	1020 1020
27070	27070	91693	958 958
27290	27290	91693	968 968
27480	27480	91693	1048 1048
28074	28074	91693	3345 3345
28180	28180	91693	944 944
28235	28235	91693	960 960
28260	28260	91693	1053 1053
28809	28809	91693	1129 1129
29180	29180	91693	1102 1102
29338	29338	91693	3192 3192
29557	29557	91693	1078 1078
29648	29648	91693	1056 1056
29772	29772	91693	948 948
29998	29998	91693	1088 1088
30113	30113	91693	1158 1158

Advanced export

JSON shape: default, array, newline-delimited

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