SELECT item.*,
user.username,
user.avatar_date,
user.is_banned,
user.user_group_id,
user.secondary_group_ids,
user.display_style_group_id,
market_user.*,
steam_item.*
FROM (
SELECT item.*,
user.username,
user.avatar_date,
user.is_banned,
user.user_group_id,
user.secondary_group_ids,
user.display_style_group_id,
market_user.*,
steam_item.*
FROM market_item AS item
LEFT JOIN xf_user AS user
ON ( item.user_id = user.user_id )
INNER JOIN market_user
ON ( item.user_id = market_user.user_id )
LEFT JOIN market_steam_item AS steam_item
ON ( item.item_id = steam_item.steam_item_id )
WHERE ( item.category_id = 1 )
AND ( item.item_state = 'active' )
AND ( (SELECT Count(*)
FROM market_item_game
WHERE market_item_game.item_id = item.item_id
AND (( game_id = 730
AND market_item_game.is_banned = 0 ))) = 1 )
AND ( steam_item.steam_csgo_ban_date < 1579026194 )
AND ( steam_item.account_community_ban = 0 )
LIMIT 20
)
ORDER BY item.price ASC