$res = mysqlQuery("SELECT `id`, `subtitle`, `text`,
                           DATE_FORMAT(`date`,'%d') AS `day`, 
                           DATE_FORMAT(`date`,'%m') AS `month`,
                           DATE_FORMAT(`date`,'%Y') AS `year` 
                             FROM `". IRB_DBPREFIX ."news`  
                               WHERE `public` = 1 
                                 AND `id` = " . (int)$GET['news']);

        $res = mysqlQuery("SELECT a.`date`,  a.`text`, b.`autor`
                             FROM `table1` a
                                LEFT JOIN `table2` b ON b.`id` = a.`id_autor`
                               WHERE b.`date` > NOW() - INTERVAL 1 WEEK "
                           );

        $fields = ", b.`autor`";
        $join   = " LEFT JOIN `table2` b ON b.`id` = a.`id_autor`" ;
    
        $res = mysqlQuery("SELECT a.`date`,  a.`text` ". $fields ."
                             FROM `table1` a
                                ". $join ."
                               WHERE a.`date` > NOW() - INTERVAL 1 WEEK "
                           );   

$fields = ", b.`autor`";
$join   = " LEFT JOIN `table2` b ON b.`id` = a.`id_autor`" ;
// здесь еще 50-100 строк кода, с генерацией SQL-запроса    
// А здесь пытаемся вспомнить, что такое $fields и что такое $join
$res = mysqlQuery("SELECT a.`date`,  a.`text` ". $fields ."
                            FROM `table1` a
                             ". $join ."
                              WHERE a.`date` > NOW() - INTERVAL 1 WEEK "
                          );   

$Sql = "SELECT ... FROM Table";
if ($ByAuthor)
    $Sql .= " INNER JOIN Author ON Id = " . $AuthorId;
if (...)
    $Sql .= "...";

print($Sql);

SELECT `site_id`,`date`, DATE_FORMAT(`date`, '%d.%m.%Y') AS `ddt`, DATE_FORMAT(`date`, '%Y-%m-%d') AS`dat`,u.id_user, u.login, SUM(un.ru_uniq) AS ru_uniq, SUM(un.ru_not_uniq) AS ru_not_uniq, SUM(un.ua_uniq) AS ua_uniq, SUM(un.ua_not_uniq) AS ua_not_uniq, SUM(sms_uniq) AS sms_uniq, SUM(sms_not_uniq) AS sms_not_uniq, SUM(other_sms) AS other_sms, SUM(sms_money) AS sms_money, SUM(sms_real_money) AS sms_real_money, SUM(un.ru_uniq + un.other_uniq + un.ru_not_uniq + un.other_not_uniq + un.ua_uniq + un.ua_not_uniq + un.sms_not_uniq) AS ravs, SUM(un.ru_uniq + un.ua_uniq + un.other_uniq + un.sms_uniq) AS uniq, SUM(un.traffic_back_uniq + un.traffic_back_not_uniq) AS traffic_back, sum(un.initial_sales) as initial_sales, SUM(un.rebills) AS rebills, SUM(un.reject) AS reject, SUM(un.sms_money + un.ru_money + un.other_money + un.subscr_money) AS advert_money, SUM(un.referal1_money + un.subscr_referal) AS referal_money, SUM(un.sms_real_money + un.ru_real_money + un.other_real_money + un.subscr_real_money - un.bonus) AS real_money, SUM(un.bonus) AS `bonus` FROM `table1` un LEFT JOIN `table2` u ON u.id_user = un.user_id WHERE DATE_FORMAT(un.`date`, '%Y-%m-%d') >= '2010-08-10' AND DATE_FORMAT(un.`date`, '%Y-%m-%d') <= '2010-08-10' GROUP BY un.user_id

               SELECT `site_id`,`date`, DATE_FORMAT(`date`, '%d.%m.%Y') AS `ddt`, 
                                         DATE_FORMAT(`date`, '%Y-%m-%d') AS`dat`,u.id_user, u.login,
                                         SUM(un.ru_uniq) AS ru_uniq, 
                                         SUM(un.ru_not_uniq) AS ru_not_uniq, 
                                         SUM(un.ua_uniq) AS ua_uniq, 
                                         SUM(un.ua_not_uniq) AS ua_not_uniq,
                                         SUM(sms_uniq) AS sms_uniq, 
                                         SUM(sms_not_uniq) AS sms_not_uniq, 
                                         SUM(other_sms) AS other_sms, 
                                         SUM(sms_money) AS sms_money, 
                                         SUM(sms_real_money) AS sms_real_money,
                                         SUM(un.ru_uniq + un.other_uniq + un.ru_not_uniq + un.other_not_uniq + 
                                         un.ua_uniq + un.ua_not_uniq + un.sms_not_uniq) AS ravs,
                                         SUM(un.ru_uniq + un.ua_uniq + un.other_uniq + un.sms_uniq) AS uniq,                       
                                         SUM(un.traffic_back_uniq + un.traffic_back_not_uniq) AS traffic_back,
                                         sum(un.initial_sales) as initial_sales,                       
                                         SUM(un.rebills) AS rebills,
                                         SUM(un.reject)  AS reject,                                                                                      
                                         SUM(un.sms_money + un.ru_money + un.other_money + un.subscr_money) AS advert_money,
                                         SUM(un.referal1_money + un.subscr_referal) AS referal_money,
                                         SUM(un.sms_real_money + un.ru_real_money + un.other_real_money + un.subscr_real_money - un.bonus) AS real_money,
                                         SUM(un.bonus) AS `bonus`                           
                                         FROM `table1` un
                                         LEFT JOIN `table2` u ON u.id_user = un.user_id
                                         WHERE DATE_FORMAT(un.`date`, '%Y-%m-%d') >= '2010-08-10' 
                                         AND DATE_FORMAT(un.`date`, '%Y-%m-%d') <= '2010-08-10'
                                         GROUP BY  un.user_id

$sql = "SELECT `id`, `name` FROM `people` "
     . "WHERE `name` = 'Susan' "
     . "ORDER BY `name` ASC ";

$sql = "SELECT `id`, `name` FROM `people` 
        WHERE `name` = 'Susan' 
        ORDER BY `name` ASC ";