List #: 1380
Keywords/tags: suffix, suffixes, root words, word roots, words ending in "ure"
Comments: Clicking "modify" list will make a copy of this list, so you can add or remove words. You can also remove words once they have been added to your account.
Please note that as with all root words, this list includes exceptions from the rule!
Description: This is a list of words ending with suffix "ure" , meaning "action, condition"..
Author: eSpindle Learning.
Subject: English vocabulary.
Supporting Link: http://www.espindle.org/suffix.html.
Created: 11/19/2009
Modified: 11/19/2009
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `classes` | 11 | 11 | 0 | |
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 | 0 | |
11 | SHOW FULL COLUMNS FROM `senses` | 4 | 4 | 0 | |
12 | SHOW FULL COLUMNS FROM `videos` | 14 | 14 | 0 | |
13 | SHOW FULL COLUMNS FROM `words_chapters` | 4 | 4 | 0 | |
14 | SHOW FULL COLUMNS FROM `words_alternates` | 10 | 10 | 0 | |
15 | SHOW FULL COLUMNS FROM `words_antonyms` | 5 | 5 | 0 | |
16 | SHOW FULL COLUMNS FROM `words_limericks` | 4 | 4 | 0 | |
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 | 0 | |
24 | SHOW FULL COLUMNS FROM `user_practice_words` | 16 | 16 | 0 | |
25 | SHOW FULL COLUMNS FROM `word_lists` | 12 | 12 | 1 | |
26 | SHOW FULL COLUMNS FROM `schools` | 24 | 24 | 0 | |
27 | SHOW FULL COLUMNS FROM `partners` | 11 | 11 | 0 | |
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 | 0 | |
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 | 0 | |
35 | SHOW FULL COLUMNS FROM `word_list_ratings` | 4 | 4 | 0 | |
36 | SHOW FULL COLUMNS FROM `teachers_students` | 5 | 5 | 0 | |
37 | SHOW FULL COLUMNS FROM `classes_students` | 3 | 3 | 0 | |
38 | SHOW FULL COLUMNS FROM `classes_teachers` | 3 | 3 | 0 | |
39 | SHOW FULL COLUMNS FROM `schools_teachers` | 4 | 4 | 0 | |
40 | SHOW FULL COLUMNS FROM `schools_admins` | 7 | 7 | 0 | |
41 | SHOW FULL COLUMNS FROM `users_sponsors` | 6 | 6 | 0 | |
42 | SHOW FULL COLUMNS FROM `users_friends` | 5 | 5 | 0 | |
43 | SHOW FULL COLUMNS FROM `users_family_sponsors` | 3 | 3 | 0 | |
44 | SHOW FULL COLUMNS FROM `classes_chapters` | 4 | 4 | 0 | |
45 | SELECT `WordList`.`id`, `WordList`.`user_id`, `WordList`.`is_public`, `WordList`.`title`, `WordList`.`keywords`, `WordList`.`comments`, `WordList`.`content_link`, `WordList`.`buy_link`, `WordList`.`created`, `WordList`.`modified`, `WordList`.`is_changed_by_admin`, `WordList`.`is_premium`, (SELECT count(*) as count FROM word_list_ratings AS Rate WHERE `Rate`.`word_list_id` = `WordList`.`id` ) AS `WordList__reviews`, (SELECT round(sum(rating)/count(*), 1) FROM word_list_ratings AS Rate WHERE `Rate`.`word_list_id` = `WordList`.`id` ) AS `WordList__rating` FROM `word_lists` AS `WordList` WHERE `WordList`.`id` = 1380 LIMIT 1 | 1 | 1 | 0 | |
46 | SELECT `Chapter`.`id`, `Chapter`.`word_list_id`, `Chapter`.`unit`, (SELECT count(*) as count FROM words AS Word JOIN words_chapters AS WordsChapter ON (`WordsChapter`.`word_id` = `Word`.`id`) WHERE `WordsChapter`.`chapter_id` = `Chapter`.`id` ) AS `Chapter__words_count`, ( SELECT GROUP_CONCAT(' ', word) FROM words_chapters AS WordsChapters JOIN words AS WORD ON `WordsChapters`.`word_id`=`WORD`.`id` WHERE `WordsChapters`.`chapter_id`=`Chapter`.`id` ) AS `Chapter__words` FROM `chapters` AS `Chapter` WHERE (SELECT count(*) as count FROM words AS Word JOIN words_chapters AS WordsChapter ON (`WordsChapter`.`word_id` = `Word`.`id`) WHERE `WordsChapter`.`chapter_id` = `Chapter`.`id` LIMIT 1)>0 AND `Chapter`.`word_list_id` = (1380) | 4 | 4 | 1 | |
47 | SELECT `Bookmark`.`id`, `Bookmark`.`word_list_id`, `Bookmark`.`user_id`, `Bookmark`.`class_id` FROM `word_list_bookmarks` AS `Bookmark` WHERE `Bookmark`.`user_id` IS NULL AND `Bookmark`.`class_id` IS NULL AND `Bookmark`.`word_list_id` = (1380) | 0 | 0 | 0 | |
48 | SELECT `Rate`.`id`, `Rate`.`word_list_id`, `Rate`.`user_id`, `Rate`.`rating` FROM `word_list_ratings` AS `Rate` WHERE `Rate`.`user_id` IS NULL AND `Rate`.`word_list_id` = (1380) | 0 | 0 | 0 | |
49 | SHOW FULL COLUMNS FROM `settings` | 6 | 6 | 0 | |
50 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`options`, `Setting`.`is_custom`, `Setting`.`is_editable` FROM `settings` AS `Setting` WHERE `key` = 'word_lists_banner' LIMIT 1 | 1 | 1 | 0 |