after call data
JO_Db_Select Object
(
    [_bind:protected] => Array
        (
        )

    [_adapter:protected] => JO_Db_Adapter_Pdo_Mysql Object
        (
            [_pdoType:protected] => mysql
            [_numericDataTypes:protected] => Array
                (
                    [0] => 0
                    [1] => 1
                    [2] => 2
                    [INT] => 0
                    [INTEGER] => 0
                    [MEDIUMINT] => 0
                    [SMALLINT] => 0
                    [TINYINT] => 0
                    [BIGINT] => 1
                    [SERIAL] => 1
                    [DEC] => 2
                    [DECIMAL] => 2
                    [DOUBLE] => 2
                    [DOUBLE PRECISION] => 2
                    [FIXED] => 2
                    [FLOAT] => 2
                )

            [_defaultStmtClass:protected] => JO_Db_Statement_Pdo
            [_config:protected] => Array
                (
                    [host] => localhost
                    [username] => pgrabber_root
                    [password] => root%123
                    [dbname] => pgrabber_demo2
                    [charset] => utf8
                    [persistent] => 
                    [options] => Array
                        (
                            [caseFolding] => 0
                            [autoQuoteIdentifiers] => 1
                        )

                    [driver_options] => Array
                        (
                            [1002] => SET NAMES 'utf8'
                        )

                )

            [_fetchMode:protected] => 2
            [_profiler:protected] => JO_Db_Profiler Object
                (
                    [_queryProfiles:protected] => Array
                        (
                        )

                    [_enabled:protected] => 
                    [_filterElapsedSecs:protected] => 
                    [_filterTypes:protected] => 
                )

            [_defaultProfilerClass:protected] => JO_Db_Profiler
            [_connection:protected] => PDO Object
                (
                )

            [_caseFolding:protected] => 0
            [_autoQuoteIdentifiers:protected] => 1
            [_allowSerialization:protected] => 1
            [_autoReconnectOnUnserialize:protected] => 
        )

    [_parts:protected] => Array
        (
            [distinct] => 
            [columns] => Array
                (
                    [0] => Array
                        (
                            [0] => item
                            [1] => *
                            [2] => 
                        )

                    [1] => Array
                        (
                            [0] => row
                            [1] => *
                            [2] => 
                        )

                    [2] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => @curRow := @curRow + 1
                                )

                            [2] => sql_row
                        )

                    [3] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => @item_picture_id:=(SELECT picture FROM item_picture WHERE item = item.id ORDER BY sort_order LIMIT 1)
                                )

                            [2] => 
                        )

                    [4] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => @item_picture_id
                                )

                            [2] => picture_id
                        )

                    [5] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `shops`.`currency` FROM `shops` WHERE (shop_id = item.shop_id) LIMIT 1)
                                )

                            [2] => shop_currency
                        )

                    [6] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `shops`.`title` FROM `shops` WHERE (shop_id = item.shop_id) LIMIT 1)
                                )

                            [2] => shop_title
                        )

                    [7] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `countries_description`.`title` FROM `countries_description` WHERE (country_id = item.ship_from_country) AND (language_id = '1') LIMIT 1)
                                )

                            [2] => ship_from_country_title
                        )

                    [8] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `category_description`.`title` FROM `category_description` WHERE (category_id = item.category) AND (language_id = '1') LIMIT 1)
                                )

                            [2] => category_title
                        )

                    [9] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `category`.`parent_id` FROM `category` WHERE (category_id = item.category) LIMIT 1)
                                )

                            [2] => category_parent_id
                        )

                    [10] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `category`.`logo_img` FROM `category` WHERE (category_id = (SELECT `category`.`parent_id` FROM `category` WHERE (category_id = item.category) LIMIT 1)) LIMIT 1)
                                )

                            [2] => category_logo
                        )

                    [11] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `shops_section`.`title` FROM `shops_section` WHERE (section_id = item.shop_section) LIMIT 1)
                                )

                            [2] => shop_section_text
                        )

                    [12] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT SUM(quantity) FROM `item_quantity` WHERE (item = item.id) LIMIT 1)
                                )

                            [2] => item_quantity
                        )

                    [13] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `item_quantity`.`variation` FROM `item_quantity` WHERE (item = item.id) LIMIT 1)
                                )

                            [2] => variationid
                        )

                    [14] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `variation`.`value` FROM `variation` WHERE (id = (SELECT `item_quantity`.`variation` FROM `item_quantity` WHERE (item = item.id) LIMIT 1)) LIMIT 1)
                                )

                            [2] => variationvalue
                        )

                    [15] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `variation`.`parent` FROM `variation` WHERE (id = (SELECT `item_quantity`.`variation` FROM `item_quantity` WHERE (item = item.id) LIMIT 1)) LIMIT 1)
                                )

                            [2] => variationparent
                        )

                    [16] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT `variation`.`value` FROM `variation` WHERE (id = (SELECT `variation`.`parent` FROM `variation` WHERE (id = (SELECT `item_quantity`.`variation` FROM `item_quantity` WHERE (item = item.id) LIMIT 1)) LIMIT 1)) LIMIT 1)
                                )

                            [2] => variation
                        )

                    [17] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT(picture,"|",store) FROM `picture` WHERE (id = @item_picture_id) LIMIT 1)
                                )

                            [2] => picture_concate
                        )

                    [18] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT_WS('|||',image,width,height,original,mime) FROM `picture_temp` WHERE (id = @item_picture_id) AND (size = '_A') LIMIT 1)
                                )

                            [2] => picture_a
                        )

                    [19] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT_WS('|||',image,width,height,original,mime) FROM `picture_temp` WHERE (id = @item_picture_id) AND (size = '_B') LIMIT 1)
                                )

                            [2] => picture_b
                        )

                    [20] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT_WS('|||',image,width,height,original,mime) FROM `picture_temp` WHERE (id = @item_picture_id) AND (size = '_C') LIMIT 1)
                                )

                            [2] => picture_c
                        )

                    [21] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT_WS('|||',image,width,height,original,mime) FROM `picture_temp` WHERE (id = @item_picture_id) AND (size = '_D') LIMIT 1)
                                )

                            [2] => picture_d
                        )

                    [22] => Array
                        (
                            [0] => item
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => 0
                                )

                            [2] => is_liked
                        )

                    [23] => Array
                        (
                            [0] => users
                            [1] => user_id
                            [2] => user_user_id
                        )

                    [24] => Array
                        (
                            [0] => users
                            [1] => username
                            [2] => user_username
                        )

                    [25] => Array
                        (
                            [0] => users
                            [1] => password
                            [2] => user_password
                        )

                    [26] => Array
                        (
                            [0] => users
                            [1] => email
                            [2] => user_email
                        )

                    [27] => Array
                        (
                            [0] => users
                            [1] => new_email
                            [2] => user_new_email
                        )

                    [28] => Array
                        (
                            [0] => users
                            [1] => new_email_key
                            [2] => user_new_email_key
                        )

                    [29] => Array
                        (
                            [0] => users
                            [1] => firstname
                            [2] => user_firstname
                        )

                    [30] => Array
                        (
                            [0] => users
                            [1] => lastname
                            [2] => user_lastname
                        )

                    [31] => Array
                        (
                            [0] => users
                            [1] => groups
                            [2] => user_groups
                        )

                    [32] => Array
                        (
                            [0] => users
                            [1] => status
                            [2] => user_status
                        )

                    [33] => Array
                        (
                            [0] => users
                            [1] => last_action_datetime
                            [2] => user_last_action_datetime
                        )

                    [34] => Array
                        (
                            [0] => users
                            [1] => ip_address
                            [2] => user_ip_address
                        )

                    [35] => Array
                        (
                            [0] => users
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => 0
                                )

                            [2] => user_following
                        )

                    [36] => Array
                        (
                            [0] => users
                            [1] => followers
                            [2] => user_followers
                        )

                    [37] => Array
                        (
                            [0] => users
                            [1] => avatar
                            [2] => user_avatar
                        )

                    [38] => Array
                        (
                            [0] => users
                            [1] => is_admin
                            [2] => user_is_admin
                        )

                    [39] => Array
                        (
                            [0] => users
                            [1] => is_developer
                            [2] => user_is_developer
                        )

                    [40] => Array
                        (
                            [0] => users
                            [1] => gender
                            [2] => user_gender
                        )

                    [41] => Array
                        (
                            [0] => users
                            [1] => location
                            [2] => user_location
                        )

                    [42] => Array
                        (
                            [0] => users
                            [1] => website
                            [2] => user_website
                        )

                    [43] => Array
                        (
                            [0] => users
                            [1] => date_added
                            [2] => user_date_added
                        )

                    [44] => Array
                        (
                            [0] => users
                            [1] => new_password
                            [2] => user_new_password
                        )

                    [45] => Array
                        (
                            [0] => users
                            [1] => new_password_key
                            [2] => user_new_password_key
                        )

                    [46] => Array
                        (
                            [0] => users
                            [1] => boards
                            [2] => user_boards
                        )

                    [47] => Array
                        (
                            [0] => users
                            [1] => pins
                            [2] => user_pins
                        )

                    [48] => Array
                        (
                            [0] => users
                            [1] => likes
                            [2] => user_likes
                        )

                    [49] => Array
                        (
                            [0] => users
                            [1] => latest_pins
                            [2] => user_latest_pins
                        )

                    [50] => Array
                        (
                            [0] => users
                            [1] => description
                            [2] => user_description
                        )

                    [51] => Array
                        (
                            [0] => users
                            [1] => dont_search_index
                            [2] => user_dont_search_index
                        )

                    [52] => Array
                        (
                            [0] => users
                            [1] => delete_account
                            [2] => user_delete_account
                        )

                    [53] => Array
                        (
                            [0] => users
                            [1] => delete_account_date
                            [2] => user_delete_account_date
                        )

                    [54] => Array
                        (
                            [0] => users
                            [1] => groups_pin_email
                            [2] => user_groups_pin_email
                        )

                    [55] => Array
                        (
                            [0] => users
                            [1] => comments_email
                            [2] => user_comments_email
                        )

                    [56] => Array
                        (
                            [0] => users
                            [1] => likes_email
                            [2] => user_likes_email
                        )

                    [57] => Array
                        (
                            [0] => users
                            [1] => repins_email
                            [2] => user_repins_email
                        )

                    [58] => Array
                        (
                            [0] => users
                            [1] => follows_email
                            [2] => user_follows_email
                        )

                    [59] => Array
                        (
                            [0] => users
                            [1] => email_interval
                            [2] => user_email_interval
                        )

                    [60] => Array
                        (
                            [0] => users
                            [1] => digest_email
                            [2] => user_digest_email
                        )

                    [61] => Array
                        (
                            [0] => users
                            [1] => news_email
                            [2] => user_news_email
                        )

                    [62] => Array
                        (
                            [0] => users
                            [1] => first_login
                            [2] => user_first_login
                        )

                    [63] => Array
                        (
                            [0] => users
                            [1] => store
                            [2] => user_store
                        )

                    [64] => Array
                        (
                            [0] => users
                            [1] => width
                            [2] => user_width
                        )

                    [65] => Array
                        (
                            [0] => users
                            [1] => height
                            [2] => user_height
                        )

                    [66] => Array
                        (
                            [0] => users
                            [1] => enable_follow
                            [2] => user_enable_follow
                        )

                    [67] => Array
                        (
                            [0] => users
                            [1] => public
                            [2] => user_public
                        )

                    [68] => Array
                        (
                            [0] => users
                            [1] => bday
                            [2] => user_bday
                        )

                    [69] => Array
                        (
                            [0] => users
                            [1] => last_activity_view
                            [2] => user_last_activity_view
                        )

                    [70] => Array
                        (
                            [0] => users
                            [1] => new_conversation
                            [2] => user_new_conversation
                        )

                    [71] => Array
                        (
                            [0] => users
                            [1] => is_guest
                            [2] => user_is_guest
                        )

                    [72] => Array
                        (
                            [0] => users
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => users.username
                                )

                            [2] => user_fullname
                        )

                    [73] => Array
                        (
                            [0] => users
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT_WS('|||',image,width,height,original,mime) FROM `users_avatars` WHERE (user_id = users.user_id) AND (size = '_A') LIMIT 1)
                                )

                            [2] => user_avatar_a
                        )

                    [74] => Array
                        (
                            [0] => users
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT_WS('|||',image,width,height,original,mime) FROM `users_avatars` WHERE (user_id = users.user_id) AND (size = '_B') LIMIT 1)
                                )

                            [2] => user_avatar_b
                        )

                    [75] => Array
                        (
                            [0] => users
                            [1] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT CONCAT_WS('|||',image,width,height,original,mime) FROM `users_avatars` WHERE (user_id = users.user_id) AND (size = '_C') LIMIT 1)
                                )

                            [2] => user_avatar_c
                        )

                )

            [union] => Array
                (
                )

            [from] => Array
                (
                    [item] => Array
                        (
                            [joinType] => from
                            [schema] => 
                            [tableName] => item
                            [joinCondition] => 
                        )

                    [row] => Array
                        (
                            [joinType] => inner join
                            [schema] => 
                            [tableName] => JO_Db_Expr Object
                                (
                                    [_expression:protected] => (SELECT @curRow := -1)
                                )

                            [joinCondition] => 
                        )

                    [users] => Array
                        (
                            [joinType] => left join
                            [schema] => 
                            [tableName] => users
                            [joinCondition] => item.user = users.user_id
                        )

                )

            [where] => Array
                (
                    [0] => (`item`.`category` IN (2147))
                    [1] => AND (item.active = 1)
                    [2] => AND ((SELECT `shop_active`.`active` FROM `shops` AS `shop_active` WHERE (shop_active.shop_id = item.shop_id) LIMIT 1) = 1)
                )

            [group] => Array
                (
                )

            [having] => Array
                (
                )

            [order] => Array
                (
                    [0] => JO_Db_Expr Object
                        (
                            [_expression:protected] => item.id DESC
                        )

                )

            [limitcount] => 10
            [limitoffset] => 0
            [forupdate] => 
        )

    [_tableCols:protected] => Array
        (
        )

)