mysql> select p.item_id, p.name, p.crystal_type, server from items i left join characters c on i.owner_id = c.obj_Id left join prices p on i.item_id = p.item_id where p.crystal_type='a' and accesslevel=0 and p.name not rlike 'Arrow|Crystal:|Spiritshot:|Soulshot:|Sealed';
+---------+--------------------------------+--------------+--------+
| item_id | name | crystal_type | server |
+---------+--------------------------------+--------------+--------+
| 365 | Dark Crystal Breastplate | a | planet |
| 388 | Dark Crystal Gaiters | a | planet |
| 512 | Dark Crystal Helmet | a | planet |
| 2382 | Tallum Plate Armor | a | planet |
| 2385 | Dark Crystal Leather Armor | a | planet |
| 2389 | Dark Crystalline Leggings | a | planet |
| 2393 | Tallum Leather Armor | a | bal |
| 2395 | Majestic Leather Armor | a | planet |
| 2400 | Tallum Tunic | a | planet |
| 2405 | Tallum Stockings | a | planet |
| 2407 | Dark Crystal Robe | a | planet |
| 2408 | Robe of Nightmare | a | bal |
| 2408 | Robe of Nightmare | a | planet |
| 2409 | Majestic Robe | a | planet |
| 2410 | Nightmarish Tattoo | a | bal |
| 2419 | Majestic Circlet | a | planet |
| 2445 | Dragon Scale Boots | a | bal |
| 5765 | Dark Crystal Gloves Heavy | a | planet |
| 5766 | Dark Crystal Gloves Light | a | planet |
| 5767 | Dark Crystal Gloves Robe | a | planet |
| 5768 | Tallum Gloves Heavy | a | planet |
| 5770 | Tallum Gloves Robe | a | planet |
| 5772 | Gloves of Nightmare Light | a | planet |
| 5773 | Gloves of Nightmare Robe | a | planet |
| 5775 | Majestic Gloves Light | a | planet |
| 5776 | Majestic Gloves Robe | a | planet |
| 5777 | Dark Crystal Boots Heavy | a | planet |
| 5778 | Dark Crystal Boots Light | a | planet |
| 5779 | Dark Crystal Boots Robe | a | planet |
| 5780 | Tallum Boots Heavy | a | planet |
| 5781 | Tallum Boots Light | a | planet |
| 5782 | Tallum Boots Robe | a | planet |
| 5784 | Boots of Nightmare Light | a | planet |
| 5785 | Boots of Nightmare Robe | a | planet |
| 5787 | Majestic Boots Light | a | planet |
| 5788 | Majestic Boots Robe | a | planet |
| 5233 | Keshanberk*Keshanberk | a | planet |
| 5613 | Soul Bow Critical Poison | a | bal |
| 5618 | Soul Separator Critical Damage | a | bal |
| 5634 | Tallum Glaive Wide Blow | a | bal |
+---------+--------------------------------+--------------+--------+
40 rows in set (0.02 sec)
будет визуально нагляднее.