SELECT (SELECT `alias484846672`.`competition_Name` 
                            FROM `ys_competition_setup` AS `alias484846672` 
                            WHERE `alias484846672`.`competition_ID` = `ys_volunteer_setup`.`competition_ID` 
                            LIMIT 1) 
                            AS `rel.ys_volunteer_setup.competition_ID`, 
 `ys_volunteer_setup`.`competition_ID` AS `ys_volunteer_setup.competition_ID` 
,(SELECT `alias1838598596`.`event_Name` 
                            FROM `lk_event` AS `alias1838598596` 
                            WHERE `alias1838598596`.`event_ID` = `ys_volunteer_setup`.`event_ID` 
                            LIMIT 1) 
                            AS `rel.ys_volunteer_setup.event_ID`, 
 `ys_volunteer_setup`.`event_ID` AS `ys_volunteer_setup.event_ID` 
,(SELECT `alias1923896038`.`position_Name` 
                            FROM `lk_position_in_event` AS `alias1923896038` 
                            WHERE `alias1923896038`.`position_ID` = `ys_volunteer_setup`.`position_ID` 
                            LIMIT 1) 
                            AS `rel.ys_volunteer_setup.position_ID`, 
 `ys_volunteer_setup`.`position_ID` AS `ys_volunteer_setup.position_ID` 
,`ys_volunteer_setup`.`V_time_array` AS `ys_volunteer_setup.V_time_array` 
,`ys_volunteer_setup`.`volunteer_Name` AS `ys_volunteer_setup.volunteer_Name` 
,`ys_volunteer_setup`.`phone_number` AS `ys_volunteer_setup.phone_number` 
,`ys_volunteer_setup`.`position_in_Competition_ID` AS `primary_key` 
 
 FROM `ys_volunteer_setup`
 
 
 
 LIMIT 0,25