home / train

file

12 rows where patch_id = 88826

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
427602 88826 88826 images/1x1.png
427603 88826 88826 images/icons/LICENSE
427604 88826 88826 images/icons/README
427605 88826 88826 images/icons/merged-admin.png
427606 88826 88826 images/icons/merged-empty.png
427607 88826 88826 images/icons/merged-login.png
427608 88826 88826 images/icons/merged-mail.png
427609 88826 88826 images/icons/merged-new.png
427610 88826 88826 images/icons/merged-password.png
427611 88826 88826 images/icons/merged-primary.png
427612 88826 88826 includes/Special/SpecialCentralAuth.php
427613 88826 88826 includes/Special/SpecialCentralAutoLogin.php

Advanced export

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

CSV options:

CREATE TABLE file (
            id INTEGER PRIMARY KEY,
            patch_id INTEGER NOT NULL,
            filename INTEGER NOT NULL,
            FOREIGN KEY(patch_id) REFERENCES patch(id)
        );
CREATE INDEX file_patch_id ON file(patch_id);
Powered by Datasette · Queries took 16.136ms