SELECT *
FROM `products`
LEFT JOIN `category` ON `products`.`cid`=`category`.`cid`
LEFT JOIN `subcategory` ON `products`.`sid`=`subcategory`.`sid`
WHERE `products`.`slugs` = 'philadelphia-flyers-vector'
AND `products`.`pstatus` = ''CI_DB_mysqli_result Object
(
    [conn_id] => mysqli Object
        (
            [affected_rows] => 1
            [client_info] => mysqlnd 7.4.33
            [client_version] => 70433
            [connect_errno] => 0
            [connect_error] => 
            [errno] => 0
            [error] => 
            [error_list] => Array
                (
                )

            [field_count] => 69
            [host_info] => Localhost via UNIX socket
            [info] => 
            [insert_id] => 0
            [server_info] => 5.7.44
            [server_version] => 50744
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 366236
            [warning_count] => 0
        )

    [result_id] => mysqli_result Object
        (
            [current_field] => 0
            [field_count] => 69
            [lengths] => 
            [num_rows] => 1
            [type] => 0
        )

    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [custom_result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 
    [row_data] => 
)