SELECT `node`.`nid` AS `id`,
`node_type`.`field_short_newbuild_name_value` AS `title`,
`node_type`.`field_panorama_value` AS `panorama`,
`node_type`.`field_newbuild_end_value` AS `goskom`,
`node_type`.`field_newbuild_class_value` AS `class_value`,
`node_type`.`field_excursia_value` AS `excurisa`,
`node_type`.`field_prodano_value` AS `prodano`,
`node_type`.`field_newbuild_price_min_value` AS `forced_min_price`,
`nr`.`teaser` AS `teaser`,
`nr`.`body` AS `body`,
`node`.`created` AS `created`,
`node`.`changed` AS `changed`,
`node_type`.`field_newbuild_car_value` AS `car_place`,
`site`.`field_newbuild_url_url` AS `site`,
`site`.`field_newbuild_url_title` AS `site_title`,
`meta_title`.`field_meta_title_value` AS `meta_title`,
`meta_description`.`field_meta_content_value` AS `meta_description`,
`meta_keywords`.`field_meta_keywords_value` AS `meta_keywords`,
`h1`.`field_h1_value` AS `h1`,
`place_0_td`.`name` AS place_country,
case when `place_1`.`field_newbuild_place_value` IN (70,71) then `place_1`.`field_newbuild_place_value` else 49 end AS `place_region_id`,
case when `place_1`.`field_newbuild_place_value` IN (71,1111) then `place_1_td`.`name`
							 when `place_1`.`field_newbuild_place_value` IN (70,3057) then `place_3_td`.`name`
	 					else `place_2_td`.`name` end AS `place_city`,
case when `place_1`.`field_newbuild_place_value` IN (71,1111) then `place_1_td`.`tid`
							 when `place_1`.`field_newbuild_place_value` IN (70,3057) then `place_3_td`.`tid`
	 					else `place_2_td`.`tid` end AS `place_city_id`,
