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/lingala-delete
juste in case, a log of what was deleted...
mysql> select * FROM language WHERE language_id = 157 ; +-------------+----------------+----------+----------+---------------+ | language_id | dialect_of_lid | iso639_2 | iso639_3 | wikimedia_key | +-------------+----------------+----------+----------+---------------+ | 157 | 0 | lin-Latn | lin-Latn | | +-------------+----------------+----------+----------+---------------+ mysql> select * FROM language_names WHERE language_id = 157 ; +-------------+------------------+-----------------+ | language_id | name_language_id | language_name | +-------------+------------------+-----------------+ | 157 | 85 | Lingala (Latin) | +-------------+------------------+-----------------+ mysql> select * FROM uw_syntrans WHERE expression_id IN ( SELECT expression_id FROM uw_expression WHERE language_id = 157 ) ; +--------------+--------------------+---------------+-------------------+--------------------+-----------------------+ | syntrans_sid | defined_meaning_id | expression_id | identical_meaning | add_transaction_id | remove_transaction_id | +--------------+--------------------+---------------+-------------------+--------------------+-----------------------+ | 320597 | 7771 | 159741 | 1 | 6446 | 363121 | | 301832 | 5440 | 159743 | 1 | 6449 | 363120 | | 304808 | 5713 | 159744 | 1 | 6449 | 363119 | | 325450 | 8363 | 159909 | 1 | 6556 | 363115 | | 325451 | 8363 | 159910 | 1 | 6558 | 363116 | | 307218 | 5961 | 159911 | 1 | 6559 | 363122 | | 307219 | 5961 | 159912 | 1 | 6560 | 363123 | | 307220 | 5961 | 159913 | 1 | 6561 | 363124 | | 305981 | 5827 | 160624 | 1 | 7337 | 363125 | | 313691 | 6656 | 160625 | 1 | 7338 | 363128 | | 307694 | 6003 | 160628 | 1 | 7341 | 363132 | | 308489 | 6059 | 160631 | 1 | 7344 | 363112 | | 374952 | 374935 | 374951 | 1 | 31116 | 363117 | | 381753 | 6102 | 381752 | 1 | 35248 | 363109 | | 381755 | 5613 | 381754 | 1 | 35249 | 363110 | | 381757 | 6100 | 381756 | 1 | 35250 | 363131 | | 381759 | 5995 | 381758 | 1 | 35251 | 363130 | | 381762 | 5612 | 381758 | 1 | 35253 | 363126 | | 406552 | 5816 | 406551 | 1 | 48966 | 363129 | | 406646 | 7321 | 406645 | 1 | 49054 | 363111 | | 668098 | 668094 | 668097 | 1 | 144069 | 363113 | | 683891 | 2358 | 683890 | 1 | 151223 | 363118 | | 823574 | 5912 | 823573 | 1 | 216869 | 363127 | +--------------+--------------------+---------------+-------------------+--------------------+-----------------------+ mysql> select * FROM uw_expression WHERE language_id = 157 ; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 5299 Current database: omegawikib +---------------+-----------+-------------+--------------------+-----------------------+ | expression_id | spelling | language_id | add_transaction_id | remove_transaction_id | +---------------+-----------+-------------+--------------------+-----------------------+ | 159741 | ling�la | 157 | 6446 | NULL | | 159743 | mon?k? | 157 | 6449 | NULL | | 159744 | lok�t� | 157 | 6449 | NULL | | 159909 | kib??k? | 157 | 6556 | NULL | | 159910 | ngub� | 157 | 6558 | NULL | | 159911 | nk??si | 157 | 6559 | NULL | | 159912 | nt�mbo | 157 | 6560 | NULL | | 159913 | simba | 157 | 6561 | NULL | | 160624 | kol�a | 157 | 7337 | NULL | | 160625 | koloba | 157 | 7338 | NULL | | 160628 | kom??n? | 157 | 7341 | NULL | | 160631 | kop??sa | 157 | 7344 | NULL | | 374951 | Kins�s� | 157 | 31116 | NULL | | 381752 | likonz�mi | 157 | 35248 | NULL | | 381754 | lilandi | 157 | 35249 | NULL | | 381756 | likelelo | 157 | 35250 | NULL | | 381758 | nk�mb� | 157 | 35251 | NULL | | 406551 | likambo | 157 | 48966 | NULL | | 406645 | dendon | 157 | 49054 | NULL | | 668097 | fundare | 157 | 144069 | NULL | | 683890 | m�liki | 157 | 151223 | NULL | | 823573 | w�lo | 157 | 216869 | NULL | +---------------+-----------+-------------+--------------------+-----------------------+ mysql> select * FROM uw_text WHERE uw_text.text_id IN ( 130709, 220573 ) ; +---------+-----------------------------------------------------------------------------------------------------+------------+ | text_id | text_text | text_flags | +---------+-----------------------------------------------------------------------------------------------------+------------+ | 130709 | lokótá bantu balobaka ya likoló lya Kɔngɔ-Brazzaville mpé ya límbe lya Kɔngɔ-Kinshasa. | | | 220573 | Lokótá bantu balobaka o likoló lya Kongó-Brazzaville mpé o límbe lya Kongó-Kinshasa. | | +---------+-----------------------------------------------------------------------------------------------------+------------+ mysql> select * FROM uw_translated_content WHERE language_id=157 ; +-----------------------+-------------+---------+--------------------+-----------------------+ | translated_content_id | language_id | text_id | add_transaction_id | remove_transaction_id | +-----------------------+-------------+---------+--------------------+-----------------------+ | 153104 | 157 | 130709 | 6448 | 191174 | | 153104 | 157 | 220573 | 191174 | 363145 | +-----------------------+-------------+---------+--------------------+-----------------------+
