Косметика Салоны красоты

DB-error: Ошибка обращения в запросе (SELECT /* файл /home/vseokrasote/data/www/vseokrasote.ru/load_template.php , строка 15 , функция include */ `k`.`xid` AS `cid` ,`k`.`data1` AS `c_title` ,`k`.`url` ,`k`.`engtitle` AS `c_engtitle` ,`k`.`typeis` AS `c_typeis` ,`k`.`cosmo` AS `c_cosmo` ,`k`.`plast` AS `c_plast` ,`k`.`stom` AS `c_stom` ,`k`.`cosmet` AS `c_cosmet` ,`k`.`fitnes` AS `c_fitnes` ,`k`.`phone` AS `c_phone` ,`k`.`cost` AS `c_cost` ,`k`.`rate` AS `c_rate` ,`k`.`logo` AS `logo` ,`s`.`position` AS `rating` ,`p`.`u_plusgrade` AS `p_uslugi` ,`p`.`s_plusgrade` AS `p_otnoshenie` ,COUNT(DISTINCT(`f`.`data1`)) AS `fav` ,`a1`.`xid` AS `aid` ,`a1`.`title` AS `a_filial` ,`a1`.`typeis` AS `a_typeis` ,`a1`.`address` AS `a_address` ,`a1`.`phone1` AS `a_phone1` ,`a1`.`phone2` AS `a_phone2` ,`a1`.`phone3` AS `a_phone3` ,`a1`.`phone4` AS `a_phone4` ,`m1`.`data1` AS `metro1` ,`m1`.`vcolor` AS `mcolor1` ,`m2`.`data1` AS `metro2` ,`m2`.`vcolor` AS `mcolor2` ,`m3`.`data1` AS `metro3` ,`m3`.`vcolor` AS `mcolor3` ,`m4`.`data1` AS `metro4` ,`m4`.`vcolor` AS `mcolor4` ,`m5`.`data1` AS `metro5` ,`m5`.`vcolor` AS `mcolor5` ,COUNT(DISTINCT(`a1`.`xid`)) AS `addresses` ,COUNT(DISTINCT(`c`.`xid`)) / COUNT(DISTINCT(`a1`.`xid`)) AS `costs` ,IF(MIN(`c`.`coststart`) > 0, MIN(`c`.`coststart`), 0) AS `coststart` ,IF(MAX(`c`.`costend`) > 0, MAX(`c`.`costend`), 0) AS `costend` ,`c`.`comment` AS `costcomment` ,LOWER(`cc`.`data1`) AS `currency` ,`o`.`data1` AS `oper` ,IF(`o`.`rkey` - `o`.`lkey` > 1, 2, 1) AS `inneropers` FROM `cm_data_5` AS `k` LEFT JOIN `cm_data_6` AS `a1` ON `a1`.`data1` = `k`.`xid` AND `a1`.`sid` = 0 LEFT JOIN `cm_data_19` AS `m1` ON `m1`.`xid` = `a1`.`metro1` AND `m1`.`sid` = 0 LEFT JOIN `cm_data_19` AS `m2` ON `m2`.`xid` = `a1`.`metro2` AND `m2`.`sid` = 0 LEFT JOIN `cm_data_19` AS `m3` ON `m3`.`xid` = `a1`.`metro3` AND `m3`.`sid` = 0 LEFT JOIN `cm_data_19` AS `m4` ON `m4`.`xid` = `a1`.`metro4` AND `m4`.`sid` = 0 LEFT JOIN `cm_data_19` AS `m5` ON `m5`.`xid` = `a1`.`metro5` AND `m5`.`sid` = 0 LEFT JOIN `cm_data_25` AS `f` ON `f`.`clinic` = `k`.`xid` AND `f`.`sid` = 0 LEFT JOIN `cm_data_7` AS `s` ON `s`.`data1` = `k`.`xid` AND `s`.`statmonth` = '0' AND `s`.`cosmet` = '1' LEFT JOIN `cm_data_153` AS `p` ON `p`.`show` = 1 AND `p`.`sid` = 0 AND `p`.`table` = '5' AND `p`.`record` = `k`.xid INNER JOIN `cm_data_647` AS `c` ON `c`.`data1` = `k`.`xid` AND `c`.`address` = `a1`.`xid` AND `c`.`doc` = 0 AND (`c`.`oper` = '11244') LEFT JOIN `cm_data_649` AS `cc` ON `cc`.`xid` = `c`.`curr` AND `cc`.`sid` = 0 LEFT JOIN `cm_data_2` AS `o` ON `o`.`xid` = `c`.`oper` AND `o`.`sid` = 0 AND `o`.`cosmet` = 1 WHERE `k`.`sid` = 0 AND `k`.`active` = 1 AND `a1`.`active` = 1 AND `k`.`checked` = 1 AND `a1`.`checked` = 1 AND `k`.`cosmet` = 1 AND `a1`.`cosmet` = 1 AND `a1`.`country` = '73' AND `a1`.`region` = '548' AND `a1`.`city` = '6246' GROUP BY `k`.`xid` HAVING `costs` >= 1 ORDER BY `k`.`rate` DESC, `k`.`data1` ASC, `k`.`engtitle` ASC LIMIT 0, 20;)!