Please read our trading rules. Welcome to the largest and most active H1Z1 trading site.

PSA: Always hover over items in a Steam trade offer to ensure they are for the correct game, don't get caught out by scammers!
Can't create/write to file '/tmp/#sql_779e_0.MAI' (Errcode: 122)

SELECT `trades`.*, `users`.`username`, `users`.`level` AS `userlevel`, `users`.`steamid`, `users`.`tradeurl` FROM `trades_items` FORCE INDEX (`id_side_status`,`trade_id`) INNER JOIN `trades` FORCE INDEX(`status`) ON `trades`.`trade_id` = `trades_items`.`trade_id` INNER JOIN `users` FORCE INDEX(PRIMARY) ON `trades`.`user_id` = `users`.`id` WHERE ( (`trades_items`.`side` = 'h' AND `trades_items`.`item_id` IN ('919')) ) AND `trades_items`.`status` = 1 AND `trades`.`status` = 1 GROUP BY `trades_items`.`trade_id` HAVING COUNT(DISTINCT `trades_items`.`side`) = 1 AND COUNT(DISTINCT `trades_items`.`item_id`) >= 1 ORDER BY `trades`.`timestamp` DESC LIMIT 20 OFFSET 0