Student How-to |
Teacher/Parent How-to |
 Click here for our list of student videos. |
 Click here for teacher videos. |
LearnThatWord and the Open Dictionary of English are programs by LearnThat Foundation, a 501(c)3 nonprofit.
Questions? Feedback? We want to hear from you!
Email us
or click here for instant support.
Copyright © 2005 and after - LearnThat Foundation. Patents pending.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `classes` | 11 | 11 | 6 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 0 | |
| 3 | SHOW FULL COLUMNS FROM `chapters` | 3 | 3 | 0 | |
| 4 | SHOW FULL COLUMNS FROM `users` | 55 | 55 | 1 | |
| 5 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_bin'; | 1 | 1 | 0 | |
| 6 | SHOW FULL COLUMNS FROM `keys` | 5 | 5 | 0 | |
| 7 | SHOW FULL COLUMNS FROM `users_keys` | 4 | 4 | 0 | |
| 8 | SHOW FULL COLUMNS FROM `words` | 24 | 24 | 0 | |
| 9 | SHOW FULL COLUMNS FROM `limericks` | 4 | 4 | 0 | |
| 10 | SHOW FULL COLUMNS FROM `roots` | 4 | 4 | 1 | |
| 11 | SHOW FULL COLUMNS FROM `senses` | 4 | 4 | 0 | |
| 12 | SHOW FULL COLUMNS FROM `videos` | 14 | 14 | 1 | |
| 13 | SHOW FULL COLUMNS FROM `words_chapters` | 4 | 4 | 0 | |
| 14 | SHOW FULL COLUMNS FROM `words_alternates` | 10 | 10 | 1 | |
| 15 | SHOW FULL COLUMNS FROM `words_antonyms` | 5 | 5 | 1 | |
| 16 | SHOW FULL COLUMNS FROM `words_limericks` | 4 | 4 | 1 | |
| 17 | SHOW FULL COLUMNS FROM `words_related_words` | 4 | 4 | 0 | |
| 18 | SHOW FULL COLUMNS FROM `words_roots` | 4 | 4 | 0 | |
| 19 | SHOW FULL COLUMNS FROM `words_same_context_words` | 4 | 4 | 0 | |
| 20 | SHOW FULL COLUMNS FROM `words_senses` | 4 | 4 | 0 | |
| 21 | SHOW FULL COLUMNS FROM `words_synonyms` | 5 | 5 | 0 | |
| 22 | SHOW FULL COLUMNS FROM `words_quiz_synonyms` | 3 | 3 | 0 | |
| 23 | SHOW FULL COLUMNS FROM `words_videos` | 6 | 6 | 1 | |
| 24 | SHOW FULL COLUMNS FROM `user_practice_words` | 16 | 16 | 0 | |
| 25 | SHOW FULL COLUMNS FROM `word_lists` | 12 | 12 | 4 | |
| 26 | SHOW FULL COLUMNS FROM `schools` | 24 | 24 | 1 | |
| 27 | SHOW FULL COLUMNS FROM `partners` | 11 | 11 | 1 | |
| 28 | SHOW FULL COLUMNS FROM `partners_classes` | 4 | 4 | 0 | |
| 29 | SHOW FULL COLUMNS FROM `partners_users` | 4 | 4 | 0 | |
| 30 | SHOW FULL COLUMNS FROM `users_chapters` | 4 | 4 | 3 | |
| 31 | SHOW FULL COLUMNS FROM `user_preferred_words` | 9 | 9 | 0 | |
| 32 | SHOW FULL COLUMNS FROM `user_unwanted_words` | 3 | 3 | 0 | |
| 33 | SHOW FULL COLUMNS FROM `user_spelled_words` | 4 | 4 | 0 | |
| 34 | SHOW FULL COLUMNS FROM `word_list_bookmarks` | 4 | 4 | 1 | |
| 35 | SHOW FULL COLUMNS FROM `word_list_ratings` | 4 | 4 | 3 | |
| 36 | SHOW FULL COLUMNS FROM `teachers_students` | 5 | 5 | 1 | |
| 37 | SHOW FULL COLUMNS FROM `classes_students` | 3 | 3 | 4 | |
| 38 | SHOW FULL COLUMNS FROM `classes_teachers` | 3 | 3 | 1 | |
| 39 | SHOW FULL COLUMNS FROM `schools_teachers` | 4 | 4 | 1 | |
| 40 | SHOW FULL COLUMNS FROM `schools_admins` | 7 | 7 | 1 | |
| 41 | SHOW FULL COLUMNS FROM `users_sponsors` | 6 | 6 | 1 | |
| 42 | SHOW FULL COLUMNS FROM `users_friends` | 5 | 5 | 1 | |
| 43 | SHOW FULL COLUMNS FROM `users_family_sponsors` | 3 | 3 | 1 | |
| 44 | SHOW FULL COLUMNS FROM `classes_chapters` | 4 | 4 | 38 | |
| 45 | SHOW FULL COLUMNS FROM `pages` | 18 | 18 | 1 |
