DB Error: syntax error
DB_Error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -2
[message] => DB Error: syntax error
[userinfo] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[nativecode=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 '' at line 58]
[backtrace] => Array
(
[0] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/pear/DB.php
[line] => 739
[function] => PEAR_Error
[class] => PEAR_Error
[object] => DB_Error Object
*RECURSION*
[type] => ->
[args] => Array
(
[0] => DB Error: syntax error
[1] => -2
[2] => 1
[3] => 1024
[4] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[nativecode=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 '' at line 58]
)
)
[1] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/pear/PEAR.php
[line] => 523
[function] => DB_Error
[class] => DB_Error
[object] => DB_Error Object
*RECURSION*
[type] => ->
[args] => Array
(
[0] => -2
[1] => 1
[2] => 1024
[3] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[nativecode=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 '' at line 58]
)
)
[2] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/pear/DB/common.php
[line] => 495
[function] => raiseError
[class] => PEAR
[object] => DB_mysql Object
(
[connection] => Resource id #17
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[60] => 4
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[features] => Array
(
[prepare] =>
[pconnect] => 1
[transactions] => 1
[limit] => alter
)
[errorcode_map] => Array
(
[1004] => -15
[1005] => -15
[1006] => -15
[1007] => -5
[1008] => -17
[1022] => -5
[1046] => -14
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1048] => -3
[1216] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[dbh] =>
[_debug] =>
[_default_error_mode] =>
[_default_error_options] =>
[_default_error_handler] =>
[_error_class] => DB_Error
[_expected_errors] => Array
(
)
[dsn] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] =>
[1] => -2
[2] =>
[3] =>
[4] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[nativecode=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 '' at line 58]
[5] => DB_Error
[6] => 1
)
)
[3] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/pear/DB/mysql.php
[line] => 770
[function] => raiseError
[class] => DB_common
[object] => DB_mysql Object
(
[connection] => Resource id #17
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[60] => 4
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[features] => Array
(
[prepare] =>
[pconnect] => 1
[transactions] => 1
[limit] => alter
)
[errorcode_map] => Array
(
[1004] => -15
[1005] => -15
[1006] => -15
[1007] => -5
[1008] => -17
[1022] => -5
[1046] => -14
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1048] => -3
[1216] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[dbh] =>
[_debug] =>
[_default_error_mode] =>
[_default_error_options] =>
[_default_error_handler] =>
[_error_class] => DB_Error
[_expected_errors] => Array
(
)
[dsn] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => -2
[1] =>
[2] =>
[3] =>
[4] => 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 '' at line 58
)
)
[4] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/pear/DB/mysql.php
[line] => 233
[function] => mysqlRaiseError
[class] => DB_mysql
[object] => DB_mysql Object
(
[connection] => Resource id #17
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[60] => 4
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[features] => Array
(
[prepare] =>
[pconnect] => 1
[transactions] => 1
[limit] => alter
)
[errorcode_map] => Array
(
[1004] => -15
[1005] => -15
[1006] => -15
[1007] => -5
[1008] => -17
[1022] => -5
[1046] => -14
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1048] => -3
[1216] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[dbh] =>
[_debug] =>
[_default_error_mode] =>
[_default_error_options] =>
[_default_error_handler] =>
[_error_class] => DB_Error
[_expected_errors] => Array
(
)
[dsn] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/pear/DB/common.php
[line] => 1135
[function] => simpleQuery
[class] => DB_mysql
[object] => DB_mysql Object
(
[connection] => Resource id #17
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[60] => 4
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[features] => Array
(
[prepare] =>
[pconnect] => 1
[transactions] => 1
[limit] => alter
)
[errorcode_map] => Array
(
[1004] => -15
[1005] => -15
[1006] => -15
[1007] => -5
[1008] => -17
[1022] => -5
[1046] => -14
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1048] => -3
[1216] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[dbh] =>
[_debug] =>
[_default_error_mode] =>
[_default_error_options] =>
[_default_error_handler] =>
[_error_class] => DB_Error
[_expected_errors] => Array
(
)
[dsn] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
)
)
[6] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/pear/DB/common.php
[line] => 1271
[function] => query
[class] => DB_common
[object] => DB_mysql Object
(
[connection] => Resource id #17
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[60] => 4
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[features] => Array
(
[prepare] =>
[pconnect] => 1
[transactions] => 1
[limit] => alter
)
[errorcode_map] => Array
(
[1004] => -15
[1005] => -15
[1006] => -15
[1007] => -5
[1008] => -17
[1022] => -5
[1046] => -14
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1048] => -3
[1216] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[dbh] =>
[_debug] =>
[_default_error_mode] =>
[_default_error_options] =>
[_default_error_handler] =>
[_error_class] => DB_Error
[_expected_errors] => Array
(
)
[dsn] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
)
)
[7] => Array
(
[file] => /www.storage/property-elhovo.com/root.bourgas.property-elhovo.com/prop_det.php
[line] => 86
[function] => getRow
[class] => DB_common
[object] => DB_mysql Object
(
[connection] => Resource id #17
[phptype] => mysql
[dbsyntax] => mysql
[prepare_tokens] => Array
(
)
[prepare_types] => Array
(
)
[num_rows] => Array
(
[60] => 4
)
[transaction_opcount] => 0
[autocommit] => 1
[fetchmode] => 2
[_db] => bulgarianestates
[features] => Array
(
[prepare] =>
[pconnect] => 1
[transactions] => 1
[limit] => alter
)
[errorcode_map] => Array
(
[1004] => -15
[1005] => -15
[1006] => -15
[1007] => -5
[1008] => -17
[1022] => -5
[1046] => -14
[1050] => -5
[1051] => -18
[1054] => -19
[1062] => -5
[1064] => -2
[1100] => -21
[1136] => -22
[1146] => -18
[1048] => -3
[1216] => -3
)
[prepared_queries] =>
[prepare_maxstmt] => 0
[last_query] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
[fetchmode_object_class] => stdClass
[options] => Array
(
[persistent] =>
[ssl] =>
[debug] => 0
[seqname_format] => %s_seq
[autofree] =>
[portability] => 0
[optimize] => performance
)
[dbh] =>
[_debug] =>
[_default_error_mode] =>
[_default_error_options] =>
[_default_error_handler] =>
[_error_class] => DB_Error
[_expected_errors] => Array
(
)
[dsn] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => bulgarianestates
[password] => klsjd445
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] =>
[socket] =>
[database] => bulgarianestates
)
)
[type] => ->
[args] => Array
(
[0] => SELECT object.id AS object_id,
object.brief_description_en AS est_brief_desc,
object.additional_info_en AS est_desc,
object.post_date AS est_publish_date,
object.file AS file,
object.lay_out_en AS lay_out,
object.rooms_1_floor_en AS rooms_1_floor,
object.rooms_2_floor_en AS rooms_2_floor,
object.rooms_3_floor_en AS rooms_3_floor,
object.rooms_4_floor_en AS rooms_4_floor,
object.road_street_en AS road_street,
object.subsidiary_buildings_en AS subsidiary_buildings,
object.view_en AS view,
object.bedrooms AS bedrooms,
object.bathrooms AS bathrooms,
object.water AS water,
object.electricity AS electricity,
object.floor AS floor,
object.yard AS est_yard,
object.size AS est_area,
object.built_area,
object.metric_yard,
object.metric_size,
object.metric_built_area,
object.price_is_from,
object.ref_no AS est_refnum,
object.offer_type AS offer_type,
object.price_eur AS est_price,object.price_gbr,object.price_usd,
object.price_km AS price_km,
city.name_en AS c_name,
ct.name_en AS ct_name,
bl.name_en AS basic_loc,
bl.id AS loc_id,
status.name_en AS at_name,
pt.name_en AS et_name,
pt.name_en AS type_name,
pt.id AS et_id,
region.map,
region.id AS region_id,
district_centres.name_en AS district_centre,
object.city_id as c_id,
(select countries.name_en from countries where countries.id = object.count_id) as country,
(select districts.name_en from districts where districts.id = object.distr_id) as district,
(select roads.name_en from roads where roads.id = object.road_id) as road,
object.cond_en as `condition`,
object.furn_en as furniture, offer_type
FROM
rea_object as object
LEFT JOIN rea_status as status on object.status_id = status.id
LEFT JOIN rea_city AS city ON object.city_id = city.id
LEFT JOIN rea_basic_location AS bl ON city.basic_location_id = bl.id
LEFT JOIN rea_city_type AS ct ON city.city_type_id = ct.id
LEFT JOIN rea_property_type AS pt ON object.property_type_id = pt.id
LEFT JOIN rea_regions AS region ON city.region_id = region.id
LEFT JOIN district_centres ON city.district_centre_id = district_centres.id
WHERE object.edate < 1
AND object.id =
)
)
)
[callback] =>
)