Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id bigint(20)
code varchar(255) utf8mb4_unicode_ci
title varchar(255) utf8mb4_unicode_ci
subtitle varchar(255) utf8mb4_unicode_ci
manuscript_category_id bigint(20)
language varchar(255) utf8mb4_unicode_ci
script_type varchar(255) utf8mb4_unicode_ci
era varchar(255) utf8mb4_unicode_ci
origin varchar(255) utf8mb4_unicode_ci
reference_number varchar(255) utf8mb4_unicode_ci
description longtext utf8mb4_unicode_ci
keywords text utf8mb4_unicode_ci
condition_notes text utf8mb4_unicode_ci
curator_notes text utf8mb4_unicode_ci
cover_image varchar(255) utf8mb4_unicode_ci
page_count int(11)
status tinyint(1)
kiosk_featured tinyint(1)
featured tinyint(1)
is_purchasable tinyint(1)
requires_approval tinyint(1)
sale_price decimal(10,2)
reading_direction varchar(255) utf8mb4_unicode_ci
rights_type varchar(255) utf8mb4_unicode_ci
allow_page_purchase tinyint(1)
allow_pdf_purchase tinyint(1)
allow_research_purchase tinyint(1)
custom_price_enabled tinyint(1)
page_price decimal(10,2)
pdf_price decimal(10,2)
research_price decimal(10,2)
created_by bigint(20)
updated_by bigint(20)
created_at timestamp
updated_at timestamp
pdf_file varchar(255) utf8mb4_unicode_ci
pdf_generated_at timestamp
Display order: