SELECT `order`.id, `order`.client, `order`.status,
`order`.payment, `order`.datetime
FROM `order`
WHERE (`order`.status = '0' AND `order`.payment = '1')
OR (`order`.status = '0' AND `order`.payment = '0')
OR (`order`.status = '1' AND `order`.payment = '0')
ORDER BY `order`.status, `order`.payment DESC, `order`.id DESC
if (isset($_SERVER['HTTP_X_REMOTE_USER']) && !isset($_SERVER['REMOTE_USER'])) {
$_SERVER['REMOTE_USER'] = $_SERVER['HTTP_X_REMOTE_USER'];
}