Anonymous

mysql> SELECT c1.object_id,c1.char_obj_id,c1.item_id From character_inventory c1, character_inventory c2 where c1.char_obj_id != c2.char_obj_id AND c1.object_id = c2.object_id order by object_id;
+-----------+-------------+---------+
| object_id | char_obj_id | item_id |
+-----------+-------------+---------+
| 270526836 |   270410180 |    1463 |
| 270526836 |   269210477 |    1341 |
| 270532492 |   268548947 |    1902 |
| 270532492 |   270530230 |      22 |
| 270535364 |   270535363 |    1147 |
| 270535364 |   268588816 |    1872 |
| 270651165 |   268627143 |    2150 |
| 270651165 |   271032610 |     118 |
| 270713354 |   270645681 |    1871 |
| 270713354 |   268719674 |     177 |
| 270717818 |   268628091 |    3432 |
| 270717818 |   268661611 |     629 |
| 270779374 |   270779368 |    1863 |
| 270779374 |   270778995 |    1868 |
| 270819271 |   270818062 |    1870 |
| 270819271 |   268465905 |    1864 |
| 271068772 |   270784817 |      57 |
| 271068772 |   268697986 |    1129 |
| 271233121 |   269025326 |    4043 |
| 271233121 |   271231457 |    1865 |
| 271267241 |   271267085 |      42 |
| 271267241 |   270931865 |      57 |
| 271273605 |   268976353 |     924 |
| 271273605 |   271272066 |    1665 |
| 271274555 |   271122044 |     112 |
| 271274555 |   268707844 |     896 |
| 271281839 |   271279911 |    1870 |
| 271281839 |   270644180 |      57 |
| 271282619 |   271122191 |    2945 |
| 271282619 |   268756872 |      44 |
| 271283576 |   271072824 |    1867 |
| 271283576 |   271283572 |       6 |
| 271283812 |   270908782 |    1463 |
| 271283812 |   268944603 |    1870 |
| 271284079 |   268674053 |      57 |
| 271284079 |   271183412 |      57 |
| 271285244 |   271122044 |      42 |
| 271285244 |   271183412 |    1050 |
| 271320621 |   271320550 |      57 |
| 271320621 |   270828728 |    1101 |
| 271322257 |   271322255 |     425 |
| 271322257 |   271235530 |    1864 |
| 271327940 |   271277240 |     412 |
| 271327940 |   271314706 |    1897 |
| 271357969 |   268921188 |     464 |
| 271357969 |   271356587 |    1049 |
| 271367736 |   271367734 |     425 |
| 271367736 |   271364137 |     112 |
| 271412666 |   271412663 |      10 |
| 271412666 |   271348687 |     279 |
| 271417026 |   271123590 |     906 |
| 271417026 |   268477122 |    1934 |
| 271418437 |   268570754 |     604 |
| 271418437 |   268556840 |    1874 |
| 271484946 |   270107895 |    1864 |
| 271484946 |   271484156 |     428 |
+-----------+-------------+---------+
56 rows in set (2.47 sec)