SELECT `adv_id` as `id`, `adv_img_sqr` as `img_sqr`, `adv_img_hor` as `img_hor`,
                   `adv_title` as `title`, `adv_desc` as `desc`,
                   `adv_views` as `all_views`, `adv_clicks` as `all_clicks`,
                   `link_href` as `url`, `adv_link`,
`stat_all`.`teas_clicks` as `all_clicks`, `stat_all`.`teas_views` as `all_views`,
                        `stat_all`.`teas_out` as `all_out`, `stat_all`.`teas_in` as `all_in`,
                    `stat_per`.`teas_clicks` as `per_clicks`, `stat_per`.`teas_views` as `per_views`,
                        `stat_per`.`teas_out` as `per_out`, `stat_per`.`teas_in` as `per_in`
                FROM `adv_main`
                LEFT JOIN `news_teas_cache` as `stat_all` ON `stat_all`.`teas_id` = `adv_main`.`adv_id`
                        AND `stat_all`.`teas_period` = 0 AND `stat_all`.`teas_cat` = 0
                LEFT JOIN `news_teas_cache` as `stat_per` ON `stat_per`.`teas_id` = `adv_main`.`adv_id`
                        AND `stat_per`.`teas_period` = 1 AND `stat_per`.`teas_cat` = 0
                JOIN `adv_links` ON `adv_links`.`link_id` = `adv_main`.`adv_link`
                WHERE
                    `adv_status` = '1' AND FIND_IN_SET('RU',`link_target_geo`) > 0 AND `adv_shock` = '0'
                ORDER BY `adv_id` ASC