Unknown column 'CURRENCY_RATE' in 'field list'
SELECT SQL_CALC_FOUND_ROWS `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`,
GROUP_CONCAT(DISTINCT `adress`.`name` ORDER BY `adress_data`.`delta` DESC SEPARATOR ', ') AS `adress`,
`nr`.`teaser` AS `teaser`,
GROUP_CONCAT(DISTINCT CONCAT(`metro_title`.`tid`,'-',`metro_title`.`name`) ORDER BY `metro`.`delta` SEPARATOR ',') as `metro`,
`build_type`.`name` AS `build_type`,
GROUP_CONCAT(DISTINCT `remont`.`field_newbuild_remont_value` ORDER BY `remont`.`field_newbuild_remont_value` SEPARATOR ',') AS `remont`
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_newbuild_place` `region_filter` ON `node`.`nid` = `region_filter`.`nid` AND `region_filter`.`field_newbuild_place_value` = 6128
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`
LEFT JOIN `content_field_newbuild_place` `adress_data` ON `node_type`.`nid` = `adress_data`.`nid`
JOIN `term_data` `adress` ON `adress_data`.`field_newbuild_place_value` = `adress`.`tid`
LEFT JOIN `node_revisions` `nr` ON `node`.`nid` = `nr`.`nid`
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` = 40
)
LEFT JOIN `term_data` `metro_title` ON `metro`.`field_newbuild_metro_value` = `metro_title`.`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`
WHERE `node`.`status`=1 AND `node_type`.`field_newbuild_class_value` IN (1) AND `c`.`field_newbuild_place_value` = 49 AND `node_type`.`field_prodano_value` IS NULL
GROUP BY `node`.`nid`
ORDER BY `prcheck`.`field_priority_check_value` DESC, `node`.`changed` DESC /* 11 class/data/newbuild.class приоритизация вывода. убираем из списков проданные */
LIMIT 0, 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/Newbuild.class.php:98
/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