ad_targets

descending

Link	rowid	target_id	ad_id
2364	2364	6b827	1459 1459
2389	2389	6b827	1463 1463
2418	2418	6b827	1584 1584
2441	2441	6b827	1576 1576
2677	2677	6b827	1600 1600
2801	2801	6b827	1580 1580
2809	2809	6b827	1572 1572
2842	2842	6b827	1604 1604
2893	2893	6b827	1439 1439
2915	2915	6b827	1442 1442
2924	2924	6b827	1592 1592
2938	2938	6b827	1596 1596
2971	2971	6b827	1588 1588
9257	9257	6b827	1427 1427
9422	9422	6b827	1443 1443
12027	12027	6b827	1586 1586
12058	12058	6b827	1602 1602
12189	12189	6b827	1461 1461
12214	12214	6b827	1578 1578
12402	12402	6b827	1606 1606
12448	12448	6b827	1582 1582
12461	12461	6b827	1594 1594
12482	12482	6b827	1598 1598
12525	12525	6b827	1574 1574
12577	12577	6b827	1590 1590
12919	12919	6b827	1599 1599
13038	13038	6b827	1587 1587
13594	13594	6b827	1579 1579
13824	13824	6b827	1462 1462
13953	13953	6b827	1583 1583
14004	14004	6b827	1595 1595
14135	14135	6b827	1607 1607
14482	14482	6b827	1591 1591
15211	15211	6b827	1575 1575
15350	15350	6b827	1603 1603
30985	30985	6b827	1577 1577
31003	31003	6b827	1460 1460
31214	31214	6b827	1581 1581
31221	31221	6b827	1573 1573
31228	31228	6b827	1605 1605
31245	31245	6b827	1601 1601
31268	31268	6b827	1585 1585
31275	31275	6b827	1589 1589
31319	31319	6b827	1597 1597
31332	31332	6b827	1593 1593

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