SELECT `node`.`nid` AS `id`,
`node_type`.`field_short_newbuild_name_value` AS `title`,
case `p`.`field_newbuild_place_value` when 70 then 70 when 71 then 71 when 1111 then 1111 else 49 end AS `reg_id`,
`p`.`field_newbuild_place_value` AS `place_id`,
`pc`.`field_newbuild_place_value` AS `place_child_id`,
`td`.`tid` AS `place_id`,
`td`.`name` AS `place_child_title`,
MIN(`price`.`field_newbuild_price_value`)*1000/CURRENCY_RATE AS `price`,
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 */
JOIN `content_field_news_newbuild`  `story_object`  ON `node`.`nid` = `story_object`.`field_news_newbuild_nid` AND `story_object`.`nid` = 15113
LEFT JOIN `content_field_newbuild_place`  `c`  ON `node`.`nid` = `c`.`nid`
LEFT JOIN `content_field_newbuild_place`   `p`  ON `node`.`nid` = `p`.`nid` AND `p`.`delta` = `c`.`delta` - 1
LEFT JOIN `content_field_newbuild_place`  `pc`  ON `node`.`nid` = `pc`.`nid` AND `pc`.`delta` = `c`.`delta` - 2
LEFT JOIN `term_data`  `td`  ON `pc`.`field_newbuild_place_value`  = `td`.`tid`
LEFT JOIN `content_field_newbuild_price`  `price`  ON `node`.`nid` = `price`.`nid`
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` = 49 AND `node_type`.`field_prodano_value` IS NULL
GROUP BY `node`.`nid`

/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/Data.class.php:99
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/block/Story.class.php:50
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/block/Data.class.php:20
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/block/Data.class.php:10
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/Smarty.class.php:18
/var/www/naydikvartiru/data/www/naydikvartiru.ru/tplc/Newbuild_article_item^a33fa15b2c8bb950f3855c286210054ab33e1e10.file.article_item.tpl.php:854
/var/www/naydikvartiru/data/www/naydikvartiru.ru/smarty/sysplugins/smarty_internal_templatebase.php:180
/var/www/naydikvartiru/data/www/naydikvartiru.ru/smarty/sysplugins/smarty_internal_templatebase.php:374
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/Smarty.class.php:44
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/Data.class.php:21
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/Data.class.php:6
/var/www/naydikvartiru/data/www/naydikvartiru.ru/index.php:12