home / train

file

18 rows where patch_id = 142

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
774 142 142 extension.json
775 142 142 i18n/en.json
776 142 142 i18n/qqq.json
777 142 142 includes/CommentFormatter.php
778 142 142 includes/Hooks/HookUtils.php
779 142 142 includes/Hooks/PageHooks.php
780 142 142 modules/controller.js
781 142 142 modules/dt.init.less
782 142 142 tests/cases/ar-no-paragraph-oldparser/ar-no-paragraph-oldparser-formattedreply.html
783 142 142 tests/cases/double-signature1/double-signature1-formattedreply.html
784 142 142 tests/cases/en-big-oldparser/en-big-oldparser-formattedreply.html
785 142 142 tests/cases/for-parser-cache/for-parser-cache-formattedreply.html
786 142 142 tests/cases/fr-unsigned-oldparser/fr-unsigned-oldparser-formattedreply.html
787 142 142 tests/cases/it-unsigned-oldparser/it-unsigned-oldparser-formattedreply.html
788 142 142 tests/cases/pl-big-oldparser/pl-big-oldparser-formattedreply.html
789 142 142 tests/cases/signatures-funny/signatures-funny-formattedreply.html
790 142 142 tests/cases/unclosed-font/unclosed-font-formattedreply.html
791 142 142 tests/cases/wrappers/wrappers-formattedreply.html

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 21.94ms