3 rows sorted by personalization_record_id

View and edit SQL

Link personalization_record_id ▼ location_id
1 1 İstanbul, Türkiye 1
1 1 Moscow, Russia 2
1 1 Izhevsk, Russia 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE `twitter_personalization_locations` (`personalization_record_id` integer,`location_id` integer,PRIMARY KEY (`personalization_record_id`,`location_id`),CONSTRAINT `fk_twitter_personalization_locations_personalization_record` FOREIGN KEY (`personalization_record_id`) REFERENCES `twitter_personalization_records`(`id`),CONSTRAINT `fk_twitter_personalization_locations_location` FOREIGN KEY (`location_id`) REFERENCES `twitter_locations`(`id`));