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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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
                                (
                                    [57] => 2
                                    [58] => 1
                                    [60] => 24
                                    [72] => 11
                                    [86] => 11
                                    [87] => 5
                                    [88] => 0
                                    [89] => 23
                                    [92] => 2
                                    [93] => 7
                                    [94] => 0
                                    [102] => 5
                                    [103] => 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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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
                                (
                                    [57] => 2
                                    [58] => 1
                                    [60] => 24
                                    [72] => 11
                                    [86] => 11
                                    [87] => 5
                                    [88] => 0
                                    [89] => 23
                                    [92] => 2
                                    [93] => 7
                                    [94] => 0
                                    [102] => 5
                                    [103] => 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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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
                                (
                                    [57] => 2
                                    [58] => 1
                                    [60] => 24
                                    [72] => 11
                                    [86] => 11
                                    [87] => 5
                                    [88] => 0
                                    [89] => 23
                                    [92] => 2
                                    [93] => 7
                                    [94] => 0
                                    [102] => 5
                                    [103] => 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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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
                                (
                                    [57] => 2
                                    [58] => 1
                                    [60] => 24
                                    [72] => 11
                                    [86] => 11
                                    [87] => 5
                                    [88] => 0
                                    [89] => 23
                                    [92] => 2
                                    [93] => 7
                                    [94] => 0
                                    [102] => 5
                                    [103] => 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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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
                                (
                                    [57] => 2
                                    [58] => 1
                                    [60] => 24
                                    [72] => 11
                                    [86] => 11
                                    [87] => 5
                                    [88] => 0
                                    [89] => 23
                                    [92] => 2
                                    [93] => 7
                                    [94] => 0
                                    [102] => 5
                                    [103] => 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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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
                                (
                                    [57] => 2
                                    [58] => 1
                                    [60] => 24
                                    [72] => 11
                                    [86] => 11
                                    [87] => 5
                                    [88] => 0
                                    [89] => 23
                                    [92] => 2
                                    [93] => 7
                                    [94] => 0
                                    [102] => 5
                                    [103] => 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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										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_en AS name,
										 properties.name_en AS title,
										 properties.brief_info_en AS description1,
										properties.description_en 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_en 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_en FROM bulgarienview_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
										 (SELECT municipalities.name_en 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 != '972'
										ORDER BY properties.postdate DESC, properties.id DESC
										LIMIT 6
										
                        )

                )

        )

    [callback] => 
)