SELECT id, name, level, exp, playtime, empire, guild_name, rang
              FROM (
                SELECT id, name, level, exp, playtime, empire, guild_name, @num := @num +1 AS rang
                  FROM (
                    SELECT player.id, player.name, player.level, player.exp, player.playtime, player_index.empire, guild.name AS guild_name, @num :=0
                      FROM player.player
                    LEFT JOIN player.player_index
                      ON player_index.id = player.account_id
                    LEFT JOIN player.guild_member
                      ON guild_member.pid = player.id
                    LEFT JOIN player.guild
                      ON guild.id = guild_member.guild_id
                    INNER JOIN account.account
                      ON account.id=player.account_id
                    WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK' ".$filter."
                    ORDER BY player.level DESC, player.playtime DESC, player.exp DESC, player.name DESC

                 ) AS t1

            ) AS t2

      WHERE name = ...;
-------------------------------------------------------------------------

SELECT
          itemshop.id AS uid,
          itemshop.price AS price,
          itemshop.visible AS visible,
          itemshop.cat as category,
          itemshop.qty AS qty,
          itemshop.descr AS description,
          itemdesc.`name` AS tname,
          itemdesc.descr AS tdesc,
          item_list.icon AS icon,
          CONVERT (
              item_proto.locale_name USING cp1250
          ) AS lname,
          item_proto.*
        FROM
          account.itemshop
        LEFT JOIN player.itemdesc ON itemshop.vnum = itemdesc.vnum
        LEFT JOIN player.item_list ON itemshop.vnum = item_list.vnum
        LEFT JOIN player.item_proto ON itemshop.vnum = item_proto.vnum
    ORDER BY IF(item_proto.limittype0=1, item_proto.limitvalue0, item_proto.limitvalue1) DESC;

pak za tím je ještě tahle kráska, která to znovu filtruje:
            if ($args) {
                $fh = new FlagHelper($data->antiflag,EFlagSets::ItemAntiFlagSet);
                if ($args[0] == 0 && $data->wearflag == 1 && $data->type == 2) continue;
                if ($args[1] == 0 && $data->type == 28) continue;
                if ($args[2] == 0 && in_array($data->vnum,$mounts_id)) continue;
                if ($args[3] == 0 && in_array($data->vnum,$pet_id)) continue;
                if ($args[4] == 0 && $data->type == 10) continue;
                if ($args[5] == 0 && (in_array($data->type, $special_types) && !in_array($data->vnum,$mounts_id) && !in_array($data->vnum,$pet_id))) continue;
                if ($args[6] == 0 && $data->wearflag == 1 && $data->type == 2 && @!$fh->IsFlagged(EItemAntiFlag::ITEM_ANTIFLAG_WARRIOR)) continue;
                if ($args[7] == 0 && $data->wearflag == 1 && $data->type == 2 && @!$fh->IsFlagged(EItemAntiFlag::ITEM_ANTIFLAG_ASSASSIN)) continue;
                if ($args[8] == 0 && $data->wearflag == 1 && $data->type == 2 && @!$fh->IsFlagged(EItemAntiFlag::ITEM_ANTIFLAG_SHAMAN)) continue;
                if ($args[9] == 0 && $data->wearflag == 1 && $data->type == 2 && @!$fh->IsFlagged(EItemAntiFlag::ITEM_ANTIFLAG_SURA)) continue;
                if ( ($data->limittype0 == 1 && $data->limitvalue0 < $args[11]) || ($data->limittype1 == 1 && $data->limitvalue1 < $args[11])) continue;
                if ( ($data->limittype0 == 1 && $data->limitvalue0 > $args[12]) || ($data->limittype1 == 1 && $data->limitvalue1 > $args[12])) continue;

            }