Documents with most details

SQL query for Parseur

Get the documents with the highest number of document details.

SELECT documents.id, COUNT(*) AS num_details FROM documents INNER JOIN document_details ON documents.id = document_details.document_id GROUP BY documents.id ORDER BY num_details DESC LIMIT 10

Parseur data model

Table Documents

Id: Integer
Name: String
Parser: Integer
Result: String
Status: String
Received: Date-time
Template: String
Processed: Date-time
Attached_to: String
Is_ai_ready: Boolean
Credits_used: Integer
Ocr_ready_url: String
Status_source: String
Ai_credits_used: Integer
Match_master_template: Boolean
Original_document_url: String
Ocr_page_set_0_position: Integer
Ocr_page_set_1_position: Integer
Ocr_page_set_2_position: Integer
Ocr_page_set_3_position: Integer
Ocr_page_set_0_image_url: String
Ocr_page_set_1_image_url: String
Ocr_page_set_2_image_url: String
Ocr_page_set_3_image_url: String
Conventional_credits_used: Integer
Ocr_page_set_0_image_width: Integer
Ocr_page_set_1_image_width: Integer
Ocr_page_set_2_image_width: Integer
Ocr_page_set_3_image_width: Integer
Ocr_page_set_0_image_height: Integer
Ocr_page_set_1_image_height: Integer
Ocr_page_set_2_image_height: Integer
Ocr_page_set_3_image_height: Integer
Ocr_page_set_0_image_content_type: String
Ocr_page_set_1_image_content_type: String
Ocr_page_set_2_image_content_type: String
Ocr_page_set_3_image_content_type: String

Table Document Details

Id: Integer
Name: String
Parser: Integer
Result: String
Status: String
Content: String
Next_id: Integer
Prev_id: String
Received: Date-time
Template: String
Processed: Date-time
Attached_to: Integer
Is_ai_ready: Boolean
Credits_used: Integer
Ocr_ready_url: String
Status_source: String
Ai_credits_used: Integer
Match_master_template: Boolean
Original_document_url: String
Conventional_credits_used: Integer

Magical SQL for Parseur with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.