As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page.

User:Kipcool/Number of objects

From OmegaWiki
Jump to: navigation, search

SQL[edit]

select `table`, count(object_id) from uw_objects group by `table`;

Result[edit]

On 19.10.2013

I know, there is a table translated_content , and uw_translated_content ... this is weird.

+----------------------------------------+------------------+
| table                                  | count(object_id) |
+----------------------------------------+------------------+
| translated_content                     |            29593 |
| uw_class_attributes                    |              419 |
| uw_class_membership                    |            11807 |
| uw_collection                          |               10 |
| uw_collection_ns                       |               31 |
| uw_defined_meaning                     |            51322 |
| uw_expression                          |           273235 |
| uw_expression_ns                       |           275836 |
| uw_meaning_relations                   |            65016 |
| uw_option_attribute_options            |             1131 |
| uw_option_attribute_values             |            90032 |
| uw_syntrans                            |           614743 |
| uw_text_attribute_values               |            40366 |
| uw_translated_content                  |            22509 |
| uw_translated_content_attribute_values |              558 |
| uw_url_attribute_values                |            18777 |
+----------------------------------------+------------------+