$countQuery = preg_replace("/select[ /r/n/t](.*)[ /r/n/t]from/i","Select count(*) as dd From",$this->sourceSql);

    $countQuery = preg_replace("#SELECT[ /r/n/t](.*)[ /r/n/t]FROM#is", 'SELECT COUNT(*) AS dd FROM', $this->sourceSql);
   $countQuery = preg_replace("#ORDER[ /r/n/t]{1,}BY(.*)#is", '', $countQuery);