case when `place_1`.`field_newbuild_place_value` = 71 then `place_2_td`.`name` else NULL end AS `place_okrug`,
case when `place_1`.`field_newbuild_place_value` = 71 then `place_2_td`.`tid` else NULL end AS `place_okrug_id`,
case when `place_1`.`field_newbuild_place_value` IN (70,71, 3057) then `place_4_td`.`name` else `place_3_td`.`name` end AS `place_street`,
case when `place_1`.`field_newbuild_place_value` IN (70,71, 3057) then `place_3_td`.`name` else `place_3_td`.`name` end AS `place_rayonmsk`,
case when `place_1`.`field_newbuild_place_value` IN (70,71, 3057) then `place_5_td`.`name` else `place_4_td`.`name` end AS `place_house`,
`bc_region`.`tid` AS `bc_region`,
`bc_region`.`name` AS `bc_region_title`,
`bc_district`.`tid` AS `bc_district`,
`bc_district`.`name` AS `bc_district_title`,
`bc_town`.`tid` AS `bc_town`,
`bc_town`.`name` AS `bc_town_title`,
`bc_metro`.`tid` AS `bc_metro`,
`bc_metro`.`name` AS `bc_metro_title`,
GROUP_CONCAT(DISTINCT CONCAT(`metro_title`.`tid`,'-',`metro_title`.`name`) ORDER BY `metro`.`delta` SEPARATOR ',') as `metro`,
GROUP_CONCAT(DISTINCT `floor`.`field_newbuild_floor_value` ORDER BY `floor`.`delta` SEPARATOR ', ') AS floor,
GROUP_CONCAT(DISTINCT `area`.`field_newbuild_area_value` ORDER BY `area`.`delta` SEPARATOR ', ') AS area,
MIN(`price`.`field_newbuild_price_value`)*1000/CURRENCY_RATE AS `price`,
MAX(`price`.`field_newbuild_price_value`)*1000/CURRENCY_RATE AS `price_max`,
MIN(`price`.`field_newbuild_price_value`)*MIN(`area`.`field_newbuild_area_value`)*1000/CURRENCY_RATE AS `price_full`,
GROUP_CONCAT(DISTINCT `phase_name`.`name` ORDER BY `phase`.`delta` SEPARATOR ', ') AS phase_name,
`build_type`.`name` AS `build_type`,
GROUP_CONCAT(DISTINCT `remont`.`field_newbuild_remont_value` ORDER BY `remont`.`field_newbuild_remont_value` SEPARATOR ',') AS `remont`,
GROUP_CONCAT(DISTINCT `rooms`.`field_newbuild_rooms_value` ORDER BY `rooms`.`delta` SEPARATOR ', ') AS rooms,
COUNT(DISTINCT `xml`.`build_place`) AS `xml`,
GROUP_CONCAT(DISTINCT `xmlrooms`.`rooms` ORDER BY `xmlrooms`.`rooms` SEPARATOR ', ') AS `xmlroomz`,
COUNT(DISTINCT `tgb`.`nid`) AS `tgbactiv`,
`tgb`.`field_tgb_url_value` AS `tgburl`,
`tgb`.`field_text_tgb_value` AS `tgbtext`,
`tgb`.`field_tgb172_footer_value` AS `tgbprice`,
`tgb`.`vid` AS `tgbid`,
`tgbimage`.`filepath` AS `tgbimageurl`,
`tgbtitle`.`title` AS `tgbtitle`,
`sform`.`field_salesform_value` AS `form`,
`field_sales_phone_value` AS `phone`,
`location`.`latitude` AS lat,
`location`.`longitude` AS lng,
replace(`photo_files`.`filepath`, 'sites/default/files/', '') AS `photo`
FROM `node`
JOIN `content_type_newbuild`  `node_type`  ON `node`.`nid` = `node_type`.`nid`/* 12str nodetype */
LEFT JOIN `content_field_priority_check`  `prcheck`  ON `node_type`.`nid` = `prcheck`.`nid`/* nodetype13str */
LEFT JOIN `content_field_newbuild_place`  `c`  ON `node`.`nid` = `c`.`nid`
LEFT JOIN `node_revisions`  `nr`  ON `node`.`nid` = `nr`.`nid`
LEFT JOIN `content_field_newbuild_url`  `site`  ON `node`.`nid` = `site`.`vid`
LEFT JOIN `content_field_meta_title`  `meta_title`  ON `node`.`nid` = `meta_title`.`nid`
LEFT JOIN `content_field_meta_content`  `meta_description`  ON `node`.`nid` = `meta_description`.`nid`
LEFT JOIN `content_field_meta_keywords`  `meta_keywords`  ON `node`.`nid` = `meta_keywords`.`nid`
LEFT JOIN `content_field_h1`  `h1`  ON `node`.`nid` = `h1`.`nid`
LEFT JOIN `content_field_newbuild_place`  `place_0`  ON `node`.`nid` = `place_0`.`nid` AND `place_0`.`field_newbuild_place_value` = 49
LEFT JOIN `term_data`  `place_0_td`  ON `place_0`.`field_newbuild_place_value` = `place_0_td`.`tid`
LEFT JOIN `content_field_newbuild_place`  `place_1`  ON `node`.`nid` = `place_1`.`nid` AND `place_1`.`delta` = `place_0`.`delta` - 1
LEFT JOIN `term_data`  `place_1_td`  ON `place_1`.`field_newbuild_place_value` = `place_1_td`.`tid`
LEFT JOIN `content_field_newbuild_place`  `place_2`  ON `node`.`nid` = `place_2`.`nid` AND `place_2`.`delta` = `place_0`.`delta` - 2
LEFT JOIN `term_data`  `place_2_td`  ON `place_2`.`field_newbuild_place_value` = `place_2_td`.`tid`
LEFT JOIN `content_field_newbuild_place`  `place_3`  ON `node`.`nid` = `place_3`.`nid` AND `place_3`.`delta` = `place_0`.`delta` - 3
LEFT JOIN `term_data`  `place_3_td`  ON `place_3`.`field_newbuild_place_value` = `place_3_td`.`tid`
LEFT JOIN `content_field_newbuild_place`  `place_4`  ON `node`.`nid` = `place_4`.`nid` AND `place_4`.`delta` = `place_0`.`delta` - 4
LEFT JOIN `term_data`  `place_4_td`  ON `place_4`.`field_newbuild_place_value` = `place_4_td`.`tid`
LEFT JOIN `content_field_newbuild_place`  `place_5`  ON `node`.`nid` = `place_5`.`nid` AND `place_5`.`delta` = `place_0`.`delta` - 5
LEFT JOIN `term_data`  `place_5_td`  ON `place_5`.`field_newbuild_place_value` = `place_5_td`.`tid`
LEFT JOIN (SELECT `nid`, `tid`, `field_newbuild_place_value` AS `value`, `name` FROM `content_field_newbuild_place` JOIN `term_data` ON `tid` = `field_newbuild_place_value`)  `bc_region`  ON `node`.`nid` = `bc_region`.`nid` AND `bc_region`.`value` IN (SELECT `tid` FROM `term_hierarchy` WHERE `parent`=49)
LEFT JOIN (SELECT `nid`, `tid`, `field_newbuild_place_value` AS `value`, `name` FROM `content_field_newbuild_place` JOIN `term_data` ON `tid` = `field_newbuild_place_value`)  `bc_district`  ON `node`.`nid` = `bc_district`.`nid` AND `bc_district`.`value` IN (SELECT `tid` FROM `term_hierarchy` WHERE `parent` IN (SELECT `tid` FROM `term_hierarchy` WHERE `parent`=49))
LEFT JOIN (SELECT `nid`, `tid`, `field_newbuild_place_value` AS `value`, `name` FROM `content_field_newbuild_place` JOIN `term_data` ON `tid` = `field_newbuild_place_value`)  `bc_town`  ON `node`.`nid` = `bc_town`.`nid` AND `bc_town`.`value` IN (SELECT `tid` FROM `term_hierarchy` WHERE `parent` IN (SELECT `tid` FROM `term_hierarchy` WHERE `parent`=70))
LEFT JOIN (SELECT `nid`, `tid`, `field_newbuild_metro_value` AS `value`, `name` FROM `content_field_newbuild_metro` JOIN `term_data` ON `tid` = `field_newbuild_metro_value`)  `bc_metro`  ON `node`.`nid` = `bc_metro`.`nid` AND `bc_metro`.`value` IN (SELECT `tid` FROM `term_hierarchy` WHERE `parent` IN (SELECT `tid` FROM `term_hierarchy` WHERE `parent`=1117))
LEFT JOIN `content_field_newbuild_metro`  `metro`  ON `node`.`nid` = `metro`.`nid` AND `metro`.`field_newbuild_metro_value` IN (
				SELECT `metro_station`.`tid` 
				FROM `term_hierarchy` `metro_okrug` 
				JOIN `term_hierarchy` `metro_station` ON `metro_okrug`.`tid`=`metro_station`.`parent`
				WHERE `metro_okrug`.`parent` = 1117
			)
