SELECT SQL_CALC_FOUND_ROWS `node`.`nid` AS `id`,
`node_type`.`field_short_house_name_value` AS `title`,
`shosse`.`tid` AS `shosse_id`,
`shosse`.`name` AS `shosse_title`,
`price`.`field_house_price_n_value`/CURRENCY_RATE AS `price`,
replace(`photo_files`.`filepath`, 'sites/default/files/', '') AS `photo`,
`nr`.`teaser` AS `teaser`,
GROUP_CONCAT(DISTINCT `adress_name`.`name` ORDER BY `adress_id`.`delta` DESC SEPARATOR ', ') AS `adress`
FROM `node`
JOIN `content_type_house`  `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 (SELECT `nid`, case `field_house_type_value` when 'коттедж' then 1 when 'участок с подрядом' then 1 when 'участок без подряда' then 2 when 'таунхаус' then 3 end as `value` FROM `content_field_house_type`)  `type`  ON `node`.`nid` = `type`.`nid` AND `type`.`value` = 1
LEFT JOIN (SELECT `nid`, `tid`, `name` FROM `content_field_house_shosse` JOIN `term_data` ON `field_house_shosse_value`=`tid`)  `shosse`  ON `node`.`nid` = `shosse`.`nid`
LEFT JOIN `content_field_house_price_n`  `price`  ON `node`.`nid` = `price`.`nid`
LEFT JOIN `content_field_house_images`  `photo`  ON `node`.`nid` = `photo`.`nid` AND `photo`.`delta`>=0
LEFT JOIN `files`  `photo_files`  ON `photo`.`field_house_images_fid` = `photo_files`.`fid`
LEFT JOIN `node_revisions`  `nr`  ON `node`.`nid` = `nr`.`nid`
LEFT JOIN `content_field_house_adress`  `adress_id`  ON `node_type`.`nid` = `adress_id`.`nid`
LEFT JOIN `term_data`  `adress_name`  ON `adress_id`.`field_house_adress_value` = `adress_name`.`tid`
WHERE `node`.`status`=1 AND `node_type`.`field_prodanoh_value` IS NULL
GROUP BY `node`.`nid`
ORDER BY `node`.`changed` DESC, `node`.`nid` DESC
LIMIT 130, 10

/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/Data.class.php:99
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/Object.class.php:46
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/House.class.php:50
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/Data.class.php:20
/var/www/naydikvartiru/data/www/naydikvartiru.ru/class/page/Data.class.php:6
/var/www/naydikvartiru/data/www/naydikvartiru.ru/index.php:12