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 :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `tb_lms_lecciones` ORDER BY `id` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id Ascending Descending 1 lesson_code
Codigo unico de leccion
id_curso
FK a tb_lms_cursos.id
titulo descripcion contenido_html competencia
listening/speaking/reading/writing/grammar/vocabul…
tipo_leccion tema_principal nivel_cefr duracion_minutos dificultad
1-10
orden_en_curso visible id_autor_original
FK a tb_usuarios.id
version recipes
JSON
es_compartida veces_utilizada rating_promedio metadatos enabled fecha_creacion fecha_modificacion
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 1
1 DEMO-L01-LISTEN 1 City Sounds: Understanding Announcements Practice listening to public announcements and ext... NULL listening Practice Daily Life B1 25 3 1 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:53:04 2026-02-17 17:53:04
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 2
2 DEMO-L02-SPEAK 1 Describe Your Weekend Practice speaking about past events using narrativ... NULL speaking Practice Free Time B1 30 3 2 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:53:04 2026-02-17 17:53:04
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 3
3 DEMO-L03-READ 1 News Article: Technology in Schools Read and comprehend a short news article about tec... NULL reading Practice Technology B1 20 2 3 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:53:04 2026-02-17 17:53:04
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 4
4 DEMO-L04-WRITE 1 Write an Email to a Friend Practice informal email writing with appropriate r... NULL writing Practice Communication B1 35 3 4 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:53:04 2026-02-17 17:53:04
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 5
5 DEMO-L05-GRAM 1 Past Simple vs Present Perfect Master the difference between past simple and pres... NULL grammar Practice Grammar B1 20 4 5 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:53:04 2026-02-17 17:53:04
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 6
6 DEMO-L06-VOCAB 1 Travel Vocabulary Builder Expand vocabulary related to travel, transport, an... NULL vocabulary Practice Travel B1 15 2 6 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:53:04 2026-02-17 17:53:04
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 7
7 DEMO-L07-PRON 1 Stress Patterns in Compound Words Practice word stress in compound nouns and adjecti... NULL pronunciation Practice Pronunciation B1 15 3 7 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:53:04 2026-02-17 17:53:04
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 8
8 DEMO-C2-L01 2 At the Restaurant: Ordering Food Practice listening to waiter dialogues and placing... <p><br></p><div data-lms-video="1" contenteditable... listening Practice Daily Life A2 20 2 1 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 19:46:56
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 9
9 DEMO-C2-L02 2 Introduce Yourself Practice self-introductions and basic personal inf... NULL speaking Practice Social A2 25 2 2 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 10
10 DEMO-C2-L03 2 Reading Signs and Instructions Read and understand common public signs and instru... NULL reading Practice Daily Life A2 15 1 3 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 11
11 DEMO-C2-L04 2 Present Simple vs Present Continuous Master the difference between habits and actions h... NULL grammar Practice Grammar A2 20 2 4 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 12
12 DEMO-C2-L05 2 Shopping Vocabulary Learn words related to clothes, prices, and shoppi... NULL vocabulary Practice Shopping A2 15 1 5 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 13
13 DEMO-C3-L01 3 Debate: Social Media Impact Build arguments for and against social media use. NULL speaking Practice Technology B1+ 30 4 1 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 14
14 DEMO-C3-L02 3 Opinion Essay Writing Write a structured opinion essay with introduction... NULL writing Practice Communication B1+ 40 4 2 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 15
15 DEMO-C3-L03 3 Podcast Comprehension: Climate Change Listen to a podcast excerpt and answer detailed qu... NULL listening Practice Environment B1+ 25 4 3 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 16
16 DEMO-C3-L04 3 Conditionals: Zero, First, Second Master conditional sentences for real and hypothet... NULL grammar Practice Grammar B1+ 25 5 4 1 NULL 1 NULL 0 0 0.00 NULL 1 2026-02-17 17:56:55 2026-02-17 17:56:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 17
17 EN-A1-GRAMM-VERBTOBE-8C9452 4 Verb to be (practice) grammar Assessment Verb to be A1 45 5 1 0 61 1 NULL 0 0 0.00 NULL 1 2026-03-26 23:50:47 2026-04-21 19:32:37
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 18
18 EN-A1-GRAMM-VERBTOBE-BDD5C2 4 Verb to be (practice) grammar Assessment Verb to be A1 45 5 2 0 61 1 NULL 0 0 0.00 NULL 1 2026-03-26 23:50:47 2026-04-07 22:00:35
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_lms_lecciones WHERE `tb_lms_lecciones`.`id` = 19
19 EN-A1-GRAMM-VERBTOBE-AE1A53 4 Verb to be (practice) <p>Prueba?</p> grammar Assessment Verb to be A1 45 5 3 0 61 1 NULL 0 0 0.00 NULL 1 2026-03-26 23:50:47 2026-04-07 22:00:33
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query