LEFT JOIN `term_data`  `metro_title`  ON `metro`.`field_newbuild_metro_value` = `metro_title`.`tid`
LEFT JOIN `content_field_newbuild_floor`  `floor`  ON `node`.`nid` = `floor`.`nid`
LEFT JOIN `content_field_newbuild_area`  `area`  ON `node`.`nid` = `area`.`nid`
LEFT JOIN `content_field_newbuild_price`  `price`  ON `node`.`nid` = `price`.`nid`
LEFT JOIN `content_field_newbuild_phase`  `phase`  ON `node`.`nid` = `phase`.`nid`
LEFT JOIN `term_data`  `phase_name`  ON `phase`.`field_newbuild_phase_value` = `phase_name`.`tid`
LEFT JOIN `term_data`  `build_type`  ON `node_type`.`field_newbuild_type_value` = `build_type`.`tid`
LEFT JOIN `content_field_newbuild_remont`  `remont`  ON `node_type`.`nid` = `remont`.`nid`
LEFT JOIN `content_field_newbuild_rooms`  `rooms`  ON `node`.`nid` = `rooms`.`nid`
LEFT JOIN `nk_xml_import`.`xml_places`  `xml`  ON `node`.`nid` = `xml`.`build_place` /* metka */
LEFT JOIN `nk_xml_import`.`kvartiri`  `xmlrooms`  ON `xml`.`yandex_building_id` = `xmlrooms`.`yaid` /* metka rooms */
LEFT JOIN `content_type_ad_banners`  `tgb`  ON `node`.`nid` = `tgb`.`field_objectid_nid` AND `tgb`.`field_tgb_start_date_value`<= UNIX_TIMESTAMP() AND `tgb`.`field_tgb_end_date_value` >= UNIX_TIMESTAMP() /* vrezka */
LEFT JOIN `files`  `tgbimage`  ON `tgb`.`field_172x124image_fid` = `tgbimage`.`fid`
LEFT JOIN `node`  `tgbtitle`  ON `tgb`.`nid` = `tgbtitle`.`nid`
LEFT JOIN `content_field_salesform`  `sform`  ON `node`.`nid` = `sform`.`vid`
LEFT JOIN `location`  ON `node_type`.`field_newbuild_map_lid` = `location`.`lid`
LEFT JOIN `content_field_newbuild_foto`  `photo`  ON `node`.`nid` = `photo`.`nid` AND `photo`.`delta`>=0
LEFT JOIN `files`  `photo_files`  ON `photo`.`field_newbuild_foto_fid` = `photo_files`.`fid`
WHERE `node`.`status`=1 AND `c`.`field_newbuild_place_value` IN (1111,3057) AND `node`.`nid` = '2343'
GROUP BY `node`.`nid`, `phase`.`nid`
ORDER BY `area`.`delta`, `price`.`delta`

/var/www/naydikvartiru/data/www/spb.naydikvartiru.ru/class/Data.class.php:99
/var/www/naydikvartiru/data/www/spb.naydikvartiru.ru/class/page/Object.class.php:28
/var/www/naydikvartiru/data/www/spb.naydikvartiru.ru/class/page/Data.class.php:20
/var/www/naydikvartiru/data/www/spb.naydikvartiru.ru/class/page/Data.class.php:6
/var/www/naydikvartiru/data/www/spb.naydikvartiru.ru/index.php:12