Код: Выделить всё
SELECT * FROM (
SELECT TOP {$limit} * FROM (
$sql
) as [__inner top table__] {$reverseOrdering}
) as [__outer top table__] {$orginalOrdering}
Код: Выделить всё
SELECT * FROM (
SELECT TOP $limit * FROM (
$sql
) as [__inner top table__] {$this->removeTableAlias($reverseOrdering)}
) as [__outer top table__] {$this->removeTableAlias($orginalOrdering) }
Код: Выделить всё
protected function removeTableAlias($sql)
{
return preg_replace('/\s+\[[^\]]+\]\.(\[[^\]]+\])/i', ' \1', $sql);
}