DB Error: no such fieldDB_Error Object
(
    [error_message_prefix] => 
    [mode] => 16
    [level] => 1024
    [code] => -19
    [message] => DB Error: no such field
    [userinfo] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8 [nativecode=1054 ** Unknown column 'R.url' in 'field list']
    [backtrace] => Array
        (
            [0] => Array
                (
                    [file] => /home/web/lechao/test/libs/Pear/DB.php
                    [line] => 749
                    [function] => PEAR_Error
                    [class] => PEAR_Error
                    [type] => ->
                    [object] => DB_Error Object
 *RECURSION*
                    [args] => Array
                        (
                            [0] => DB Error: no such field
                            [1] => -19
                            [2] => 16
                            [3] => errhndl
                            [4] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8 [nativecode=1054 ** Unknown column 'R.url' in 'field list']
                        )

                )

            [1] => Array
                (
                    [file] => /home/web/lechao/test/libs/Pear/PEAR.php
                    [line] => 539
                    [function] => DB_Error
                    [class] => DB_Error
                    [type] => ->
                    [object] => DB_Error Object
 *RECURSION*
                    [args] => Array
                        (
                            [0] => -19
                            [1] => 16
                            [2] => errhndl
                            [3] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8 [nativecode=1054 ** Unknown column 'R.url' in 'field list']
                        )

                )

            [2] => Array
                (
                    [file] => /home/web/lechao/test/libs/Pear/DB/common.php
                    [line] => 506
                    [function] => raiseError
                    [class] => PEAR
                    [type] => ->
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #12
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM 
                                            [1] =>  as O, 
                                            [2] =>  as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=
                                            [3] =>   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                        )

                                )

                            [prepare_types] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => 3
                                            [1] => 3
                                            [2] => 1
                                        )

                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => lechaov2
                            [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
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1048] => -3
                                    [1216] => -3
                                )

                            [prepared_queries] => Array
                                (
                                    [1] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM   as O,   as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                )

                            [prepare_maxstmt] => 0
                            [last_query] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => true
                                    [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] => lechaov2
                                    [password] => lksiLIU342l*lsk
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => lechaov2
                                )

                        )

                    [args] => Array
                        (
                            [0] => 
                            [1] => -19
                            [2] => 
                            [3] => 
                            [4] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8 [nativecode=1054 ** Unknown column 'R.url' in 'field list']
                            [5] => DB_Error
                            [6] => 1
                        )

                )

            [3] => Array
                (
                    [file] => /home/web/lechao/test/libs/Pear/DB/mysql.php
                    [line] => 779
                    [function] => raiseError
                    [class] => DB_common
                    [type] => ->
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #12
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM 
                                            [1] =>  as O, 
                                            [2] =>  as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=
                                            [3] =>   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                        )

                                )

                            [prepare_types] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => 3
                                            [1] => 3
                                            [2] => 1
                                        )

                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => lechaov2
                            [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
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1048] => -3
                                    [1216] => -3
                                )

                            [prepared_queries] => Array
                                (
                                    [1] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM   as O,   as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                )

                            [prepare_maxstmt] => 0
                            [last_query] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => true
                                    [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] => lechaov2
                                    [password] => lksiLIU342l*lsk
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => lechaov2
                                )

                        )

                    [args] => Array
                        (
                            [0] => -19
                            [1] => 
                            [2] => 
                            [3] => 
                            [4] => 1054 ** Unknown column 'R.url' in 'field list'
                        )

                )

            [4] => Array
                (
                    [file] => /home/web/lechao/test/libs/Pear/DB/mysql.php
                    [line] => 230
                    [function] => mysqlRaiseError
                    [class] => DB_mysql
                    [type] => ->
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #12
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM 
                                            [1] =>  as O, 
                                            [2] =>  as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=
                                            [3] =>   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                        )

                                )

                            [prepare_types] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => 3
                                            [1] => 3
                                            [2] => 1
                                        )

                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => lechaov2
                            [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
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1048] => -3
                                    [1216] => -3
                                )

                            [prepared_queries] => Array
                                (
                                    [1] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM   as O,   as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                )

                            [prepare_maxstmt] => 0
                            [last_query] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => true
                                    [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] => lechaov2
                                    [password] => lksiLIU342l*lsk
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => lechaov2
                                )

                        )

                    [args] => Array
                        (
                        )

                )

            [5] => Array
                (
                    [file] => /home/web/lechao/test/libs/Pear/DB/common.php
                    [line] => 959
                    [function] => simpleQuery
                    [class] => DB_mysql
                    [type] => ->
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #12
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM 
                                            [1] =>  as O, 
                                            [2] =>  as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=
                                            [3] =>   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                        )

                                )

                            [prepare_types] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => 3
                                            [1] => 3
                                            [2] => 1
                                        )

                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => lechaov2
                            [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
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1048] => -3
                                    [1216] => -3
                                )

                            [prepared_queries] => Array
                                (
                                    [1] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM   as O,   as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                )

                            [prepare_maxstmt] => 0
                            [last_query] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => true
                                    [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] => lechaov2
                                    [password] => lksiLIU342l*lsk
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => lechaov2
                                )

                        )

                    [args] => Array
                        (
                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                        )

                )

            [6] => Array
                (
                    [file] => /home/web/lechao/test/libs/Pear/DB/common.php
                    [line] => 1586
                    [function] => execute
                    [class] => DB_common
                    [type] => ->
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #12
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM 
                                            [1] =>  as O, 
                                            [2] =>  as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=
                                            [3] =>   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                        )

                                )

                            [prepare_types] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => 3
                                            [1] => 3
                                            [2] => 1
                                        )

                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => lechaov2
                            [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
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1048] => -3
                                    [1216] => -3
                                )

                            [prepared_queries] => Array
                                (
                                    [1] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM   as O,   as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                )

                            [prepare_maxstmt] => 0
                            [last_query] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => true
                                    [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] => lechaov2
                                    [password] => lksiLIU342l*lsk
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => lechaov2
                                )

                        )

                    [args] => Array
                        (
                            [0] => 1
                            [1] => Array
                                (
                                    [0] => lc_owner
                                    [1] => lc_njlhouse
                                    [2] => courtyard
                                )

                        )

                )

            [7] => Array
                (
                    [file] => /home/web/lechao/test/search.php
                    [line] => 217
                    [function] => getAll
                    [class] => DB_common
                    [type] => ->
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #12
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM 
                                            [1] =>  as O, 
                                            [2] =>  as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=
                                            [3] =>   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                        )

                                )

                            [prepare_types] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => 3
                                            [1] => 3
                                            [2] => 1
                                        )

                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => lechaov2
                            [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
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1048] => -3
                                    [1216] => -3
                                )

                            [prepared_queries] => Array
                                (
                                    [1] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM   as O,   as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=   ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                                )

                            [prepare_maxstmt] => 0
                            [last_query] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM lc_owner as O, lc_njlhouse as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype='courtyard'  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => true
                                    [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] => lechaov2
                                    [password] => lksiLIU342l*lsk
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => lechaov2
                                )

                        )

                    [args] => Array
                        (
                            [0] => SELECT O.province,O.city, O.accountid, O.star, O.b5_shopname as shopname,O.b5_intro as intro,O.lng,O.lat,O.zoom,O.video,O.b5_address as address
	    ,R.b5_description as description, R.url, R.id,R.stdprice,R.price,R.b5_roomname as roomname,R.acreage,R.number,R.picname,R.bookable FROM ! as O, ! as R WHERE O.status=1 and province='ningxia' and city='wuzhong' AND O.accountid=R.accountid AND O.shoptype=?  ORDER BY video DESC, stdprice  desc LIMIT 0 ,8
                            [1] => Array
                                (
                                    [0] => lc_owner
                                    [1] => lc_njlhouse
                                    [2] => courtyard
                                )

                        )

                )

        )

    [callback] => errhndl
)