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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 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 pt.id = '35' AND object.price_ <= '24' AND object.offer_type < '3' GROUP BY object.id ORDER BY object.id DESC LIMIT 50, 10 ) ) ) [callback] => )