DB Error: no such field
DB_Error Object
(
    [error_message_prefix] => 
    [mode] => 1
    [level] => 1024
    [code] => -19
    [message] => DB Error: no such field
    [userinfo] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10 [nativecode=1054 ** Unknown column 'object.price_' in 'where clause']
    [backtrace] => Array
        (
            [0] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/pear/DB.php
                    [line] => 739
                    [function] => PEAR_Error
                    [class] => PEAR_Error
                    [object] => DB_Error Object
 *RECURSION*
                    [type] => ->
                    [args] => Array
                        (
                            [0] => DB Error: no such field
                            [1] => -19
                            [2] => 1
                            [3] => 1024
                            [4] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10 [nativecode=1054 ** Unknown column 'object.price_' in 'where clause']
                        )

                )

            [1] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/pear/PEAR.php
                    [line] => 523
                    [function] => DB_Error
                    [class] => DB_Error
                    [object] => DB_Error Object
 *RECURSION*
                    [type] => ->
                    [args] => Array
                        (
                            [0] => -19
                            [1] => 1
                            [2] => 1024
                            [3] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10 [nativecode=1054 ** Unknown column 'object.price_' in 'where clause']
                        )

                )

            [2] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/pear/DB/common.php
                    [line] => 495
                    [function] => raiseError
                    [class] => PEAR
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #15
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                    [27] => 13
                                    [28] => 3
                                    [32] => 7
                                    [33] => 9
                                    [34] => 31
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bargainsbulgaria
                            [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  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                            [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] => bargainsbulgaria
                                    [password] => jhk34wew3
                                    [protocol] => tcp
                                    [hostspec] => 127.0.0.1
                                    [port] => 
                                    [socket] => 
                                    [database] => bargainsbulgaria
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                            [1] => -19
                            [2] => 
                            [3] => 
                            [4] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10 [nativecode=1054 ** Unknown column 'object.price_' in 'where clause']
                            [5] => DB_Error
                            [6] => 1
                        )

                )

            [3] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/pear/DB/mysql.php
                    [line] => 776
                    [function] => raiseError
                    [class] => DB_common
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #15
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                    [27] => 13
                                    [28] => 3
                                    [32] => 7
                                    [33] => 9
                                    [34] => 31
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bargainsbulgaria
                            [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  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                            [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] => bargainsbulgaria
                                    [password] => jhk34wew3
                                    [protocol] => tcp
                                    [hostspec] => 127.0.0.1
                                    [port] => 
                                    [socket] => 
                                    [database] => bargainsbulgaria
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => -19
                            [1] => 
                            [2] => 
                            [3] => 
                            [4] => 1054 ** Unknown column 'object.price_' in 'where clause'
                        )

                )

            [4] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/pear/DB/mysql.php
                    [line] => 228
                    [function] => mysqlRaiseError
                    [class] => DB_mysql
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #15
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                    [27] => 13
                                    [28] => 3
                                    [32] => 7
                                    [33] => 9
                                    [34] => 31
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bargainsbulgaria
                            [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  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                            [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] => bargainsbulgaria
                                    [password] => jhk34wew3
                                    [protocol] => tcp
                                    [hostspec] => 127.0.0.1
                                    [port] => 
                                    [socket] => 
                                    [database] => bargainsbulgaria
                                )

                        )

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

                )

            [5] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/pear/DB/common.php
                    [line] => 1135
                    [function] => simpleQuery
                    [class] => DB_mysql
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #15
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                    [27] => 13
                                    [28] => 3
                                    [32] => 7
                                    [33] => 9
                                    [34] => 31
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bargainsbulgaria
                            [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  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                            [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] => bargainsbulgaria
                                    [password] => jhk34wew3
                                    [protocol] => tcp
                                    [hostspec] => 127.0.0.1
                                    [port] => 
                                    [socket] => 
                                    [database] => bargainsbulgaria
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                        )

                )

            [6] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/pear/DB/common.php
                    [line] => 1572
                    [function] => query
                    [class] => DB_common
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #15
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                    [27] => 13
                                    [28] => 3
                                    [32] => 7
                                    [33] => 9
                                    [34] => 31
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bargainsbulgaria
                            [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  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                            [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] => bargainsbulgaria
                                    [password] => jhk34wew3
                                    [protocol] => tcp
                                    [hostspec] => 127.0.0.1
                                    [port] => 
                                    [socket] => 
                                    [database] => bargainsbulgaria
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                        )

                )

            [7] => Array
                (
                    [file] => /www/bargainsbulgaria.co.uk/root/offers.php
                    [line] => 311
                    [function] => getAll
                    [class] => DB_common
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #15
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                    [27] => 13
                                    [28] => 3
                                    [32] => 7
                                    [33] => 9
                                    [34] => 31
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => bargainsbulgaria
                            [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  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                            [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] => bargainsbulgaria
                                    [password] => jhk34wew3
                                    [protocol] => tcp
                                    [hostspec] => 127.0.0.1
                                    [port] => 
                                    [socket] => 
                                    [database] => bargainsbulgaria
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT  object.id AS object_id,
					object.additional_info_en AS additional_info,
					object.brief_description_en AS brief_description,
					object.view_en AS view,
					object.price_is_from, 
					object.post_date ,
					object.size,
					object.yard,
					object.ref_no, 
					(SELECT rea_object_pics.pic_file from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic,
					(SELECT rea_object_pics.pic_link from rea_object_pics WHERE pos_id=0 and rea_object_pics.obj_id = object.id LIMIT 1) as pic_link,
					object.price_eur, 
					object.price_usd, 
					object.price_gbr, 
					object.price_bgn,
					object.offer_type, 
					object.is_new, 
					object.is_top,
					status.name_en AS status, 
					city.name_en as city_name,city.id as ct_id,
					pt.name_en as pt_name, pt.id as pt_id, bl.name_en as bl_name,
					ct.name_en AS ct_name,region.id AS region_id,
					district_centres.name_en AS district_centre,
					districts.name_en as dist_name,
					object.metric_yard,object.metric_size,
					object.metric_built_area, object.built_area,
					(select districts.name_en from districts where districts.id = city.distr_id) as district
			FROM rea_object AS object 
				LEFT JOIN rea_city AS city ON object.city_id = city.id
				LEFT JOIN ct_bl_links ON ct_bl_links.city_id = city.id 
				LEFT JOIN rea_basic_location AS bl ON ct_bl_links.basic_location_id = bl.id
				LEFT JOIN rea_city_type AS ct ON  city.city_type_id = ct.id
				LEFT JOIN rea_property_type AS pt ON  object.property_type_id = pt.id
				LEFT JOIN rea_status AS status ON  object.status_id = status.id
				LEFT JOIN rea_regions AS region  ON city.region_id = region.id
				LEFT JOIN district_centres  ON city.district_centre_id = district_centres.id
				LEFT JOIN rea_object_pics ON object.id = rea_object_pics.obj_id
				LEFT JOIN districts ON object.distr_id = districts.id
			WHERE  object.edate < 1 AND object.is_active < 1  
				       
				    AND object.price_ <= '09224'  AND object.offer_type < '3'   AND '40' in (SELECT ct_bl_links.basic_location_id FROM ct_bl_links WHERE ct_bl_links.city_id = city.id)    
			GROUP BY object.id
			ORDER BY object.id DESC
		 LIMIT 70, 10
                        )

                )

        )

    [callback] => 
)