DB Error: syntax error
DB_Error Object
(
    [error_message_prefix] => 
    [mode] => 1
    [level] => 1024
    [code] => -2
    [message] => DB Error: syntax error
    [userinfo] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										 [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 '-14,14' at line 35]
    [backtrace] => Array
        (
            [0] => Array
                (
                    [file] => /www/bulgarienhus.ru/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 SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										 [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 '-14,14' at line 35]
                        )

                )

            [1] => Array
                (
                    [file] => /www/bulgarienhus.ru/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 SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										 [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 '-14,14' at line 35]
                        )

                )

            [2] => Array
                (
                    [file] => /www/bulgarienhus.ru/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
                                (
                                    [30] => 1
                                    [34] => 8
                                    [43] => 8
                                    [44] => 11
                                    [46] => 1
                                    [47] => 3
                                    [48] => 6
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bulgarienhus
                            [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] => 
                            [prepare_maxstmt] => 0
                            [last_query] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                            [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] => bulgarienhus
                                    [password] => dfgj24234d
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => bulgarienhus
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                            [1] => -2
                            [2] => 
                            [3] => 
                            [4] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										 [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 '-14,14' at line 35]
                            [5] => DB_Error
                            [6] => 1
                        )

                )

            [3] => Array
                (
                    [file] => /www/bulgarienhus.ru/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
                                (
                                    [30] => 1
                                    [34] => 8
                                    [43] => 8
                                    [44] => 11
                                    [46] => 1
                                    [47] => 3
                                    [48] => 6
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bulgarienhus
                            [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] => 
                            [prepare_maxstmt] => 0
                            [last_query] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                            [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] => bulgarienhus
                                    [password] => dfgj24234d
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => bulgarienhus
                                )

                        )

                    [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 '-14,14' at line 35
                        )

                )

            [4] => Array
                (
                    [file] => /www/bulgarienhus.ru/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
                                (
                                    [30] => 1
                                    [34] => 8
                                    [43] => 8
                                    [44] => 11
                                    [46] => 1
                                    [47] => 3
                                    [48] => 6
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bulgarienhus
                            [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] => 
                            [prepare_maxstmt] => 0
                            [last_query] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                            [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] => bulgarienhus
                                    [password] => dfgj24234d
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => bulgarienhus
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [5] => Array
                (
                    [file] => /www/bulgarienhus.ru/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
                                (
                                    [30] => 1
                                    [34] => 8
                                    [43] => 8
                                    [44] => 11
                                    [46] => 1
                                    [47] => 3
                                    [48] => 6
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bulgarienhus
                            [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] => 
                            [prepare_maxstmt] => 0
                            [last_query] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                            [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] => bulgarienhus
                                    [password] => dfgj24234d
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => bulgarienhus
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                        )

                )

            [6] => Array
                (
                    [file] => /www/bulgarienhus.ru/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
                                (
                                    [30] => 1
                                    [34] => 8
                                    [43] => 8
                                    [44] => 11
                                    [46] => 1
                                    [47] => 3
                                    [48] => 6
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bulgarienhus
                            [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] => 
                            [prepare_maxstmt] => 0
                            [last_query] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                            [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] => bulgarienhus
                                    [password] => dfgj24234d
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => bulgarienhus
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                        )

                )

            [7] => Array
                (
                    [file] => /www/bulgarienhus.ru/root/properties.php
                    [line] => 294
                    [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
                                (
                                    [30] => 1
                                    [34] => 8
                                    [43] => 8
                                    [44] => 11
                                    [46] => 1
                                    [47] => 3
                                    [48] => 6
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bulgarienhus
                            [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] => 
                            [prepare_maxstmt] => 0
                            [last_query] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                            [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] => bulgarienhus
                                    [password] => dfgj24234d
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => bulgarienhus
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT SQL_CALC_FOUND_ROWS properties.id,
												 properties.name_bg AS name,
												 properties.name_bg AS title,
												 properties.brief_info_bg AS description,
												 properties.price_starts_from,
												 properties.price_total,
												 properties.bedrooms,
												 properties.bathrooms,
												 properties.view_bg AS view,
												 properties.size_property,
												 properties.user_id,
												 properties.city_id,
												 (SELECT pic FROM bulgarienhus_properties_images WHERE property_id = properties.id ORDER BY pos LIMIT 1) AS pic,
												 (SELECT cities.name_bg FROM bulgarienhus_cities AS cities WHERE cities.id = properties.city_id) AS city_name,
												 (SELECT municipalities.name_bg FROM bulgarienhus_municipalities AS municipalities WHERE municipalities.id = properties.municipality_id) AS municipality_name,
												 properties.sold,
												 properties.new_property,
												 properties.complex,
												 properties.own,
												 properties.resales,
												 properties.first_line,
												 properties.exclusive,
												 properties.leasing,
												 properties.top_location,
												 properties.top_offer,
												 properties.price_from_flag,
												 properties.low_prices
										FROM bulgarienhus_properties AS properties,
											  bulgarienhus_property_to_basic_location AS properties_to_property_types
										WHERE properties.edate = 0
										AND properties_to_property_types.basic_location_id = '-6'
										AND properties_to_property_types.property_id = properties.id
										AND properties.active = 1
										ORDER BY pos
										LIMIT -14,14
										
                        )

                )

        )

    [callback] => 
)