1054: Unknown column 'nk_rent.priceid' in 'field list'
ErrCode 4. DB script error: не могу выполнить запрос к БД!
SELECT project,pfotos,nk_rent.icons as uniticons,view,comission,@id :=nk_rent.id,nk_rent.priceid,nk_rent.floor,nk_rent.type,nk_types.type_ru as stype,nk_projects.name,nk_projects.icons,nk_projects.distance,nk_projects.distance,nk_commissions.percent,nk_regions.name_ru as rname,nk_citys.name_ru as cname,nk_projects.finish_build as fb,main_img,prid,floors,bedrooms,dayprice,wekprice,monthprice,halfyearprice,yerprice,max_dayprice,max_wekprice,max_monthprice,max_halfyearprice,max_yerprice,isvip,bedrooms,bathrooms,guests,@id := nk_rent.id as id,@lat := IF(nk_rent.project = -1, nk_dotitles.coord_x,nk_projects.coord_x) as x,@lan := IF(nk_rent.project = -1, nk_dotitles.coord_y, nk_projects.coord_y) as y,"-1" as dist FROM nk_rent LEFT JOIN nk_projects ON nk_projects.id = nk_rent.project LEFT JOIN nk_dotitles ON nk_dotitles.rentid = nk_rent.id LEFT JOIN nk_dophouses ON nk_dophouses.rentid = nk_rent.id LEFT JOIN nk_types ON nk_types.id_types = nk_rent.type LEFT JOIN nk_commissions ON nk_commissions.name = "rent" LEFT JOIN nk_regions ON nk_regions.id_regions = nk_projects.region LEFT JOIN nk_citys ON nk_citys.`id_сitys` = nk_projects.city WHERE nk_rent.id = "1" AND nk_rent.on = 1 UNION SELECT project,pfotos,nk_rent.icons as uniticons,view,comission,@id :=nk_rent.id,nk_rent.priceid,nk_rent.floor,nk_rent.type,nk_types.type_ru as stype,nk_projects.name,nk_projects.icons,nk_projects.distance,nk_projects.distance,nk_commissions.percent,nk_regions.name_ru as rname,nk_citys.name_ru as cname,nk_projects.finish_build as fb,main_img,prid,floors,bedrooms,dayprice,wekprice,monthprice,halfyearprice,yerprice,max_dayprice,max_wekprice,max_monthprice,max_halfyearprice,max_yerprice,isvip,bedrooms,bathrooms,guests,nk_rent.id as id,nk_projects.coord_x as x,nk_projects.coord_y as y, ( 3959 * acos( cos( radians(@lat) ) * cos( radians( nk_projects.coord_x ) ) * cos( radians( nk_projects.coord_y ) - radians(@lan) ) + sin( radians(@lat) ) * sin( radians( nk_projects.coord_x ) ) ) ) AS distance FROM nk_rent LEFT JOIN nk_projects ON nk_projects.id = nk_rent.project LEFT JOIN nk_dotitles ON nk_dotitles.rentid = nk_rent.id LEFT JOIN nk_dophouses ON nk_dophouses.rentid = nk_rent.id LEFT JOIN nk_types ON nk_types.id_types = nk_rent.type LEFT JOIN nk_commissions ON nk_commissions.name = "rent" LEFT JOIN nk_regions ON nk_regions.id_regions = nk_projects.region LEFT JOIN nk_citys ON nk_citys.`id_сitys` = nk_projects.city WHERE nk_rent.id != @id HAVING distance < 7 UNION SELECT project,pfotos,nk_rent.icons as uniticons,view,comission,@id :=nk_rent.id,nk_rent.priceid,nk_rent.floor,nk_rent.type,nk_types.type_ru as stype,nk_projects.name,nk_projects.icons,nk_projects.distance,nk_projects.distance,nk_commissions.percent,nk_regions.name_ru as rname,nk_citys.name_ru as cname,nk_projects.finish_build as fb,main_img,prid,floors,bedrooms,dayprice,wekprice,monthprice,halfyearprice,yerprice,max_dayprice,max_wekprice,max_monthprice,max_halfyearprice,max_yerprice,isvip,bedrooms,bathrooms,guests,nk_rent.id as id,nk_dotitles.coord_x as x,nk_dotitles.coord_y as y, ( 3959 * acos( cos( radians(@lat) ) * cos( radians( nk_dotitles.coord_x ) ) * cos( radians( nk_dotitles.coord_y ) - radians(@lan) ) + sin( radians(@lat) ) * sin( radians( nk_dotitles.coord_x ) ) ) ) AS distance FROM nk_rent LEFT JOIN nk_projects ON nk_projects.id = nk_rent.project LEFT JOIN nk_dotitles ON nk_dotitles.rentid = nk_rent.id LEFT JOIN nk_dophouses ON nk_dophouses.rentid = nk_rent.id LEFT JOIN nk_types ON nk_types.id_types = nk_rent.type LEFT JOIN nk_commissions ON nk_commissions.name = "rent" LEFT JOIN nk_regions ON nk_regions.id_regions = nk_projects.region LEFT JOIN nk_citys ON nk_citys.`id_сitys` = nk_projects.city WHERE nk_rent.id != @id HAVING distance < 7 ORDER BY dist

Warning: Invalid argument supplied for foreach() in /home/user3945/myth/www/mythai-home/www/LIBRARY/functions.inc on line 1226

Warning: Cannot modify header information - headers already sent by (output started at /home/user3945/myth/www/mythai-home/www/LIBRARY/db.inc:51) in /home/user3945/myth/www/mythai-home/www/LIBRARY/realty/nk_realty.mod on line 1020
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `month_num`,`period` ASC' at line 1
ErrCode 4. DB script error: не могу выполнить запрос к БД!
SELECT * FROM `nk_doprices` WHERE `rent_id` = ORDER BY `month_num`,`period` ASC
Арендовать в Паттайе сдаётся снять в в Таиланде