DB Error: syntax error
DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -2 [message] => DB Error: syntax error [userinfo] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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 ') /*AND properties.region_id = ''*/ AND properties.price_tot' at line 45] [backtrace] => Array ( [0] => Array ( [file] => /www/bulgarienview.com/root/pear/DB.php [line] => 748 [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 DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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 ') /*AND properties.region_id = ''*/ AND properties.price_tot' at line 45] ) ) [1] => Array ( [file] => /www/bulgarienview.com/root/pear/PEAR.php [line] => 541 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -2 [1] => 1 [2] => 1024 [3] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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 ') /*AND properties.region_id = ''*/ AND properties.price_tot' at line 45] ) ) [2] => Array ( [file] => /www/bulgarienview.com/root/pear/DB/common.php [line] => 495 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #14 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( [55] => 2 [56] => 1 [58] => 24 [70] => 11 [84] => 11 [85] => 5 [86] => 0 [87] => 23 [90] => 2 [91] => 7 [92] => 0 [100] => 5 [101] => 5 ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => bulgarienview [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 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => Array ( ) [prepare_maxstmt] => 0 [last_query] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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] => bulgarienview [password] => sdfjhj32k4 [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => bulgarienview ) ) [type] => -> [args] => Array ( [0] => [1] => -2 [2] => [3] => [4] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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 ') /*AND properties.region_id = ''*/ AND properties.price_tot' at line 45] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /www/bulgarienview.com/root/pear/DB/mysql.php [line] => 776 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #14 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( [55] => 2 [56] => 1 [58] => 24 [70] => 11 [84] => 11 [85] => 5 [86] => 0 [87] => 23 [90] => 2 [91] => 7 [92] => 0 [100] => 5 [101] => 5 ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => bulgarienview [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 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => Array ( ) [prepare_maxstmt] => 0 [last_query] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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] => bulgarienview [password] => sdfjhj32k4 [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => bulgarienview ) ) [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 ') /*AND properties.region_id = ''*/ AND properties.price_tot' at line 45 ) ) [4] => Array ( [file] => /www/bulgarienview.com/root/pear/DB/mysql.php [line] => 228 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #14 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( [55] => 2 [56] => 1 [58] => 24 [70] => 11 [84] => 11 [85] => 5 [86] => 0 [87] => 23 [90] => 2 [91] => 7 [92] => 0 [100] => 5 [101] => 5 ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => bulgarienview [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 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => Array ( ) [prepare_maxstmt] => 0 [last_query] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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] => bulgarienview [password] => sdfjhj32k4 [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => bulgarienview ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /www/bulgarienview.com/root/pear/DB/common.php [line] => 1135 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #14 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( [55] => 2 [56] => 1 [58] => 24 [70] => 11 [84] => 11 [85] => 5 [86] => 0 [87] => 23 [90] => 2 [91] => 7 [92] => 0 [100] => 5 [101] => 5 ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => bulgarienview [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 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => Array ( ) [prepare_maxstmt] => 0 [last_query] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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] => bulgarienview [password] => sdfjhj32k4 [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => bulgarienview ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 ) ) [6] => Array ( [file] => /www/bulgarienview.com/root/pear/DB/common.php [line] => 1572 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #14 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( [55] => 2 [56] => 1 [58] => 24 [70] => 11 [84] => 11 [85] => 5 [86] => 0 [87] => 23 [90] => 2 [91] => 7 [92] => 0 [100] => 5 [101] => 5 ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => bulgarienview [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 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => Array ( ) [prepare_maxstmt] => 0 [last_query] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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] => bulgarienview [password] => sdfjhj32k4 [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => bulgarienview ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 ) ) [7] => Array ( [file] => /www/bulgarienview.com/root/show_property.php [line] => 328 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #14 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( [55] => 2 [56] => 1 [58] => 24 [70] => 11 [84] => 11 [85] => 5 [86] => 0 [87] => 23 [90] => 2 [91] => 7 [92] => 0 [100] => 5 [101] => 5 ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 2 [_db] => bulgarienview [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 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => Array ( ) [prepare_maxstmt] => 0 [last_query] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 [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] => bulgarienview [password] => sdfjhj32k4 [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => bulgarienview ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT properties.id, properties.name_dk AS name, properties.name_dk AS title, properties.brief_info_dk AS description1, properties.description_dk AS description, properties.price_starts_from, properties.price_from_flag, properties.ref_no, properties.price_total, properties.min_price, properties.meters_to_beach, properties.price_discount, properties.max_price, properties.bedrooms, properties.bathrooms, properties.seen, properties.city_id, properties.view_dk AS view, properties.size_property, properties.user_id, (SELECT pic FROM bulgarienview_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic, (SELECT cities.name_dk FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name, (SELECT municipalities.name_dk FROM bulgarienview_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name, properties.sold, properties.new_property, properties.complex, properties.size_from, properties.size_to, properties.own, properties.resales, properties.first_line, properties.second_line, properties.third_line, properties.better, properties.lux, properties.exclusive, properties.leasing, properties.top_location, properties.top_offer, properties.low_prices, properties.new_offer FROM bulgarienview_properties AS properties ,bulgarienview_property_to_property_type AS ptpt WHERE properties.edate = 0 AND ptpt.property_id = properties.id AND ( ) /*AND properties.region_id = ''*/ AND properties.price_total > 0 AND properties.price_total < 0 AND properties.active = 1 AND properties.id != '1009' ORDER BY properties.postdate DESC, properties.id DESC LIMIT 6 ) ) ) [callback] => )