List #: 1381
Keywords/tags: suffix, suffixes, root words, word roots, words ending in "ward"
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. Note that three words in the lists are exceptions. Can you find them?
Description: This is a list of words ending with suffix "ward" , meaning "specifies direction"..
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 | 1 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 1 | |
3 | SHOW FULL COLUMNS FROM `chapters` | 3 | 3 | 1 | |
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 | 1 | |
6 | SHOW FULL COLUMNS FROM `keys` | 5 | 5 | 1 | |
7 | SHOW FULL COLUMNS FROM `users_keys` | 4 | 4 | 0 | |
8 | SHOW FULL COLUMNS FROM `words` | 24 | 24 | 1 | |
9 | SHOW FULL COLUMNS FROM `limericks` | 4 | 4 | 1 | |
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 | 1 | |
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 | 30 | |
17 | SHOW FULL COLUMNS FROM `words_related_words` | 4 | 4 | 1 | |
18 | SHOW FULL COLUMNS FROM `words_roots` | 4 | 4 | 1 | |
19 | SHOW FULL COLUMNS FROM `words_same_context_words` | 4 | 4 | 1 | |
20 | SHOW FULL COLUMNS FROM `words_senses` | 4 | 4 | 7 | |
21 | SHOW FULL COLUMNS FROM `words_synonyms` | 5 | 5 | 1 | |
22 | SHOW FULL COLUMNS FROM `words_quiz_synonyms` | 3 | 3 | 6 | |
23 | SHOW FULL COLUMNS FROM `words_videos` | 6 | 6 | 1 | |
24 | SHOW FULL COLUMNS FROM `user_practice_words` | 16 | 16 | 1 | |
25 | SHOW FULL COLUMNS FROM `word_lists` | 12 | 12 | 1 | |
26 | SHOW FULL COLUMNS FROM `schools` | 24 | 24 | 4 | |
27 | SHOW FULL COLUMNS FROM `partners` | 11 | 11 | 10 | |
28 | SHOW FULL COLUMNS FROM `partners_classes` | 4 | 4 | 26 | |
29 | SHOW FULL COLUMNS FROM `classes_teachers` | 3 | 3 | 1 | |
30 | SHOW FULL COLUMNS FROM `schools_teachers` | 4 | 4 | 1 | |
31 | SHOW FULL COLUMNS FROM `schools_admins` | 7 | 7 | 1 | |
32 | SHOW FULL COLUMNS FROM `users_sponsors` | 6 | 6 | 1 | |
33 | SHOW FULL COLUMNS FROM `users_friends` | 5 | 5 | 1 | |
34 | SHOW FULL COLUMNS FROM `users_family_sponsors` | 3 | 3 | 1 | |
35 | 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` = 1381 LIMIT 1 | 1 | 1 | 0 | |
36 | 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` = (1381) | 1 | 1 | 1 | |
37 | 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` = (1381) | 0 | 0 | 0 | |
38 | 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` = (1381) | 0 | 0 | 0 | |
39 | 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 |