Hello

i want to make query like this

       SELECT 
            post_title,
            user_id, 
            name, 
            surname, 
            group_concat(additional_option_name separator ', ') additional_option_name,
            group_concat(ask_user separator ', ') ask_user,
            Sum(additional_option_price) additional_option_price
        FROM users
        LEFT JOIN event_items on users.id = event_items .id
        LEFT JOIN event_items_additional on users.id = event_items_additional .event_items_id
        LEFT JOIN event_items_ask_user on users.id = event_items_ask_user .event_items_id
        GROUP BY post_title, user_id, name, surname  
        ORDER BY `users`.`name` ASC;

this query works normally in my DB and returns this table

When i pass it like that

$this->src('skaleo')->query('
        SELECT 
            post_title,
            user_id, 
            name, 
            surname, 
            group_concat(additional_option_name separator ', ') additional_option_name,
            group_concat(ask_user separator ', ') ask_user,
            Sum(additional_option_price) additional_option_price
        FROM users
        LEFT JOIN event_items on users.id = event_items .id
        LEFT JOIN event_items_additional on users.id = event_items_additional .event_items_id
        LEFT JOIN event_items_ask_user on users.id = event_items_ask_user .event_items_id
        GROUP BY post_title, user_id, name, surname  
        ORDER BY `users`.`name` ASC;
        ')
        ->pipe($this->dataStore('test'));

but i get error " Uncaught TypeError: number_format(): Argument #1 ($num) must be of type float, string given "

also I try using QueryBulider

$this->src('skaleo')
            ->query(
                DB::table("users")
->leftJoin("event_items ",'users.id','=','event_items .id')          
->leftJoin("event_items_additional ",'users.id','=','event_items_additional .event_items_id')                    ->leftJoin("event_items_ask_user ",'users.id','=','event_items_ask_user .event_items_id')
  ->select(
                       "name",
                        "surname",
                        "post_title",
                        "additional_option_name",
                        "group_concat(additional_option_name) additional_option_name",
                       "group_concat(additional_option_price) additional_option_price",
                       "`event_items_additional`.`currency`",
                       "ask_user",
                       "`event_items_ask_user`.`answer`"
                    )->alias("additional_option_name")

            ) ->pipe($this->dataStore("asks"))

but this time its join all rows in one like that

cant's see my mistake

Greetengs

I did it by used procedure. Thanks for help :)